Beschreibung
The Solution is relying on a classical BI architecture with a 3 persistence layers and an ETL (Informatica PowerCenter) in between to extract, transform and load data from one layer to the other.The first layer is called the ODS (for Operational Data Store) and is collecting data with no a few transformation from all source systems. The second layer is called the DWH (Data Ware House)
and is aggregating all sources into business meaningful entities from a risk management perspective.
This second layer is the single point of truth and are historised according different time dimensions including correction in the past for some entities. The third layer is called DMT for Data Marts) and is preparing the data for Reporting according the sub-area topic). The second layer is not persisting data in pure 3NF and is not implementing data integrity, whereas the 3rd layer is implementing data integrity (and modeling the data into a star model).
Anforderung:
- Change management tool experience
- Good communication and negotiation skill
- Business Analysis on DW project
- Strong SQL knowledge and strong Testing skill set
- Basic knowledge in Informatica PowerCenter
Projektstart: 01.02.2018
Projektende: 28.02.2019
Auslastung: vollzeit
Leistungsort: GR Frankfurt