HANA with ELT/ETL functions with adapters such as HadoopDB2SQL & Oracle
Work Authorization
Us Citizen
Green Card
Preferred Employment
Corp-Corp
Employment Type
Consulting/Contract
education qualification
UG :- - Not Required
PG :- - Not Required
Other Information
No of position :- ( 1 )
Post :- 25th Mar 2021
JOB DETAIL
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 .