Data Stage Developer

Capgemini; Hyderabad, Pune District, Bengaluru; Hybrid; INR 900,000 - 1,300,000; Full time

Job summary

Capgemini in Hyderabad is seeking a hands-on ETL Developer to design, develop and deploy DataStage-based ETL solutions. You will translate business requirements into robust ETL specifications and build complex DataStage jobs, including parallel and server jobs, across multiple source systems.

You will optimize ETL performance, troubleshoot production issues, and contribute to reusable components and ETL frameworks while collaborating with Data Architects, BI leads, and application teams to

Qualifications

• Strong hands-on experience with IBM InfoSphere DataStage.
• Experience in developing Parallel Jobs, Sequence Jobs, Shared Containers, and Job Sequencers.
• Strong SQL and database skills (Oracle, SQL Server, DB2, Teradata, etc.).
• Good understanding of Data Warehousing and ETL concepts.
• Experience with data migration and integration projects.
• Knowledge of job performance tuning and optimization.
• Experience in Unix/Linux shell scripting.
• Understanding of SDLC, Agile methodologies, and release management.

Responsibilities

• Design, develop, test, and deploy ETL solutions using IBM InfoSphere DataStage.
• Analyze business requirements and translate them into technical ETL specifications.
• Develop complex DataStage jobs including parallel and server jobs.
• Perform data extraction, transformation, and loading (ETL) from multiple source systems.
• Optimize DataStage jobs for performance, scalability, and reliability.
• Troubleshoot production issues and provide root cause analysis.
• Develop reusable components and ETL frameworks.
• Work closely with Data Architects, Business Analysts, and Application Teams.
• Support data quality, data validation, and reconciliation activities.
• Participate in code reviews, testing, and deployment activities.

Skills

SQL

Data Warehousing

SDLC

Agile methodologies

Release management

Tools

IBM InfoSphere DataStage

Parallel Jobs

Sequence Jobs

Shared Containers

Job Sequencers

Unix/Linux shell scripting

Job description

• Design, develop, test, and deploy ETL solutions using IBM InfoSphere DataStage.
• Analyze business requirements and translate them into technical ETL specifications.
• Develop complex DataStage jobs including parallel and server jobs.
• Perform data extraction, transformation, and loading (ETL) from multiple source systems.
• Optimize DataStage jobs for performance, scalability, and reliability.
• Troubleshoot production issues and provide root cause analysis.
• Develop reusable components and ETL frameworks.
• Work closely with Data Architects, Business Analysts, and Application Teams.
• Support data quality, data validation, and reconciliation activities.
• Participate in code reviews, testing, and deployment activities.

Required Skills

• Strong hands-on experience with IBM InfoSphere DataStage.
• Experience in developing Parallel Jobs, Sequence Jobs, Shared Containers, and Job Sequencers.
• Strong SQL and database skills (Oracle, SQL Server, DB2, Teradata, etc.).
• Good understanding of Data Warehousing and ETL concepts.
• Experience with data migration and integration projects.
• Knowledge of job performance tuning and optimization.
• Experience in Unix/Linux shell scripting.
• Understanding of SDLC, Agile methodologies, and release management.