Datastage Consultant

Coforge Limited; Hyderabad, Pune District; Hybrid; INR 2,800,000 - 4,200,000; Full time

Job summary

Coforge Limited in Hyderabad, India seeks an experienced ETL Developer with IBM InfoSphere DataStage expertise to design and maintain scalable ETL pipelines.

You will analyze source-to-target mappings, optimize jobs for performance, and collaborate with DBAs and reporting teams to ensure reliable data flows. 8+ years of hands-on DataStage experience and strong SQL skills are required.

The role emphasizes SDLC adherence, documentation, and proactive problem solving in production environments.

Qualifications

• 8+ years of hands-on ETL development with IBM DataStage.
• Strong SQL skills; comfortable with TOAD and/or Oracle SQL Developer.
• Experience on Linux/Unix environments and shell basics.

Responsibilities

• Develop and maintain ETL workflows using IBM InfoSphere DataStage 11.7.15.
• Analyze mappings and translate requirements into DataStage jobs, sequences, and reusable components.
• Perform ETL for large data volumes with performance and scalability best practices.
• Root-cause analysis for job failures, data issues, and bottlenecks; implement fixes and preventive controls.
• Follow SDLC practices (dev, unit testing, SIT/UAT, prod support).
• Create and maintain technical documentation (design, runbooks, procedures).
• Collaborate with DBAs, reporting, and application teams to ensure end-to-end data flow reliability.

Skills

ETL development

SQL

DataStage

Unix/Linux

Production support

Tools

IBM InfoSphere DataStage

TOAD

Oracle SQL Developer

Linux/Unix

ControlM

WinSCP

Job description

Job Description (JD): ETL DataStage

Key Responsibilities

• Develop and maintain ETL workflows using IBM InfoSphere DataStage 11.7.15 (Parallel/Server jobs as applicable).
• Analyze source-to-target mappings and translate requirements into DataStage jobs, sequences, and reusable components.
• Perform data extraction, transformation, and load (ETL) for large volumes with performance and scalability best practices.
• Perform root-cause analysis for job failures, data issues, and performance bottlenecks; implement fixes and preventive controls.
• Follow SDLC practices (development, unit testing, SIT/UAT support, production support).
• Create and maintain technical documentation (job design, runbooks, support procedures).
• Collaborate with upstream/downstream teams (DBAs, reporting, application teams) to ensure end-to-end data flow reliability.

Required Skills & Experience

• 8+ years of hands-on ETL development experience with IBM ETL DataStage
• Strong understanding of ETL concepts: joins/lookups, aggregations, SCD, incremental loads, error handling, restartability, audit controls.
• Solid SQL skills; comfortable using TOAD and/or Oracle SQL Developer for query development and tuning.
• Experience working on Linux/Unix environments; proficient with basic shell commands and log analysis (PuTTY usage).
• Understanding of production support processes: incident/problem management, on-call support, SLA-driven troubleshooting.

Preferred / Nice-to-Have

• Basic shell scripting for automation (e.g., Korn/Bash).
• Experience with performance tuning in DataStage (partitioning, buffering, parallelism, staging strategy).
• Knowledge of ETL operational controls: reject handling, reconciliation, checkpoint/restart strategies.
• Exposure to CI/CD or deployment processes for ETL (if applicable).
• Prior experience in regulated/enterprise environments with strong process controls.

Tools / Environment (as per project)

• ETL: IBM InfoSphere DataStage v11.7.15
• OS: Linux (access via PuTTY)
• SQL Tools: TOAD / Oracle SQL Developer
• Scheduling: ControlM v9.0.21
• File Transfer: WinSCP (prod server local desktop)

Soft Skills

• Strong problem-solving and debugging skills in production scenarios.
• Ability to work with minimal supervision and manage priorities under deadlines.
• Clear communication and documentation habits.