Development of Informatica ETL routes

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.