IBM Data stage Developer

Cloudious LLC; Chicago (IL); On-site; USD 90,000 - 140,000; Full time

Job summary

Cloudious LLC in Chicago seeks an experienced IBM DataStage ETL Developer with 5+ years hands-on design, development, and support of enterprise data integration solutions. You will translate business requirements into scalable end-to-end ETL applications using DataStage.

You'll extract, transform, and load data from Oracle, flat files, CSV, text, and Excel, write complex SQL for validation and performance tuning, and provide production support.

Qualifications

• 5+ years of hands-on DataStage experience.
• Strong knowledge of ETL concepts and data architecture.
• Proficient in writing SQL for data extraction, validation and performance tuning.

Responsibilities

• Design, develop and support enterprise data integration solutions using IBM DataStage.
• Develop DataStage jobs to extract, transform, validate and load data from Oracle, flat files, CSV, text and Excel.
• Provide production support, troubleshoot ETL failures, analyze root causes and implement preventive measures.

Skills

Data Architecture

ETL Concepts

IIS-Datastage

Job description

Job Description :

An experienced IBM DataStage ETL Developer with over 5 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