Datastage Consultant

Infosys; Hyderabad, Chennai District, Bengaluru; On-site; INR 600,000 - 1,100,000; Full time

Job summary

Infosys in Hyderabad, India is seeking a skilled DataStage Developer to design, develop, test, and maintain ETL processes using IBM InfoSphere DataStage. You will work on data integration, warehousing, and database technologies to deliver reliable data solutions.

Responsibilities include building ETL jobs, optimizing performance, validating data quality, and collaborating with data architects and DBAs to ensure scalable deployments and proper documentation.

Qualifications

• Experience with IBM InfoSphere DataStage
• Strong understanding of ETL concepts and data warehousing principles
• Experience with SQL and relational databases such as Oracle, SQL Server, DB2, or PostgreSQL
• Knowledge of data modeling concepts
• Experience in Unix/Linux shell scripting
• Knowledge of performance tuning and optimization techniques
• Familiarity with job scheduling tools such as Control-M or Autosys
• Strong analytical and problem-solving skills

Responsibilities

• Design, develop, and implement ETL jobs using IBM InfoSphere DataStage.
• Analyze business and technical requirements for data integration solutions.
• Develop and optimize DataStage jobs for performance and scalability.
• Extract, transform, and load data from multiple source systems into data warehouses and data marts.
• Perform unit testing, system testing, and defect resolution.
• Troubleshoot ETL failures and provide production support.
• Work closely with business analysts, data architects, and database administrators.
• Create and maintain technical documentation, including ETL design specifications and deployment procedures.
• Ensure data quality, integrity, and compliance with organizational standards.

Skills

DataStage

ETL concepts

SQL & RDBMS

Data modeling

Unix/Linux scripting

Performance tuning

Job scheduling

Analytical skills

Tools

Control-M

Autosys

Job description

We are seeking a skilled DataStage Developer to design, develop, test, and maintain ETL processes using IBM Infosphere DataStage. The ideal candidate will have experience in data integration, data warehousing, and database technologies, with the ability to deliver high-quality data solutions that support business requirements.

Key Responsibilities

• Design, develop, and implement ETL jobs using IBM InfoSphere DataStage.
• Analyze business and technical requirements for data integration solutions.
• Develop and optimize DataStage jobs for performance and scalability.
• Extract, transform, and load data from multiple source systems into data warehouses and data marts.
• Perform unit testing, system testing, and defect resolution.
• Troubleshoot ETL failures and provide production support.
• Work closely with business analysts, data architects, and database administrators.
• Create and maintain technical documentation, including ETL design specifications and deployment procedures.
• Ensure data quality, integrity, and compliance with organizational standards.

Required Skills

• Strong experience with IBM InfoSphere DataStage.
• Knowledge of ETL concepts and data warehousing principles.
• Experience with SQL and relational databases such as Oracle, SQL Server, DB2, or PostgreSQL.
• Strong understanding of data modeling concepts.
• Experience in Unix/Linux shell scripting.
• Knowledge of performance tuning and optimization techniques.
• Familiarity with job scheduling tools such as Control-M or Autosys.
• Strong analytical and problem-solving skills