Software Engineer [Multiple Positions Available]

DESCRIPTION:

Duties: Ensure all production jobs run within the Service Level Agreement (SLA) every day.

Support any major platform outages and upgrades and bring the applications back up to date by catching up all batch jobs.

Perform issue triage involving multiple platforms and application systems, including production code deployment with a multilayer and robust review for the change-under-change advisory board.

Perform data catch up if any issues occur to ensure the downstream application does not have any impact.

Perform code reviews and support production issue resolution, working with direct users and power users.

Automate metadata consolidation where metadata is stored on various platforms, ensuring the data from different systems is loaded in a single database.

Create a Tableau dashboard to capture the data movement status in the Cloud from legacy platforms using various legacy tools.

Review data reconciliation and data validation status by reading data from various reconciliation platforms developed within the firm.

QUALIFICATIONS:

Minimum education and experience required: Bachelor's degree in Computer Engineering, Software Engineering, Information Technology, or related field of study plus five (5) years of experience in the job offered or as Software Engineer, Technical Lead, Ab Initio/Software Developer, Systems Engineer, or related occupation.

Skills Required: This position requires experience with the following: Working on all components of Ab Initio GDE including rollup, join, scan, reformat, partitioning, MFS, sort, and dedup using GDE version 3.3 to 4.0; building, enhancing, conducting unit testing and performance review, and promoting the Ab Initio ETL code from DEV to higher environments including PROD while minimizing impacts to downstream testing and users; using Ab Initio GDE for graph analysis and working with document mapping; using performance optimization techniques including parallel processing, efficient data partitioning, and resource management for optimization; writing business rules in Ab Initio BRE to manage and execute complex decision logic and business rules independently from application code; using Informatica PowerCenter to perform ETL processing for large volumes of data using components including sorter, joiner, lookup, and expression transformation, and parsing non-conventional relational databases including XML and JSON; working with Informatica Repository Manager, PowerCenter Designer, Workflow Manager and Workflow Monitor; using Informatica BDM/DEI to handle large volumes of structured and unstructured data across on-premise and cloud environments using components including sorter, joiner, and expression transformation, and parsing non-conventional relational databases including XML and JSON; working with the Metadata Hub to maintain data quality, streamline data workflows, facilitate data discovery, and establish proper lineage for datasets from source to target; database management including ...