For the best experience, try the new Microsoft Edge browser recommended by Microsoft (version 87 or above) or switch to another browser ľ Google Chrome / Firefox / Safari
OK

Ab Initio ETL Workload Migration to Apache Spark for a Bank

Xoriant Marketing
Xoriant-Banking-Success-Story-Ab-Initio-ETL-Workload-Migration-to-Apache-Spark

Client Background

  • Our client, a leading Fortune 100 company, is a global diversified financial service holding company with multiple business divisions.
  • The client used Ab Initio business intelligence platform for regulatory reporting and analysis. The powerful GUI-based parallel processing tool was used for Extract, Transform and Load (ETL) data management and analysis.

Xoriant Solution | Key Contributions

  • Xoriant BFSI team collaborated with the clientÔÇÖs engineering experts to understand vital information in setting up the ETL for data processing used for regulatory reporting and analysis. 
  • Developed a solution to help process metadata and job scheduler to reduce the use of Ab Initio with parallel and multiple rollouts.
  • Built a scalable and configurable framework for data ingestion with different modules and components using Java, Spring Boot, Apache Spark 2.4, Apache Hive, Avro file format and Oracle.

Key Benefits

  • Achieved close to 80% faster ad hoc report execution
  • Reduced 75% storage costs with the use of the framework.

 


Download The Case study
Image CAPTCHA
Enter the characters shown in the image.