Description

You will design, build, and maintain complex ETL/ELT frameworks and data integration pipelines for data warehouses and marts using IBM DataStage.

This role is on-site.

Responsibilities

• Design and implement scalable ETL/ELT frameworks for complex data warehousing environments.
• Develop and optimize complex SQL and PL/SQL queries for data analysis, lineage, and reconciliation.
• Create and maintain Data Lineage, Source to Target (STM) Mapping, and Low Level Technical Specification Documents.
• Troubleshoot and resolve complex data integration issues through hands-on development.

Required Skills

• Minimum 7 years of strong development experience with IBM DataStage.
• Minimum 3 years of experience with DataStage 8.7 or higher.
• Minimum 4 years of experience in DataStage Parallel Job Design.
• Minimum 4 years of experience designing and implementing ETL/ELT frameworks.
• Minimum 7 years of experience writing complex SQL and PL/SQL.
• 8+ years of overall experience in Data Warehousing.
• Proficiency in Data Analysis and SQL/PL/SQL.

Key Skills

Education

Any Graduate