Creation of ETL routes for filling the Internet platforms of Swisslife. The tables are filled on the one hand from the databases behind the Internet platforms, but on the other hand also from the data of the data warehouse. Depending on the data source, a prelaod or a load is first made using stored functions in T-SQL. The data is then transformed for the first time and loaded into the load structure. As a result, the data is refined or transformed a second time and the data transformation is carried out using complex, stored functions. Then the data is loaded into the internet database on the one hand, and loaded into the data warehouse on the other, taking the key values ​​into account. The task is to write dynamic stored procedures for filling these tables, to test them, to document them and to integrate them into the system. The development is implemented using Microsoft SQL Server 2012 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages, these are also tested and documented.

• Requirement Engineering.
• Creating the concepts.
• Extending and creating the data models.
• Extract and load all data for the Internet portals MyLive and MyWorld.
• Creating SSIS packages.
• Creation of stored procedures (T-SQL) for transforming the data.
• Data preparation is continuously updated to meet the new reporting needs
adapted.