A multinational banking and financial services company, with 3000+ offices in 60+ countries and around ~40 million customers.

 

Key Challenges

Validating huge amounts of masked data

 

Lack of end-to-end (E2E) dynamic and heterogeneous systems

 

Complexity of staging, ETL (extract, transform, and load), and Hadoop transformations

The Impact

50%

effort saved by using text-to-text comparator (RDBMS to Hadoop comparator)

Line

The Solution

End-to-End testing solution for Anti-Money Laundering (AML)

Our testing solution helped to reduce the overall testing effort by 35%.

Looking for a breakthrough solution?

talk to our experts
Putting our expertise in automation and validation to create an AML solution

Our testing solution is comprised of an open source automation stack, which handles data conversions, data comparisons and connecting to different layers of the Hadoop ecosystem.

40 million history records and 140,000 daily transactions are handled by our newly developed solution.

Innovating in the Fight Against Money Laundering

Infosys introduced many innovation in this project like Hive Output Formatter (HOF) and Transformation Traceability Matrix (TTM)

Our End-to-End testing solution for Anti-Money Laundering (AML) has the following key primary components:

  • Automated utility: Java-based, masked data validator compares masked and unmasked data with the data dictionary
  • Comprehensive TTM: This helps in creating test scenarios for specific functional changes as well as overall impacted areas
  • Query output formatter: A Hive Output Formatter to format and analyze Hive query outputs
  • Text-to-text comparator: Java utility created to compare two pipe delimited text files, field by field
  • End-to-end regression automation framework (in HDFS / Hive and ETL): Ensures one-time synchronization of all UNIX boxes
Enhancing quality assurance and testing procedures

Whitepaper

Enhancing quality assurance and testing procedures

This paper outlines seven key areas that the QA and testing functions must focus on to enhance their organizational maturity and apply innovation in their day to day work.

Ready for Disruption?