Senior ETL/DataStage Engineer - Enterprise Data Pipelines

IT Associates

Chicago (IL)

On-site

USD 83,000 - 87,000

Full time

48 hours ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

IT Associates is seeking an experienced ETL / Data Integration Engineer to design, build, and maintain robust data pipelines for enterprise data integration and analytics. The role emphasizes DataStage proficiency, strong SQL, and independent collaboration within Agile teams.

The ideal candidate will contribute to end-to-end data processing, performance optimization, and data quality initiatives across multiple sources.

Qualifications

5+ years of hands-on ETL/ELT development experience.
Strong DataStage expertise or equivalent tools such as Informatica or Ab Initio.
Experience building enterprise-scale data integration pipelines.
Strong SQL skills with Oracle/DB2/SQL Server/Teradata.
Ability to work independently and deliver on time in Agile teams.

Responsibilities

Design, develop, and maintain ETL/ELT pipelines to support data integration and transformation across multiple data sources.
Build and optimize workflows using DataStage or similar ETL tools (e.g., Informatica, Ab Initio).
Collaborate with architects and team members in design discussions and participate in code reviews, contributing practical and scalable solutions.
Develop and optimize complex SQL queries to support data processing and validation.
Ensure data quality, reliability, and performance across all ETL processes.
Troubleshoot and resolve data pipeline issues; provide production support as needed.
Take ownership of assigned deliverables and drive tasks through to completion with minimal guidance.
Actively participate in Agile ceremonies, including stand‑ups, sprint planning, and retrospectives.