SAP BW HANA Consultant

Tata Consultancy Services; Bengaluru; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Tata Consultancy Services is looking for an experienced SAP BW on HANA professional in Bengaluru, India. The ideal candidate will design, develop, and support data warehousing solutions. Key responsibilities include developing data models, optimizing ETL flows, and collaborating with teams for reporting requirements. Candidates should have strong hands-on experience in SAP BW on HANA, proficiency in HANA modeling, and good communication skills. A Bachelor’s degree in a relevant field is required.

Qualifications

• Strong hands-on experience with SAP BW on HANA or SAP BW/4HANA.
• Proficiency in HANA modeling and SQL scripting.
• Experience with BEx Query Designer or SAP Analytics Cloud (SAC).
• Good understanding of SAP data structures, ETL, and data warehousing concepts.
• Strong debugging and performance optimization skills.
• Good communication and client interaction skills.

Responsibilities

• Design, develop, and maintain SAP BW/4HANA or BW on HANA data models.
• Develop and optimize ETL data flows using BW transformations.
• Work with SAP HANA native modeling.
• Support end-to-end data load processes and troubleshoot failures.
• Perform performance tuning on HANA and BW queries.
• Collaborate with functional teams for reporting requirements.
• Build reports using SAP BO, SAC, Analysis for Office.
• Manage transport requests, documentation, and deployments.
• Support integration with S/4HANA and other systems.

Skills

SAP BW on HANA

HANA modeling

SQL scripting

ETL

Performance optimization

Reporting

BEx Query Designer

SAP Analytics Cloud (SAC)

Debugging

Education

Bachelor’s degree in Engineering, Computer Science, IT, or equivalent

Tools

SAP BW/4HANA

SAP BO

Analysis for Office

BEx Queries

Job description

We are looking for an experienced SAP BW on HANA professional who can design, develop, and support data warehousing solutions using SAP BW, HANA, and related SAP analytics tools. The ideal candidate will have hands‑on experience in data modeling, ETL, performance optimization, and reporting.

Key Responsibilities

• Design, develop, and maintain SAP BW/4HANA or BW on HANA data models (InfoObjects, ADSOs, CompositeProviders, Open ODS Views).
• Develop and optimize ETL data flows using BW transformations, DTPs, and HANA SQL.
• Work with SAP HANA native modeling (Calculation Views, Attribute Views, Analytic Views).
• Support end‑to‑end data load processes and troubleshoot load failures.
• Perform performance tuning on HANA and BW queries.
• Collaborate with functional and business teams to understand reporting requirements.
• Build reports using SAP BO, SAC, Analysis for Office, or BEx Queries.
• Manage transport requests, documentation, and production deployments.
• Support integration with S/4HANA and other SAP/non‑SAP systems.

Required Skills

• Strong hands‑on experience with SAP BW on HANA or SAP BW/4HANA.
• Proficiency in HANA modeling and SQL scripting.
• Experience with BEx Query Designer or SAP Analytics Cloud (SAC).
• Good understanding of SAP data structures, ETL, and data warehousing concepts.
• Strong debugging and performance optimization skills.
• Good communication and client interaction skills.

Preferred Skills

• Experience in S/4HANA Embedded Analytics.
• Knowledge of SAP Data Services (BODS).
• Experience with Agile methodologies.
• Exposure to cloud platforms (Azure/AWS/GCP) is a plus.

Education

• Bachelor’s degree in Engineering, Computer Science, IT, or equivalent.