Position: SAP Native HANA Modeler
Location: East Coast Region
Duration: Long Term
Need SAP Native HANA Modeler with very good Scripting experience.
SAP HANA Modeler is responsible for designing, developing and maintaining data warehouse and analytics architecture to meet enterprise's business analysis and reporting needs.
Requirements:
- Having experience in the Data warehousing, ETL, BI and Analytics space. This includes building capabilities to ingest data, manage data quality, building data marts.
- At least 3 years of HANA Modeling in Attribute views, Calculation views, Analytic views, Analytic
- Privileges, SQL Scripting, Procedures, Flow Graphs and OData Services.
- Experience in Smart Data Integration (SDI) is mandatory to transform data from source system to
- HANA with ELT/ETL functions with adapters such as Hadoop, DB2, SQL & Oracle.
- Experience with real-time replication into HANA with SDI, SLT Replication Server and Sybase
- Replication Server is value added.
- Having experience in SAP Data Services is a plus for this position.
- Having knowledge in Dynamic Tiering is a plus for this position.
- HANA Performance tuning skills are required.
- Bachelor's degree in computer science or related degree
- Strong oral and written communication skills
Responsibilities:
- Gathering requirements from business users and translate them into DW models to deliver dashboards and reports.
- Create De-normalized tables in HANA to provide better analytical capabilities with star schema model.
- Developing SAP HANA information models such as Flow Graphs, Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting.
- Creating SDI workflows to transform data from source to target.
- Working with Hadoop, DB2, SQL & Oracle adapters to load data into HANA.
- Working with large data volumes including structured and unstructured data.