ETL Developer

ETL Developer

15 Jun 2024
Illinois, Chicago, 60601 Chicago USA

ETL Developer

Vacancy expired!

Project Overview:
Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Compliance Applications. If you are interested in this position, please send your resume to Korey Decker at

Contractor's Role:
The role will revolve around the building and supporting of the DataStage ETL(s) as well as working with current application development team to drive superior business value, enhanced customer experience and compliance with NT standards.

Experience Level:
Mid-level 3-5 years

Qualifications:
• Strong in PL/SQL and UNIX shell scripting.
• Experience working with XML transformation and consumption of messages from queues will be a big plus.
• Hands-on improve operational stability via automation, such as autohealing where possible, and raise design changes to Data analyst, SMEs and/or architects, as well as opportunities to application /service managers.
• Work some off hours as demanded by projects, operations, and need of the on-shore team and stakeholders, such as release, testing and/or critical bug resolutions.
• Provide EMEA overnight support on critical processes in AML and/or risk program, such as data feed batch jobs, reports, etc in a follow the sun model, and able to address tickets escalated by L1/L2 teams.

Nice to Haves: N/A

Tasks and Responsibilites:
• Work with SME, Business Analyst to build new End-to-End solution, ensuring solutions meet all requirements, including operational SLAs.
• Write and debug complex SQL queries from databases (such as Oracle).
• Work with data analyst in mapping documents and design/build IBM DataStage jobs to the requirements.
• Participate in peer design reviews and provide recommendations.
• Construct DataStage jobs to implement the requirements:
o Extract the data from and to Oracle and other databases, flat files (csv, text, excel)
o Build JSON files using Hierarchical stage
o Perform structural validation
o Data type/allowable values validations and reporting
• Ensure all data mapping, data lineage, functional spec, and any other technical documentation are detailed and up to date.
• Ensure runbooks are fully up-to date and consistently improving the efficiency derived from automation.
• Ensure handover of issues region to region with precise and concise handover daily shift notes.
• Support incidents management during incident lifecycle by resolving service stoppage and remediation activities, as well as any post mortem actions.
• Support management in operational reporting on vendor issues, internal issues, and partner team issues, and respective root causes.
• Responsible for development and maintenance of ETL code using DataStage 11.7. This is for a Contract-to-Hire position.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

Job Details

Jocancy Online Job Portal by jobSearchi.