Senior SAP HANA CONSULTANT

Job Summary

We are seeking an experienced SAP Native HANA Developer with strong expertise in SQLScript, data modeling, and SAP HANA database development. The candidate will be responsible for designing, developing, and optimizing SAP HANA native solutions, including Calculation Views, Table Functions, Stored Procedures, and performance tuning activities. SQLScript is the primary language used to implement data-intensive logic directly within SAP HANA.

Key Responsibilities

Design and develop SAP HANA native artifacts:

Calculation Views

Attribute/Analytic Views (legacy environments)

Table Functions

• Stored Procedures
• CDS Objects (if applicable)
• Develop complex business logic using SQLScript.
• Create and optimize database procedures, functions, and dynamic SQL.
• Perform performance tuning of SQL queries and HANA models.
• Work with data provisioning, ETL, and integration processes.
• Develop reusable data models for reporting and analytics.
• Troubleshoot production issues and optimize database performance.
• Collaborate with functional consultants, ABAP developers, and business users.
• Implement security concepts including roles, privileges, and authorization checks.
• Support deployments and transport management across environments.

Required Skills

• SAP HANA
• Strong experience in SAP HANA Native Development.
• Hands-on experience with:

Calculation Views

• Table Functions
• Procedures
• SQL Optimization
• Data Modeling
• Knowledge of HANA Studio, Eclipse, or SAP Business Application Studio.

SQLScript

Advanced SQL and SQLScript programming.

Experience with:

Variables

• Loops
• Exception Handling
• Dynamic SQL

Window Functions

• Table Types
• Stored Procedures
• User Defined Functions (UDFs)
• Ability to write efficient declarative and imperative SQLScript code.