IBM Data stage Developer

SOMERSET STAFFING; Chicago (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

SOMERSET STAFFING is seeking an IBM DataStage Developer in Chicago, IL. You will design, develop, and support enterprise DataStage ETL solutions with 8+ years hands-on experience, translating business requirements into scalable data integration processes.

The role emphasizes SDLC-driven development, complex SQL for data extraction and validation, and collaboration with cross-functional teams to ensure reliable and compliant data delivery.

Qualifications

• Mandatory Skills: Data Architecture, ETL Concepts, IIS-Datastage

Responsibilities

• Develop DataStage ETL jobs to extract, transform, validate and load data from multiple sources.
• Collaborate with SMEs, Analysts and Architects to deliver reliable data integration solutions.
• Provide production support and troubleshooting for ETL processes and data quality checks.

Skills

Data Architecture

ETL Concepts

IIS-Datastage

Tools

Unix Shell Scripting

Control-M

ServiceNow

JIRA

Confluence

ADO

Job description

Job Role: IBM Data stage Developer

Location :Chicago,Illinois

Job Description :

An experienced IBM DataStage ETL Developer with over 8 years of handson experience in designing developing and supporting enterprise data integration solutions Skilled in understanding business requirements mapping documents and translating them into scalable endtoend ETL applications using IBM DataStage Strong knowledge of the Software Development Life Cycle SDLC with a proven track record of delivering highquality data solutions

Extensive experience in developing DataStage jobs to extract transform validate and load data from multiple sources including Oracle databases flat files CSV text and Excel and external systems Proficient in writing complex SQL queries for data extraction validation reconciliation and performance optimization Experienced in building JSON files using DataStage Hierarchical Stages and implementing robust data quality checks including structural data type and business rule validations

Strong production support background with expertise in troubleshooting ETL failures addressing L1L2 escalations conducting root cause analysis and implementing preventive measures to improve system stability Handson experience with Unix shell scripting ControlM scheduling ServiceNow JIRAADO and Confluence for automation monitoring incident management and documentation Adept at collaborating with SMEs Business Analysts Architects and Development teams to deliver reliable compliant and efficient data integration solutions while driving operational excellence through automation and continuous improvement

Skills

Mandatory Skills : Data Architecture, ETL Concepts, IIS-Datastage

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No