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 4843 IT projects that we have successfully completed with our customers.How can we support you?
Development of Informatica ETL routes
Brief description
Development of Informatica ETL routes to transform data delivery into a standard format defined for the target system.
Supplement
The depositary also assumes control tasks for other external capital management companies (KVG). The external capital management companies make their daily turnover and holdings available in csv files. In order to meet the regulatory requirements, it is necessary to audit the holdings and sales of the KVG. Before the data can be loaded into the depositary's control program, it must first be converted into a defined standard format and, if necessary, enriched with master data. For this purpose, ETL routes are developed with Informatica PowerCenter.
Subject description
Among other things, the depositary also performs control tasks for other external capital management companies (KVG). The external capital management companies provide their daily turnover and holdings in csv files. In order to meet the regulatory requirements, it is necessary to subject the KVG's holdings and turnover to an audit. Before the data can be loaded into the custodian's control program, it must first be converted into a defined standard format and, if necessary, enriched with master data. For this purpose, ETL routes are developed with Informatica PowerCenter.
IT project data
- Industries banking
- Specialist tasks custodian bank, fund management, fund reporting, KAGV, market conformity check
- DP tasks customised software further development
- System environments Middleware
- Procedure model iterative procedure
- Databases Oracle Database
- Development and test tool CM Synergy, UltraEdit
- Operating systems AIX
- Standard software and BI Informatica PowerCenter
Project start07.08.2019
Customers who trust us
Have we sparked your interest ?
