Datastage Consultant - ETL/Data Warehousing

Work Location : Mumbai

Total Experience : 5 - 12 years

Required Skills :

- Design, develop, and maintain ETL jobs using IBM DataStage.

- Extract, transform, and load data from multiple source systems into target databases and data warehouses.

- Develop and optimize complex SQL queries, stored procedures, and data transformation logic.

- Work with DataStage parallel jobs, server jobs, and sequences.

- Perform data mapping, data validation, reconciliation, and quality checks.

- Troubleshoot ETL job failures and resolve performance-related issues.

- Work with databases such as Oracle, SQL Server, DB2, or Teradata.

- Participate in unit testing, integration testing, production support, and deployment activities.

- Collaborate with business analysts, data architects, and other development teams.

- Maintain technical documentation and follow ETL development standards.