This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
ETL and database support
Project duration: 2 years, 11 months
Brief description
The current data from the source systems is required for energy trading and risk management, among other things. This means that malfunctions in the ETL (extract, transform, load) processes used have a direct impact on operations and must therefore be rectified at short notice. For this reason, performance analyses, error corrections and optimizations of the ETL loading routes are carried out.
Supplement
The source data is read from MS SQL Server and Oracle databases, processed using SSIS packages and database procedures, and transferred to the target systems. The job is controlled by one of the SQL servers involved.
Overview
- Industries energy
- Specialist tasks energy trade, interfaces, Job Management, Risk Management
- DV tasks customised software support
- System environment Business Intelligence
- Procedure model customer standard
- Databases MS SQL Server
Project period18.01.2017 - 31.12.2019
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
