Description

You will design and maintain complex data integration solutions using IBM DataStage.

This role is on-site.

Responsibilities

• Design and implement ETL/ELT frameworks for complex data warehouses and data marts.
• Develop and troubleshoot ETL jobs using DataStage, focusing on Parallel Job design.
• Write complex SQL and PL/SQL queries for data analysis, lineage, and reconciliation.
• Create detailed documentation, including Source to Target (STM) Mappings and Low Level Technical Specifications.
• Resolve complex technical issues within the data pipeline.

Required Skills

• 8+ years of Data Warehousing experience.
• 7+ years of strong development experience with DataStage.
• 3+ years experience with DataStage 8.7 or higher.
• 4+ years experience in DataStage Parallel Job design.
• 7+ years writing complex SQL and PL/SQL, preferably against Oracle.
• 5+ years creating Data Lineage and STM Mapping documents.
• 4+ years designing and implementing ETL/ELT frameworks.

Key Skills

Education

Any Gradute