dwh

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.