The aim of this project is to load the customer data from IBM Europe into the relevant databases. This is done by means of stored functions, which are implemented in T-SQL. In parallel to the implementation using stored procedures, various ETL routes are also being developed using SSIS. The application already exists and new customer requirements are being integrated.

• Requirement Engineering.
• Creating the concepts.
• Responsible for extracting and loading all European customer data.
• Data is extracted from various data sources using SSIS and loaded onto the DWH without transformation.
• By means of stored procedures (T-SQL), the data is prepared for reporting after it has been loaded.
• Data preparation is continuously adapted to the new needs of
  reporting.
• The same applies to the underlying database schemas.
• Generating the reports using Cognos.