Senior DataStage ETL Engineer

New York Technology Partners

Cincinnati (OH)

On-site

USD 90,000 - 120,000

Full time

42 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

New York Technology Partners in Cincinnati seeks a DataStage Senior Developer with 5+ years of experience to design, develop, and support enterprise ETL solutions using IBM InfoSphere DataStage. You will collaborate with business stakeholders, data architects, and development teams to deliver high-quality data warehousing, data integration, and performance-optimized ETL processes.

The role requires strong SQL, database knowledge (Oracle/SQL Server), and experience with data quality and

Qualifications

Bachelor’s degree in CS/IT/Engineering or related field.
5+ years hands-on DataStage development.
Strong ETL and data integration knowledge.
Experience with large-volume data processing.
SDLC and Agile familiarity.

Responsibilities

Design, develop, test, and deploy ETL processes using IBM InfoSphere DataStage.
Analyze business requirements and translate them into technical ETL solutions.
Develop and maintain DataStage jobs, sequences, shared containers, and reusable components.
Perform data extraction, transformation, and loading (ETL) from multiple source systems to data warehouses and data marts.
Optimize DataStage jobs for performance, scalability, and reliability.
Monitor ETL workflows and troubleshoot production issues.
Conduct data validation, reconciliation, and quality checks.
Work with database teams to design and implement efficient data models.
Create and maintain technical documentation, mapping documents, and deployment procedures.
Participate in code reviews and ensure adherence to development standards and best practices.
Support production releases, incident management, and root cause analysis.
Collaborate with cross-functional teams including Business Analysts, Architects, QA teams, and Support teams.