OverviewWe are looking for an experienced SAP HANA Consultant with over 8+ years of hands-on experience in implementing, configuring, and supporting HANA systems in both standalone and sidecar architectures. Skilled in data modeling, SLT replication, performance tuning, and integration with S/4 & non-SAP systems. Proven ability to deliver real-time analytics solutions and optimize reporting performance.
Required Skillsets- Minimum 8+ years of experience in Native HANA development, data modeling, SQLScript, and performance optimization.
- Proven expertise in designing end-to-end data models, optimizing complex HANA views, and delivering scalable analytics solutions.
- Adept at integrating SAP HANA with S4 HANA and non-SAP systems to drive business intelligence and data-driven decision-making.
- Expertise in SQLScript, Table Functions, and advanced Calculation Views.
- Strong experience in SLT, SDI, SDA for data provisioning.
- Knowledge of HANA XS/XS Advanced, OData services.
- Experience with performance tuning and query optimization in HANA.
- Strong experience in integration with BOA, Webi, Tableau, Power BI.
- Strong analytical, problem-solving, and communication skills.
Responsibilities- Design and develop Attribute, Analytic, and Calculation Views (Graphical and SQLScript-based).
- Create complex Calculation Views using Table Functions, and SQLScript.
- Use variables and input parameters to enable dynamic data filtering.
- Develop stored procedures and functions to handle business logic in the database layer.
- Implement Hierarchies, Restricted, and Calculated Columns in HANA models.
- Optimize joins, aggregations, and projections for faster execution.
- Refactor complex Calculation Views by leveraging Aggregation Nodes, Star Join, and pruning techniques.
- Integrate HANA models with BusinessObjects (BO), Tableau / Power BI.