Description

You design and implement scalable data integration frameworks for the Enterprise Data Warehouse. You own the architecture of ETL/ELT pipelines, data models, and database performance tuning.

This role is on-site.

Responsibilities

• Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage.
• Design and maintain scalable data models including Star/Snowflake schemas and SCD implementation.
• Develop complex data workflows, manage incremental loads, and implement error handling and monitoring.
• Write and optimize complex SQL queries, stored procedures, and indexing strategies for Oracle databases.
• Ensure high availability, reliability, and compliance of data pipelines.

Required Skills

• 8+ years of experience in data engineering and data warehouse architecture.
• Expertise in SAP BODS and IBM DataStage for ETL development.
• Strong proficiency in SQL, Oracle databases, and performance tuning.
• Experience with batch processing and scheduling using Redwood.
• Deep understanding of data modeling concepts (Star/Snowflake schemas, SCD).
• Ability to manage data governance, security, and compliance standards.

Key Skills

Education

Bachelor's degree