Beschreibung
TätigkeitenbeschreibungLogical design and execution of DWH modules and ETL processes in the context of projects of various sizes, taking into consideration the business-related and technical requirements. Develops the physical design of the DWH database and implements the ETL/ELT processes.
Analysis of the data sources, data profiling
Logical and physical design of the DWH in the 3rd normal form and of the staging
Definition of standards for data extraction and archiving of extracts
Design of the ETL/ELT processes:
Analysis and documentation of the source data
Design of the interfaces (extraction, load)
Design Source-To-Target Mapping including Business Rules and DQ Checks (Transform)
Definition of the standards for the general achieving
Design of the Auditing system
Implementation and optimization of the ETL/ELT processes
Implementation of the Historic and Incremental Load
Implementation of the Job Scheduling
Implementation of the Auditing Systems
Design and implementation of the Data Marts
Design and implementation of BI applications like Reports, dashboards, ad-hoc analysis tools (SAP BO) and similar
Design and implementation of BI applications like Crystal Reports
Support of the project manager in the estimates and planning
Fähigkeiten (Must have)
Data Warehouse, ETL