Microsoft SQL Server DWH Developer - T-SQL, ETL

Company: ElipsLife, Opfikon

Technology: T-SQL, ETL.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Feb 2017 – Mar 2017

Cost: no details

Creation of ETL routes for filling the financial data warehouse of the company ElipsLife. The tables of the data warehouse are first filled in the stage area and then, after transformation, in the area of the data warehouse. Both the stage database and the data warehouse are filled by calling stored functions that were implemented in T-SQL. Since the data warehouse is a data vault schema, the filling of the tables of the data warehouse is done according to exact rules. Only one statement is provided for filling the hubs, links or satellites. All three are always filled in the same way, only the names of tables and attributes change. 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 2016 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages; these are also tested and documented.

• Develop DWH load procedures using SQL Server.
• Loading the DWH tables.
• Implementing the STAR and the VAULT schema.
• Creating the ETL processes (stage).
• Modelling of the schemas based on the business requirements.
• Clarification with the business.
• Loading of data from SAP.
• Data refinement and data mapping.