Role & responsibilities
- Design, develop and maintain SAP Native HANA data models and analytical solutions.
- Develop Graphical Calculation Views and SQLScript Calculation Views.
- Develop and maintain SQLScript, Table Functions and Stored Procedures.
- Design data models using:
- Joins
- Star Joins
- Projections
- Aggregations
- Unions
- Calculated Columns
- Restricted Columns
- Work with Input Parameters, Variables and Hierarchies.
- Implement Currency Conversion and Unit Conversion.
- Develop reusable and optimized semantic models for reporting and analytics.
- Implement complex business logic using SQLScript and push-down processing.
- Design and maintain Schemas, Column Store Tables and Partitions.
- Implement Analytical Privileges, Roles and User Management.
- Perform data validation, reconciliation and troubleshooting.
Performance Tuning
- Analyze and optimize Calculation Views, SQLScript procedures and database queries.
- Perform Execution Plan analysis and identify performance bottlenecks.
- Optimize large-volume data processing and query performance.
- Apply performance optimization techniques such as:
- Partitioning
- Data Pruning
- Efficient Join Strategies
- Aggregation Optimization
- Query Optimization
- Troubleshoot production performance issues and perform root-cause analysis.
- Support critical HANA applications and coordinate with SAP Support/OSS when required.
Preferred candidate profile
- 69 years of hands-on experience in SAP Native HANA Development and Modelling.
- Strong experience in SAP HANA Calculation Views.
- Strong hands-on experience with Graphical Calculation Views.
- Robust experience in SQLScript.
- Experience with SQLScript Calculation Views.
- Strong experience with Table Functions and Stored Procedures.
- Hands-on experience with SAP HANA Studio / HANA Modelling Tools.
- Strong knowledge of HANA Database and Data Modelling.
- Experience with Performance Tuning and Query Optimization.
- Experience with Execution Plans and perfor
📌 SAP Native HANA Modeller SQLScript Calculation Views Performance (Delhi)
🏢 Quess
📍 Delhi