Data Stage Developer

Tata Consultancy Services Limited; Hyderabad, Chennai, Bengaluru; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Tata Consultancy Services is seeking a DataStage Developer in India with 4+ years of experience to design, develop, and maintain DataStage ETL jobs. The role involves building scalable data pipelines, performing data validations, and collaborating with cross-functional teams to deliver high-quality data solutions.

Responsibilities include optimization for performance, troubleshooting production incidents, and deploying jobs with Control-M.

Qualifications

• 4+ years of hands-on experience in IBM DataStage ETL development.
• Strong SQL skills and data validation experience.
• Experience with data warehousing concepts, SCDs, and fact/dimension modeling.
• Experience in building reusable ETL components and job sequences.
• Proficient in data quality checks and performance tuning of DataStage jobs.

Responsibilities

• Design, develop, and maintain DataStage ETL jobs.
• Build scalable data pipelines from multiple source systems.
• Optimize DataStage jobs for performance and reliability.
• Troubleshoot ETL failures and production incidents.
• Collaborate with data architects, DBAs, and analysts to translate requirements.
• Deploy, schedule, and monitor DataStage jobs using Control-M.
• Prepare technical documentation and data flow diagrams.

Skills

DataStage

ETL Development

SQL

Data Warehousing

Performance Tuning

Tools

IBM DataStage

Control-M

Job description

Role: DataStage Developer

Experience: 4+

Location: Hyderabad, Bengaluru, Chennai,Pune

Responsibilities:

1. Design, develop, and maintain ETL jobs using IBM DataStage 11.x (Parallel and Server jobs).
2. Build scalable data pipelines for data extraction, transformation, and loading from multiple source systems.
3. Optimize DataStage jobs for high performance, reliability, and reusability.
4. Troubleshoot ETL failures, performance issues, and production incidents.
5. Work with SQL and relational databases to write complex queries and perform data validations.
6. Implement data warehousing concepts, including SCDs, fact/dimension modeling, and data quality checks.
7. Create job sequences, parameter sets, reusable components, and shared containers.
8. Collaborate with cross-functional teams (data architects, DBAs, business analysts) to translate requirements into ETL solutions.
9. Deploy, schedule, and monitor DataStage jobs using Control-M or similar scheduling tools.
10. Prepare technical documentation, data flow diagrams, and ETL process specifications.
11. 11.Work with stakeholders to understand business requirements and convert them into technical ETL solutions.
12. 12.Collaborate with data architects, DBAs, QA, and analytics teams.