This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Migration of data warehouse of a bank
Project duration: 1 year
Brief description
The customer wants to migrate an existing data warehouse onto another solution. The quality and completeness of the migrated data is to be checked with automated tests.
Supplement
The company uses a data warehouse which grew over time and wants to migrate the warehouse to MS SQL-Server. Automated python tests are used to check if the migrated data is complete. Furthermore the test output should be reported in an easy manner.
Subject description
The challenge is that the data needs to be migrated 1:1 and needs to be checked automatically. For this purpose, suitable SQL-procedures are parsed with python into pytest tests and analysed. The reporting must be in an easy to understand manner and is provided to the developers. Also, the tasks for the developers need to be managed.
IT project data
- Industries banking
- Specialist tasks automated test cases, automated testing, Change Management, data warehouse, general IT environment, process management, QS: Test automation, quality assurance, Reporting, test evaluation, visualizing
- DP tasks Data Warehouse
- System environments Business Intelligence
- Procedure model customer standard
- Programming languages Python
- Databases MS SQL Server
- Development and test tool Jupyter Notebook, MS Visual Studio Code, PyCharm
- System software TortoiseSVN
- Middleware and frameworks Redgate Tools
Project period11.06.2019 - 12.06.2020
Customers who trust us
