Description :

Exp : 5+ Years

Job Mode : Hybrid

Job Summary :

We are looking for a highly skilled IBM DataStage Developer with strong expertise in ETL development, job analysis, and migration projects. The ideal candidate should have hands-on experience in DataStage Server jobs (mandatory) and a good understanding of Parallel jobs, along with strong SQL and Unix skills.

The role involves working on legacy system analysis, data migration, and modernization initiatives in collaboration with cross-functional teams.

Key Responsibilities :

- Design, develop, and maintain ETL workflows using IBM DataStage

- Analyze and reverse-engineer existing DataStage jobs including stage logic, transformations, and dependencies

- Work extensively on Server Jobs (mandatory) and Parallel Jobs

- Develop and manage job sequences, job control logic, and reusable routines

- Perform data extraction, transformation, and loading (ETL) including joins, lookups, and aggregations

- Conduct data validation, reconciliation, and like-for-like testing against legacy systems

- Create detailed documentation for ETL processes, workflows, and job logic

- Perform lineage discovery and dependency mapping for migration and impact analysis

- Optimize jobs for performance tuning and efficiency

- Collaborate with Databricks/Spark teams during migration and validation phases

- Work with Unix/Shell scripting for file handling and automation tasks

- Rewrite and customize existing routines/scripts as part of modernization initiatives

- Implement data quality checks, logging, and error-handling mechanisms

- Support migration projects (DataStage to Cloud/Spark platforms)

Mandatory Skills :

- Strong hands-on experience with IBM DataStage (Server Jobs mandatory)

- Experience in Parallel Jobs

- Strong SQL expertise (Teradata / Oracle / MS SQL Server)

- Proficiency in ETL concepts and development

- Experience with job sequences, reusable routines, and job control logic

- Hands-on experience in Unix/Shell scripting

- Strong skills in data validation and reconciliation

- Ability to analyze, troubleshoot, and optimize DataStage jobs

- Strong analytical, problem-solving, and communication skills

Good to Have Skills :

- Exposure to Databricks / Apache Spark / PySpark

- Experience in DataStage to Cloud migration / modernization projects

- Knowledge of data lineage, metadata management, and dependency mapping

- Familiarity with automation or GenAI tools for code conversion

- Understanding of modern data platforms and architectures

Preferred Candidate Profile :

- Experience working in large-scale ETL and data migration projects

- Ability to work in a fast-paced, collaborative environment

- Strong communication skills to interact with business and technical teams

- Experience in financial services / enterprise data environments is a plus