etl-validation

Data Migration Testing | Data Reconcilation

Reusable dbt data-quality tests for healthcare: NHS number checksums, ICD-10/CPT format, date sanity, staging-to-mart reconciliation, duplicate claims and null-rate checks, proven on DuckDB by a labeled synthetic harness (1.0 recall over 160 violations, 0 false positives) with a severity-weighted scorecard from dbt artifacts.