Description

You will develop and maintain complex data integration solutions using DataStage.

Responsibilities

• Design and implement ETL/ELT frameworks for complex data warehouses and data marts.
• Develop and troubleshoot ETL jobs using DataStage, including 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.
• Expertise in Datastage, Data Warehousing, SQL, PL/SQL, Oracle, ETL.

Key Skills

Education

Any Gradute