Datastage Developer

SAN Engineering Solutions; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

SAN Engineering Solutions in Chennai is seeking a DataStage Developer to design and optimize ETL jobs using IBM InfoSphere DataStage. The role focuses on handling large data volumes, building parallel/server/sequence jobs, and ensuring data quality.

Candidate will work with DataStage stages, parameter sets, and Unix shell scripts, with responsibilities spanning job scheduling and performance tuning to meet efficiency targets.

Qualifications

• Strong experience in IBM InfoSphere DataStage Development and ETL processes.

Responsibilities

• ],

Tools

IBM InfoSphere DataStage

ETL Processes

Parallel Jobs

Server Jobs

Sequence Jobs

DataStage Stages

SQL & DB Connectivity

Unix Shell Scripting

Job Scheduling

Performance Tuning

Large Volume Data

Data Validation & Quality

Job description

• Strong experience in IBM InfoSphere DataStage Development and ETL processes.
• Hands on experience with Parallel Jobs, Server Jobs and Sequence Job.
• Should have good Knowledge in DataStage all the stages like processing stages, file stages ,Debugging stages.
• Experience in developing ETL mappings and complex transformation logic.
• Strong Knowledge of Datastage Parameters, Parameter sets and environment variables, and Job Sequences.
• Experience with Execute Command activity and Unix shell scripts.
• Experience in Job Scheduling ,Monitoring ,troubleshooting and performance tuning.
• Knowledge of SQL and database connectivity ,including DB2,Teradata,Snowflake.
• Experience in handling Large Volume data and optimizing ETL jobs.
• Should have good understanding of source to target Mapping ,data Validation, Reconciliation and data quality