Banking

Enterprise Data Warehouse

Enterprise Data Warehouse

Description

DHW is a centralized place to store and process business data for data-driven analysis & reporting. EDWH is the main reporting platform for the Head office.

Customer

Raiffeisen Bank International considers Austria and Central and Eastern Europe (CEE) its home market.

In Austria, it is the leading commercial and investment bank. In Central and Eastern Europe, its subsidiaries service the largest proportion of businesses. 16.8 million customers are serviced through 2,000 business outlets reaching across Corporate, Retail, and Investment Banking.

Solution

Backend applications implemented using Java and Spring stack. Each spring boot application provides custom API for the customer and communicates with existing card systems via REST, Web services, SOAP, or other technologies. 

Core features

  • Business Data Model (BDM) / data dictionary
  • In-house app LCM (Life Cycle Management) – all mappings, data lineage report (Landing Zone – Stage – Core – Analytical Applications)
  • Custom ODI framework for loading data into various EDWH layers (48 source systems)
  • Full data historicization
  • Special tool for generating ODI interfaces (ETL) from LCM mappings – Workbench (in-house)
  • MDM (Master Data Management)
  • Continuous Delivery
  • Reconciliation
  • Automated daily regression testing (with JIRA integration)
  • Automated data quality checks/data anomaly detection

Core competences

Agile developmentBusiness intelligenceData integrationData modelingData warehouseHigh data volume processing

Technologies

Oracle Data Integrator (ODI)TeradataUC4
Other projects
Dealfabrix Screenshot
Banking
Document store for Dealfabrix
Inventory
Telecommunications
Telecommunications Inventory Visualisation