Case Study: a large pharmaceutical firm improves ETL build health and data integrity with QuerySurge

Pharmaceutical Firm Receives Clean Bill of "Build Health" for Critical Safety Data

A large pharmaceutical firm faced significant challenges in verifying the data integrity of its safety data warehouse, which was critical for compliance and public health. The firm needed to test massive volumes of data pulled from multiple sources, produce thorough audit trails, and deploy a scalable data quality solution. They turned to the vendor QuerySurge to address these issues.

QuerySurge implemented a solution using approximately 1,000 SQL queries to compare source data with the data warehouse after ETL, sampling about 45% of the data in each build cycle. This process, powered by QuerySurge, identified and helped remediate 115 defects, increased testing coverage by 10 times, and decreased testing time by a factor of three. This allowed the quality team to provide high-confidence "build health" numbers and enabled the successful deployment of a release candidate with zero defects.