ETL Development, Testing, and Data Visualization for a Global Finance Consulting Firm
Overview
Our client, a leading global boutique consulting firm specializing in capital markets risk and regulatory strategy, sought to revamp their Anti-Money Laundering (AML) application. Their objective was to replace the existing system with an Oracle AML implementation capable of supporting both Transactions and Customer Screening processes.
Download Case Study
Challenges
Replace the outdated AML application with a robust Oracle AML solution that supports AML for transactions and customer screening business processes
Develop rich interactive dashboards at the account level for in-depth financial analysis
Ensure seamless data migration and integration from various existing sources
Solution
- Implemented Informatica pipelines for seamless data extraction, transformation, and loading from diverse sources into Oracle AML
- Utilized Python-based Great Expectations for automated data quality testing
- Implemented scenario-based testing using Pytest framework to ensure the accuracy and functionality of loaded data
- Adopted Google Data Studio for data visualization to create interactive dashboards for real-time analysis of critical financial metrics
Outcomes
- Smooth transition to Oracle AML, ensuring regulatory compliance
- Enhanced data reliability through automated testing
- Real-time access to critical financial insights for faster decision-making
- Improved efficiency and productivity across the organization
