ETL Developer - SAP BODS & Oracle EDW

Cerebra; Zone 7 Ambattur; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Cerebra is seeking an ETL Developer at its Ambattur, Chennai office. The role focuses on SAP BODS-based ETL development and Oracle SQL/PLSQL in an EDW environment, with 8-10 years of experience expected.

You will design data pipelines, ensure data quality, and support production deployment, monitoring, and troubleshooting within our data warehouse framework. Strong understanding of star schemas, SCDs, and data integration best practices is required, as is hands-on experience with job scheduling

Qualifications

• Hands-on experience in SAP BODS with dataflows, workflows, and transforms.
• Experience with Redwood/Control-M scheduler.
• Strong Oracle SQL & PL/SQL skills.
• Solid understanding of EDW concepts (star schema, fact & dimension tables, SCD).
• Experience with production deployment processes.
• Data extraction, transformation, and loading into EDW.

Responsibilities

• Design and develop ETL workflows and data pipelines using SAP BODS.
• Perform ETL into the EDW.
• Develop and optimize Oracle SQL & PL/SQL.
• Implement data validation, reconciliation, and data quality checks.
• Support job scheduling, monitoring, and troubleshooting.
• Analyze requirements and perform source-to-target data mapping.
• Ensure data integrity, performance, and scalability.
• Support production deployment and issue resolution.

Skills

SAP BODS

Oracle SQL & PL/SQL

EDW concepts

Redwood/Control-M

Performance tuning

Production deployment

Job description

Immediate /Short Notice Only

Cerebra Payroll - MNC Client

ETL Developer SAP BODS & Oracle (EDW)

• Location: Ambattur, Chennai
• Experience: 8 TO 10 Years
• Role: ETL Developer
• Primary Skill: SAP BusinessObjects Data Services (SAP BODS)

Key Responsibilities

• Design and develop ETL workflows and data pipelines using SAP BODS
• Perform data extraction, transformation, and loading into EDW
• Develop and optimize Oracle SQL & PL/SQL
• Implement data validation, reconciliation, and data quality checks
• Support job scheduling, monitoring, and troubleshooting
• Analyze requirements and perform source-to-target data mapping
• Ensure data integrity, performance, and scalability
• Support production deployment and issue resolution

Required Skills

• Strong hands-on experience in SAP BODS
  • Dataflows
  • Workflows
  • Transforms
• Hands-on experience with Redwood / Control-M job scheduler
• Strong Oracle SQL & PL/SQL
• Strong understanding of EDW concepts
  • Star Schema
  • Fact & Dimension Tables
  • Slowly Changing Dimensions (SCD)
• Performance tuning and optimization
• Good understanding of production deployment processes