IBM Data stage Developer
About The Position
An experienced IBM DataStage ETL Developer with over 5 years of hands-on experience in designing, developing, and supporting enterprise data integration solutions. Skilled in understanding business requirements, mapping documents, and translating them into scalable, end-to-end ETL applications using IBM DataStage. Strong knowledge of the Software Development Life Cycle (SDLC) with a proven track record of delivering high-quality 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 L1/L2 escalations, conducting root cause analysis, and implementing preventive measures to improve system stability. Hands-on experience with Unix shell scripting, Control-M scheduling, ServiceNow, JIRA/ADO, 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.
Requirements
- Over 5 years of hands-on experience in designing, developing, and supporting enterprise data integration solutions.
- Experience with IBM DataStage.
- Strong knowledge of the Software Development Life Cycle (SDLC).
- Experience developing DataStage jobs to extract, transform, validate, and load data from multiple sources (Oracle databases, flat files, CSV, text, Excel, external systems).
- Proficiency in writing complex SQL queries.
- Experience building JSON files using DataStage Hierarchical Stages.
- Experience implementing data quality checks.
- Strong production support background.
- Expertise in troubleshooting ETL failures.
- Experience addressing L1/L2 escalations.
- Experience conducting root cause analysis.
- Hands-on experience with Unix shell scripting.
- Hands-on experience with Control-M scheduling.
- Hands-on experience with ServiceNow.
- Hands-on experience with JIRA/ADO.
- Hands-on experience with Confluence.
- Data Architecture skills.
- ETL Concepts knowledge.
- IIS-Datastage skills.
Responsibilities
- Designing, developing, and supporting enterprise data integration solutions using IBM DataStage.
- Understanding business requirements and mapping documents.
- Translating business requirements into scalable, end-to-end ETL applications.
- Developing DataStage jobs to extract, transform, validate, and load data from multiple sources.
- Writing complex SQL queries for data extraction, validation, reconciliation, and performance optimization.
- Building JSON files using DataStage Hierarchical Stages.
- Implementing data quality checks (structural, data type, business rule validations).
- Troubleshooting ETL failures and addressing L1/L2 escalations.
- Conducting root cause analysis and implementing preventive measures.
- Collaborating with SMEs, Business Analysts, Architects, and Development teams.
- Driving operational excellence through automation and continuous improvement.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
