SAP Native HANA Modeller SQLScript Calculation Views Performance (Delhi)

SAP Native HANA Modeller SQLScript Calculation Views Performance (Delhi)

15 Aug
|
Quess
|
Delhi

15 Aug

Quess

Delhi

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: sap native hana modeller sqlscript calculation views performance (delhi) / delhi

Subscribe to this job alert:

Get the latest job offers by email for: sap native hana modeller sqlscript calculation views performance (delhi) / delhi