Senior Sap Business Warehouse Consultant

About the Role

Location: Lucknow, Uttar Pradesh Company: HCLTech Experience: 6+ Years Job Summary HCLTech is looking for an experienced SAP BW/4HANA Consultant to join our growing SAP practice in Lucknow. The ideal candidate will have strong expertise in SAP BW/4HANA or SAP BW on HANA, data warehousing, data modeling, ETL processes, and SAP HANA modeling. The role requires hands-on experience in designing, developing, optimizing, and supporting enterprise data warehouse solutions while collaborating with business stakeholders and technical teams to deliver high-quality analytics and reporting capabilities. Key Responsibilities Design, develop, and maintain SAP BW/4HANA and SAP BW on HANA solutions.Build and enhance data models using InfoObjects, ADSOs, Composite Providers, and other BW modeling objects.Develop and maintain SAP HANA Calculation Views, SQL Scripts, and other HANA modeling artifacts.Design and manage data extraction, transformation, and loading (ETL) processes using DTPs, InfoPackages, and related SAP BW tools.Develop and support ABAP routines, enhancements, start/end routines, and expert routines for BW processes.Create and optimize reporting solutions using BEx Query Designer, Analysis for Office, and other BI tools.Monitor, troubleshoot, and improve the performance of SAP HANA and BW applications.Integrate and extract data from SAP and non-SAP source systems.Participate in SAP BW/4HANA migration and transformation initiatives. Required Skills & Qualifications Must Have 6+ years of experience in SAP BW/4HANA or SAP BW on HANA.Strong expertise in Data Modeling:InfoObjectsADSOs (Advanced DataStore Objects)Composite ProvidersHands-on experience with:SAP HANA ModelingCalculation ViewsSQL ScriptExperience with ETL processes using:BEx Query DesignerStrong performance optimization and troubleshooting skills in SAP HANA.Experience in data extraction from SAP and non-SAP sources.Understanding of SAP BW/4HANA architecture and migration concepts. Nice to Have Familiarity with SAP Analytics Cloud (SAC) or other reporting and analytics tools.Exposure to SAP S/4HANA integration.Knowledge of SLT, SDI, or SDA for data provisioning. Apply Now If you are passionate about data warehousing, analytics, and SAP technologies and want to be part of a dynamic team delivering transformative business solutions, we would love to hear from you. HCLTech | Lucknow Role: SAP BW/4HANA Consultant Experience: 6+ Years Location: Lucknow, Uttar Pradesh, India