Job Purpose: Analyze, design and develop extract, transform, and load (ETL) processes using SAP Data Services to automate the movement of data from source systems into SAP HANA dimensional data structures. This senior developer/architect position requires advanced skills in implementing best practices in the design, development, deployment and management of scalable, reusable and extensible data integration components in these two technology platforms.
Design and code SAP Data Services workflows to load dimensional and relational structures in HANA Oracle databases. (This is not SAP BW work)
Lead design, development, troubleshooting and performance tuning of all ETL work.
Technical collaboration with ETL, DBA, BI, Data Modeling teams in a fast-paced environment
Create, implement, maintain, and extend common reusable data integration components
Monitor and promote data integration best practices across all work-streams
Ensure all data integration processes are documented and recoverable as it pertains to disaster recovery.
Provide technical mentoring to peers, collaborate and be approachable to the team.
Provide documented project and task updates to all concerned parties in a timely manner
Monitor production data integration jobs and correct failures in a timely manner
Create and manage incident reports as they pertain to data integration processes
ETL - Extract Transform Load, SAP HANA, Oracle 11i