Company: Swiss Life, Zurich
Technology: MЫ SQL Server, T-SQL, SSIS
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Apr 2015 – Sep 2016
Cost: no details
Creation of ETL routes for filling the internet platforms of the company Swisslife. The tables of the databases behind the internet platforms are filled, but also the data of the data warehouse. Depending on the data source, a preload or a load is first made using stored functions in T-SQL. Subsequently, the data is transformed a first time and loaded into the load structure. Subsequently, the data is refined or transformed a second time and the data transformation is carried out using complex stored functions. Afterwards, the data is loaded into the internet databases on the one hand, and into the data warehouse on the other hand, taking into account the key values. The task is to write dynamic stored procedures for filling these tables, test them, document them and integrate them into the system. The development will be implemented using Microsoft SQL Server 2012 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages, which are also tested and documented.
- Requirement engineering.
- Creating the concepts.
- Expanding and creating the data models.
- Extracting and loading all data for the internet portals MyLive and MyWorld.
- Creating SSIS packages.
- Creating stored procedures (T-SQL) for transforming the data. Data preparation is continuously adapted to the new requirements of reporting adapted.