SAP Data Services (BODS) Consultant

SAP Data Services (BODS) Consultant

Role Summary

We are seeking an experienced SAP Data Services (BODS) Consultant with strong expertise in SAP CDS Views, SAP data extraction, and enterprise Data Lake integration.

The role focuses on designing, developing, and maintaining scalable ETL pipelines to extract, transform, and load SAP data into Data Lakes, data warehouses, reporting platforms, and downstream systems while aligning with Enterprise Canonical Data Models (CDM) and standardized templates.

Key Responsibilities

1. SAP Data Extraction & ETL Development

• Design, develop, and support ETL workflows using SAP Data Services (BODS)
• Extract data from SAP S/4HANA or ECC using CDS Views and transparent tables
• Build scalable data pipelines into cloud or on-premise Data Lake environments
• Implement delta loads, CDC (Change Data Capture), and full load mechanisms
• Ensure data accuracy and completeness across extraction processes

2. Data Modeling & Canonical Alignment

• Map SAP data structures to enterprise Canonical Data Models (CDM)
• Design and maintain reusable ETL load templates
• Implement transformation logic aligned with enterprise standards
• Ensure data reconciliation, validation, governance, and auditability

3. Technical & Performance Optimization

• Optimize CDS Views and BODS jobs for performance and scalability
• Monitor, troubleshoot, and provide production support for ETL processes
• Maintain comprehensive documentation of ETL mappings, logic, and templates
• Support UAT, go-live, hypercare, and post-production stabilization activities

Required Skills & Experience(_+8 years )

• Strong hands-on experience in SAP Data Services (BODS)
• In-depth knowledge of CDS Views (Basic, Composite, and Consumption)
• Strong understanding of SAP data models (S/4HANA or ECC)
• Experience integrating SAP data into Data Lake architectures
• Strong SQL skills and performance tuning experience
• Good knowledge of data warehousing concepts (Fact/Dimension modeling)
• Experience with SAP extraction mechanisms such as:
• IDocs
• RFCs
• ODP
• SAP standard extractors