Job Title:  Consultant | SAP BW | Bengaluru | SAP | DSA Auto and Auto Components

Team Lead | Enterprise Technology & Performance- SAP | SAP BW

Location:  Bengaluru 

The team

Enterprise technology has to do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Your work profile

We are looking for an experienced SAP BW Consultant with 3–6 years of relevant experience to support SAP Business Warehouse development, data modelling, data extraction, reporting, and application support activities.

The ideal candidate should have good hands-on expertise in SAP BW, SAP BW on HANA, and BW/4HANA, along with experience in data modelling, data transformation, data loading, reporting, debugging, and performance optimization.

The role involves understanding business requirements, developing and enhancing SAP BW objects, managing data flows, executing data extraction and transformation activities, troubleshooting technical issues, and ensuring quality delivery across SAP implementation, rollout, enhancement, and support projects.

Key skills required

• Education Any Bachelor’s

• Hands-on experience in SAP BW, BW on HANA, and preferably SAP BW/4HANA.
• Good knowledge of SAP BW data modelling, data extraction, transformation, and reporting.
• Experience in BW routines, including Start, End, and Field Routines.
• Good debugging and troubleshooting skills.
• Understanding of SAP HANA database concepts and basic performance optimization.
• Good communication and coordination skills.
• 3–6 years of relevant experience in SAP BW development and support.
• Hands-on experience in SAP BW 7.x and SAP BW on HANA.
• Basic to good understanding of SAP BW/4HANA concepts and architecture.
• Experience in SAP BW data modelling, including InfoObjects, DataSources, DSO, Advanced DSO (ADSO), InfoCubes, MultiProviders, and CompositeProviders.
• Hands-on experience in developing and maintaining Data Flow objects, including Transformations, DTPs, and Process Chains.
• Experience in different types of BW routines, including Start Routines, End Routines, and Field Routines.
• Knowledge of ABAP-based routines and debugging techniques in SAP BW.
• Experience in data extraction from SAP ECC and exposure to S/4HANA and non-SAP source systems.
• Understanding of standard and generic DataSources, LO Cockpit extraction, and ODP-based extraction.
• Experience in developing and maintaining BEx Queries, Query Designer, Workbooks, and reporting solutions.
• Understanding of SAP BW on HANA architecture and HANA-optimized data modelling.
• Knowledge of CompositeProviders, Open ODS Views, and reporting capabilities.
• Basic hands-on knowledge of SAP HANA SQL and SQLScript.
• Understanding of data loading mechanisms, including full loads, delta loads, and data reconciliation.
• Experience in monitoring Process Chains, identifying data load failures, and resolving routine production issues.
• Perform technical debugging, issue analysis, and basic performance tuning of BW objects.
• Support optimization of data models, transformations, queries, and data loading performance.
• Work closely with functional consultants, business analysts, and technical teams to understand requirements and deliver SAP BW solutions.
• Participate in SAP BW implementation, rollout, upgrade, migration, enhancement, and support projects.
• Take ownership of assigned development and support activities and ensure timely delivery.
• Follow SAP development standards and best practices.
• Participate in code reviews and incorporate feedback from senior team members.
• Collaborate with senior consultants and provide technical support to junior team members when required.
• Participate in technical discussions, effort estimations, and project status updates.
• Ensure data accuracy, consistency, and quality across SAP BW reporting and data integration solutions.
• Hands-on experience in SAP BW/4HANA development or migration projects.
• Knowledge of SAP HANA Calculation Views and SQLScript.
• Experience with SAP HANA Studio and Eclipse-based BW modelling tools.
• Exposure to SAP Datasphere and SAP Analytics Cloud (SAC).
• Basic knowledge of SAP ABAP programming and debugging techniques.
• Experience with SAP BusinessObjects reporting tools.
• Exposure to SAP Data Services (BODS) and third-party data integration tools.
• Knowledge of SAP S/4HANA embedded analytics and CDS Views.
• Understanding of ODP extraction and SAP SLT replication.
• Exposure to SAP BTP and cloud-based data integration solutions.
• Experience working in Agile or Scrum-based project environments.