Senior SAP HANA CONSULTANT

Unison Group; Chennai District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Unison Group in Chennai, India seeks an experienced SAP Native HANA Developer to design and optimize SAP HANA native solutions. You will implement Calculation Views, Table Functions, Stored Procedures and CDS objects when applicable, using SQLScript as the primary language.

You will collaborate with ABAP developers and business users, ensure data modeling quality, performance tuning, and secure access controls while supporting deployments across environments.

Qualifications

• Experience in SAP HANA native development including design and optimization of native artifacts such as Calculation Views, Table Functions and Stored Procedures.
• Strong SQLScript programming skills with knowledge of dynamic SQL and window functions.
• Hands-on experience with data modeling, data provisioning, ETL and performance tuning for SAP HANA models.

Responsibilities

• Design and develop SAP HANA native artifacts: Calculation Views, Table Functions, Stored Procedures, and CDS Objects (if applicable).
• Develop complex business logic using SQLScript and optimize database procedures and queries.
• Collaborate with ABAP developers and business users; implement security concepts including roles and privileges.
• Support deployments and transport management across environments; troubleshoot production issues.

Skills

SAP HANA Native Development

SQLScript

Data Modeling

Calculation Views

Table Functions

Stored Procedures

HANA Studio / Eclipse

Dynamic SQL

Window Functions

Job description

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.