This is one of 3224 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.
Overview
- 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
- DV tasks Data Warehouse
- System environment Business Intelligence
- Procedure model customer standard
- Databases MS SQL Server
- Development/ test tools Jupyter Notebook, MS Visual Studio Code, PyCharm,
Project period11.06.2019 - 12.06.2020
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
