Job Summary
SAP NATIVE HANA (2.0) XSA Modelling using WEB IDE :
Experience with designing and developing Native HANA solutions using- Calculation Views, SQL script Table functions, Stored procedures.
Need to be proficient with the database concepts, performance optimization techniques.
Experience on HANA Cloud, XSA, Git Repository is mandatory.
Experience in data replication into Native HANA using SLT, SDI .
Create and manage database objects such as tables, indexes, views, and procedures.
Efficient SQL development to manage high data volume Smart Data Access(SDA) and SLT.
SQL Performance Tuning.
Proven expertise in optimization and troubleshooting performance of Calculation views and SQL queries using various performance tuning techniques.
Create Joins, Unions, Rank Nodes, Filter Output of Data Foundation Node, Filter Output of Aggregation or Projection View Nodes, Calculated Columns, Restricted Columns,Input Parameters, Hierarchies for Reporting, Debug Calculation Views, Table Function.
Experience in Creating Function, Procedure, Virtual Table, analytic Privilege.
Key Responsibilities
2. To contribute to the preparation of client deliverables, including reports, presentations, proposals and participate in client meetings, workshops and presentations.
3. To coordinate with technical teams for pending RICEFs
4. To train others and prepare and deliver presentations for knowledge sharing amongst different teams in the project
5. To continuously develop skills and knowledge related to consulting methodologies and stay updated on industry best practices and emerging trends.