01
Financial Services94%
Duplicate detection accuracy on live data
−61%
Duplicate contact volume within 90 days
Zero
Data loss incidents across 180K merges executed
Contact deduplication and identity resolution architecture
Designed a scalable contact deduplication and merge architecture for an enterprise Salesforce org with 2M+ Contact records spanning multiple business units.
The problem
The organisation had accumulated over two million Contact records across three merged business units, with no consistent identity resolution strategy. Duplicate contacts were causing incorrect service histories, failed marketing suppressions, compliance reporting errors, and agent confusion at the point of interaction. Multiple previous attempts to fix the problem through scheduled batch jobs had introduced data loss and partial merges that made the underlying model worse.
The architecture
We designed a deterministic identity resolution layer using a custom matching rule engine built on Apex, scoring contacts across email, phone, name variants and address normalisation. Matches above a confidence threshold were surfaced to a stewardship queue for human review before merge execution. The merge itself was implemented as a controlled Queueable chain to respect governor limits at scale, with full audit trail written to a custom object before and after each merge. Downstream systems were notified of canonical ID changes via Platform Events to prevent reference breakage.
Architecture highlights
- +Deterministic matching engine with weighted scoring across six identity fields
- +Confidence-tiered routing — auto-merge above 98%, human review between 85-98%, no action below
- +Queueable merge chain with governor-safe batching and rollback capability
- +Audit object capturing pre/post state for every merge operation
- +Platform Event publication on merge to notify downstream identity consumers
- +Stewardship UI built in LWC for data team review and override
