Menu
This is one of 4545 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
- Branchen banking
- Fachaufgaben automated test cases, automated testing, Change Management, data warehouse, general IT environment, process management, QS: Test automation, quality assurance, Reporting, test evaluation, visualizing
- DV-Aufgaben Data Warehouse
- Systemumgebungen Business Intelligence
- Vorgehensmodell customer standard
- Datenbanken MS SQL Server
- Entwicklungs- und Testtool Jupyter Notebook, MS Visual Studio Code, PyCharm,
Project periodProjektzeitraum11.06.2019 - 12.06.2020
Have we sparked your interest?
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
