Also must have good HANDS EXPERIENCE ON EHANA/Native Hana.
Expertise in EHANA object Development including HANA calculation graphical views, SQL scripted views, Scaler and table function, Stored procedures.
Strong experience with SQL Script, PL/SQL, Stored Procedures, Function Calls, Designing Tables, Table Functions & HANA views (Calc Views).
Apply advanced data modelling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules.
Knowledge about the concept of authorization in SAP HANA, and implementing a security model using analytic privileges, SQL privileges, pre-defined roles, and schemas.
Evaluate the impact of different implementation options such as table joins, aggregation, or filters.
Should adhere to Data Architecture, Modelling and Coding guidelines.
Preparation of Design documents and/or Technical Documents.
Able to identify performance bottlenecks in HANA objects and tune those objects to improve performance.
Provide and develop best practices for application development on the EHANA platform.
Design applications to deal with real time reporting requirements.
Provide scalable solutions for large data volumes (Terabytes of data) and complex reporting needs.
Perform Hands-on analysis, design and deployment of solutions.
Monitor, investigate and optimize data models and reporting performance on SAP HANA.
Understand the implication of the performance of the various reporting tools and connection type.
And advantage will be given if having Working experience on reporting tools such as SAP Business Objects ( Webi, AO) & SAC.