Near-time DWH with integration of many data sources

May 2014 - June 2017

  • Further development and optimization of an import framework configurable via metadata
  • Development of a generator for creating DDL and import definitions based on templates for the rapid integration of new sources or changes to sources
  • Integration of several thousand sources (DBs, CSV, Rest-Apis) at high frequency (every half hour) using the import framework and Pentaho Data Integration (PDI)
  • Development of a high-performance DWH based on Exasol
    Database administration incl. role-rights concept
  • Development of database and data export for campaign management of several countries