success story

A leading Australian bank increases productivity by 60%

by switching to AWS cloud and Talend

Our client, a leading Australian bank, used a legacy data warehouse and siloed ETL tools for its home loans business unit. The existing tools delayed the data retrieval process slowing down the reporting of home loan transactions impacting performance and productivity. Owing to rising operational, licensing, and maintenance costs, the enterprise data warehouse (EDW) maintenance and support turned out to be expensive. The data provided by the legacy EDW was not sufficient for downstream dashboards and machine learning (ML) applications.

To address these mounting concerns, the client decided to migrate to AWS S3 data lake and replace its siloed ETL tools with Talend ETL.

The Challenge

Our client was overwhelmed by the rising cost of maintaining a legacy data warehouse and running inefficient ETL tools for its home loans business unit.

 Key challenges include:

  • High operational and maintenance costs of the legacy data warehouse
  • Delayed data retrieval slowed down the reporting of home loan transactions
  • Insufficient data for downstream dashboards and machine learning (ML) applications
  • Rising licensing costs of the incumbent datastore
The Solution

Virtusa built a proprietary data platform solution on AWS by leveraging the data vault model and replaced incumbent ETL tools with Talend.

  • The data platform was equipped with dashboards that helped track staff performance against targets, improving overall productivity.
  • The data platform generated revenue and regulatory reports for monitoring growth and ensuring compliance.
  • Data was loaded into the staging layer using a framework designed on Spark & Scala with the source data available on AWS S3 buckets.
  • The data integration process was migrated from existing ETL tools to Talend DI and Talend Big Data.
  • 300 business rules were implemented across 75 attributes.
  • 760K accounts were processed.
  • Views were created using HIVE scripts for consumption by downstream systems.
  • Tableau extracts were created using Talend.
AWS cloud and Talend Migration Solution
The Benefit

Virtusa helped the client achieve operational excellence, reliability, and cost optimization by building a data platform on AWS.

Key business benefits include:

  • 60% increase in operational efficiency
  • 3x reduction in cost with Talend as compared to existing ETL tools
Accelerate enterprise Cloud adoption with Virtusa

We offer end-to-end services right from helping you jumpstart your AWS journey, to migrating and managing solutions from the AWS suite.

Related content