Datastage Developer- Pan India Infosys

Infosys; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 900,000 - 1,300,000; Full time

Job summary

Infosys in Hyderabad is seeking a skilled ETL engineer specializing in IBM DataStage. The role focuses on designing, developing, and deploying DataStage-based ETL jobs, with responsibilities spanning data mapping, validation, and performance optimization.

You'll work with business analysts and data architects to understand requirements and ensure data integrity across various source systems and target databases. Proficiency in SQL and shell scripting is essential.

Qualifications

• BE/B.Tech/MCA/M.Tech/MSc./MS or equivalent required.
• Strong experience with IBM DataStage and ETL development.
• Knowledge of Oracle, SQL Server, Teradata, DB2 and related databases.
• Experience with DataStage Parallel/Server Jobs, Sequences and scheduling.
• Understanding of data warehousing concepts and data modeling.
• Proficiency in performance tuning and ETL optimization.
• Familiarity with Unix/Linux commands and shell scripting.
• Excellent debugging and problem-solving skills.

Responsibilities

• Design, develop, test, and deploy ETL jobs using IBM DataStage.
• Extract, transform, and load data from multiple sources to target databases.
• Develop and maintain DataStage parallel and server jobs.
• Perform data mapping, cleansing, and validation activities.
• Troubleshoot job failures and resolve performance issues.
• Optimize ETL workflows for efficiency and scalability.
• Collaborate with analysts, data architects, and stakeholders to gather requirements.
• Implement data quality checks and ensure data integrity.
• Create technical docs and process diagrams.
• Support production deployments and post-deployment activities.

Skills

IBM DataStage

ETL Development

SQL & Databases

DataStage Parallel/Server

Data Warehousing concepts

Performance tuning

Unix/Linux scripting

Debugging & Troubleshooting

Education

BE/B.Tech/MCA/M.Tech/MSc./MS

Job description

Job description

Mandatory Skills: IBM Infosphere Datastage

Education: BE/B.Tech/MCA/M.Tech/MSc./MS

Responsibilities

• Design, develop, test, and deploy ETL jobs using IBM DataStage.
• Extract, transform, and load data from multiple source systems to target databases.
• Develop and maintain DataStage parallel and server jobs.
• Perform data mapping, data cleansing, and data validation activities.
• Troubleshoot job failures and resolve performance issues.
• Optimize ETL workflows for efficiency and scalability.
• Work closely with business analysts, data architects, and stakeholders to understand requirements.
• Implement data quality checks and ensure data integrity.
• Create technical documents, job flow diagrams, and process documentation.
• Support production deployments and provide post-deployment support.

Required Skills

• Strong experience with IBM DataStage.
• Expertise in ETL Development and Data Integration.
• Strong SQL and database knowledge (Oracle, SQL Server, Teradata, DB2, etc.).
• Experience with DataStage Parallel Jobs, Server Jobs, Sequences, and Job Scheduling.
• Knowledge of Data Warehousing concepts and Data Modeling.
• Experience in performance tuning and ETL optimization.
• Familiarity with Unix/Linux commands and Shell Scripting.
• Strong debugging and troubleshooting skills.