Data Warehousing and ETL Development

Customer Success Story Highlights

Client

  • Leading Asia Pacific bank

Challenge

  • Review of the current Warehouse ETL frame work & highlight the areas of improvements & propose design changes

Solution

  • Established a Data Warehouse to meet SLA with various downstream data marts.

Benefits

  • Significantly improved the performance of ETL jobs thereby reducing customer complaints.

Client Overview

Client is a leading regional bank in the Asia Pacific

Key Engagement Highlights

Review of the current Warehouse ETL frame work & Design.

Highlight the areas of improvements & propose design changes with POC.

Implement the ETL enhancements with agreement & endorsement from DBS.

Benefit realization with statistics on DQ & performance.

Opportunity Context

  • ETL Improvements Project with key objective to improve the Data Quality and Performance of the warehouse..

Benefits to Client

  • Significantly improved the performance of ETL jobs thereby reducing customer complaints.
  • Established a Data Warehouse to meet SLA with various downstream data marts for the Business Units like CPMS & Risk Management Group.