Avatar for IT Associates
IT Associates
Actively Hiring
IT staffing and recruiting firm providing nationwide IT solutions

ETL / DataStage Engineer

  • Remote () • 
    Warrenville
  • |5 years of exp
  • |Contract
Posted: 2 weeks ago• Recruiter recently active
Job Location
Warrenville
Remote Work Policy

In office - WFH flexibility

Visa Sponsorship

Not Available

RelocationAllowed
Skills
SQL
SQL Server
Db2
DataStage
Oracle
Teradata

About the job

3-8+ Month Contract Position

Location - Remote

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.

Key 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

Required Qualifications

  • 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

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.