Sap Business Warehouse Consultant

Capgemini; Pune District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Capgemini is seeking an experienced SAP BW/4HANA professional in India to design, develop, and support enterprise data warehousing and reporting solutions. The role covers end-to-end BW development, HANA data modeling, and close collaboration with business stakeholders.

You will design and implement data models, delive­r reliable ETL processes, and optimize data loads. The position requires collaboration with cross-functional teams and strong documentation skills.

Qualifications

• Strong hands-on experience in SAP BW/4HANA (or BW on HANA).
• Expertise in ADSO, Composite Provider, Open ODS View, Transformations, DTPs, Process Chains.
• SAP HANA modeling – Calculation Views, SQL Script.
• Experience with data extraction from SAP ECC/S/4HANA (LO Cockpit, Generic Extractors, CDS Views).
• BEx Query Designer / Analysis for Office.
• Performance tuning of queries and data loads.
• ABAP for BW routines (Start/End/Field routines).

Responsibilities

• Design and develop SAP BW/4HANA data models and reporting solutions.
• Build and maintain Data Sources, ADSOs, Composite Providers, Open ODS Views, and Queries.
• Develop ETL processes and data integration from SAP and non-SAP systems.
• Perform data modeling using SAP HANA.
• Analyze business requirements and translate them into technical solutions.
• Optimize BW queries and data loads for performance.
• Collaborate with business users and functional teams.
• Support production issues and implement enhancements.
• Prepare technical documentation and knowledge transfer materials.

Skills

SAP BW/4HANA expertise

HANA data modeling

Data warehousing & reporting

ABAP for BW

Tools

ADSOs

Composite Provider

Open ODS View

Transformations

DTPs

Process Chains

BEx Query Designer

Job description

We are looking for an experienced SAP BW/4HANA professional to design, develop, and support enterprise data warehousing and reporting solutions. The role involves end-to-end BW development, HANA data modeling, and close collaboration with business stakeholders.

Key Responsibilities

• Design and develop SAP BW/4HANA data models and reporting solutions.
• Build and maintain Data Sources, ADSOs, Composite Providers, Open ODS Views, and Queries.
• Develop ETL processes and data integration from SAP and non-SAP systems.
• Perform data modeling using SAP HANA.
• Analyze business requirements and translate them into technical solutions.
• Optimize BW queries and data loads for performance.
• Collaborate with business users and functional teams.
• Support production issues and implement enhancements.
• Prepare technical documentation and knowledge transfer materials.

Required Skills

• Strong hands-on experience in SAP BW/4HANA (or BW on HANA).
• Expertise in ADSO, Composite Provider, Open ODS View, Transformations, DTPs, Process Chains.
• SAP HANA modeling – Calculation Views, SQL Script.
• Experience with data extraction from SAP ECC/S/4HANA (LO Cockpit, Generic Extractors, CDS Views).
• BEx Query Designer / Analysis for Office.
• Performance tuning of queries and data loads.
• ABAP for BW routines (Start/End/Field routines).