SAP BODS Engineer (NCS/Job/ 4045)

We are seeking an experienced Lead Data Engineer to take end-to-end ownership of Enterprise Data Warehouse (EDW) solutions. This role will be responsible for designing, architecting, and optimizing scalable, secure, and high-performance data pipelines using SAP BODS, IBM DataStage, Redwood, SQL, Oracle, and modern data platforms.

The ideal candidate will combine strong hands-on technical expertise with leadership capabilities to drive data engineering best practices and deliver enterprise-grade data solutions aligned with business objectives.

Key Responsibilities

1. EDW Architecture & Data Engineering

• Design and implement scalable data integration and transformation frameworks for the Enterprise Data Warehouse.
• Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage.
• Develop and maintain robust data models (Star/Snowflake schemas, SCD implementation).
• Ensure high availability, reliability, and performance of data pipelines.
• Implement data governance, security, and compliance standards.

2. ETL Development & Optimization

• Develop complex data workflows and transformations.
• Perform performance tuning of ETL jobs and SQL queries.
• Optimize batch processing and scheduling using Redwood.
• Implement error handling, logging, and monitoring mechanisms.
• Manage incremental loads and data reconciliation processes.

3. Database & SQL Development

• Write and optimize complex SQL queries, stored procedures, and functions.
• Work extensively with Oracle databases and related technologies.
• Design and manage indexing strategies and query optimization.
• Support database performance analysis and tuning.