ETL pipeline for a financial reporting system
Design and development of an ETL system for a financial reporting system, Automotive, April 2004 – December 2012
About the project
Implementation of an ETL process for an internal financial reporting system
- When data has been changed in the information system, the ETL process gets notified
- Then relevant records are extracted from the information system and loaded into an Essbase OLAP database
- Extract and load in "near real-time" to avoid latency which is introduced by batch processing
- Notify other systems after changes; send data to other systems
Roles
- System architect, development, integration, application management, operating
Industry, industrial sector
- Automotive