Role & responsibilities

Direct Responsibilities
ETL Development: Create, optimize, and maintain DataStage parallel jobs, sequences, and routines to move data from various sources to target data warehouses and data marts.
Data Transformation: Implement complex business logic using transformer stages, lookups, joins, aggregations, and sorting mechanisms.
Database & SQL Optimization: Write and optimize advanced SQL and PL/SQL queries to extract and manipulate data in relational databases like Oracle, DB2, or SQL Server.
Scripting & Automation: Develop Unix/Linux shell scripts to automate job scheduling, file monitoring, and operational pipelines.
Troubleshooting & Support: Monitor job execution, perform root cause analysis on failed data loads, and provide production support for data processing cycles.
Collaboration: Work with data architects, business analysts,



and testers to translate business rules into source-to-target mappings and technical specifications. Work closely in a one team approach with all stakeholders during all phases of the SDLC, jointly providing high quality deliverables
Testing: Participate in the testing phases (system, user acceptance, regression) as required while coordinating with BA, IT and QA teams
AI: Use AI tools LLM, APIs etc

Preferred candidate profile
IBM InfoSphere DataStage Designer, Director, and Administrator
SQL and Unix shell scripting
Oracle 19c

Key outputs
Feature implementations
Test cases
Documentation
Performance improvements

📌 Ibm Datastage Etl Developer Mumbai
🏢 CGI
📍 Mumbai