Customer Profile
A major U.S. property insurer managing 600 to 800 data interfaces and pipelines across Oracle, Oracle PeopleSoft, Guidewire, and AWS.
Business Challenges
- Validation took 90 to 120 minutes per segment, relied on manual execution, and covered only seven lines of business.
- Prior checks missed data type, database definition, substring, and source-to-target issues that surfaced downstream.
- Fragmented scripts and manual queries across 60 tables made reuse difficult and could not scale with growing data volumes.
How We Solved It
- Automated interface balancing and financial reconciliation across all critical systems using ETL Validator.
- Deployed a reusable validation framework with table-level workflows, replacing manual comparisons and custom scripts.
- Extended automated validation beyond QA into live production reconciliation and financial balancing controls.
Outcomes Delivered
- ~10x faster validation execution, from 90 to 120 minutes down to 5 to 10 minutes per segment.
- More than 2x expansion in line-of-business coverage, from 7 to 15.
- 60 table workflows built in approximately 3 days, with multiple previously undetected defects identified.