Case Study: a leading investment bank achieves successful data warehouse migration and ETL testing with iCEDQ

Data Quality Assurance and Testing Case Study Bank Data Warehouse Migration and Integration Project

A leading investment bank faced a significant challenge while integrating a new Fixed Income system with its existing data warehouse. The multimillion-dollar, data-centric project required testing hundreds of new data feeds and thousands of existing ETL processes to ensure data quality for critical downstream systems like trading desks. To manage this complexity and risk, the bank turned to vendor iCEDQ and implemented their iQA data quality assurance and testing solution.

iCEDQ's iQA solution provided a formal testing framework and a web-based platform that enabled the creation and automated execution of thousands of data validation rules. This allowed for rapid testing of complete datasets, effective global team collaboration, and clear visibility into the testing process for management. The implementation resulted in the project being completed on time with a 20% reduction in testing resources and a 33% cost saving from utilizing offshore teams, all while effectively mitigating data quality risk.