Design Of Data Warehouse For Bank Using Pentaho
The company has online customer transaction data that is being replicated from a POS machine to 7 servers across India. To process this data in real-time, we are using the Pentaho ETL process, which reads the replicated data and stores it in a Postgres SQL data warehouse. This Enterprise Data Warehouse (EDW) serves as a single source of truth for reporting purposes and for monthly billing to customers and banks.
Technology Stack
- Technology: Pentaho Data Integration, PRD
- Database: Postgres SQL
- Project date: 01 July, 2019