ETL / DataStage Engineer

IT Associates
Chicago, IL, United States
7 days ago
Apply on www.disabledperson.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$124,800.0 - $131,040.0
Working hours
Regular working hours

Tech stack

Adobe InDesign Agile Methodology Cloud Database Code Review Data Infrastructure Data Integration Extract Transform Load (ETL) IBM DB2 Relational Databases Database Queries IBM InfoSphere DataStage Microsoft SQL Server
+8 more
Oracle (Applications) Scrum Methodology Teradata SQL Data Processing Freeform SQL Azure Data Factory Ab Initio Data Pipelines

Job description

  • 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

Requirements

We are seeking an experienced ETL / Data Integration Engineer to design, build, and maintain robust data pipelines that support enterprise data integration and analytics initiatives. The ideal candidate has strong hands-on experience with ETL/ELT tools-preferably DataStage-and is comfortable working independently while collaborating within Agile teams., * 5+ years of hands-on ETL/ELT development experience

  • Strong expertise in DataStage (preferred) or equivalent tools such as Informatica or Ab Initio
  • Proven experience building and maintaining enterprise-scale data integration pipelines
  • Strong SQL skills and experience working with relational databases such as Oracle, DB2, SQL Server, or Teradata
  • Ability to work independently, manage priorities, and deliver high-quality solutions on time
  • Strong problem-solving and troubleshooting skills

Preferred Qualifications

  • Working knowledge of Azure data services, including Synapse Analytics and Notebooks
  • Experience supporting ETL processes in production environments
  • Familiarity with cloud-based data architectures and modern data platforms

Work Environment

  • Agile, collaborative team environment
  • Opportunity to work on complex data integration challenges
  • Balance of independent ownership and cross-functional collaboration

Benefits & conditions

The anticipated hourly rate range for this position is ($60-$63/hr). Actual hourly rate will be based on a variety of factors including relevant experience, knowledge, skills and other factors permitted by law. A range of medical, dental, retirement and/or other benefits are available after a waiting period.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.disabledperson.com
Prepare application

Good distractions

Loading talks and stories from around this role…