etl-validation

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.

Auditable EHR data infrastructure for patient world models and clinical agents: source-linked conversion of hospital exports into OMOP CDM 5.4 and MEDS, with 55 checks that read the published artifacts

Tiered data reconciliation for database migrations. Verifies source-target parity with aggregate checks, partition hash fingerprints, and a block binary search to row-level diffs, moving under 1 percent of the bytes of a full transfer. Dialect-correct SQL for Oracle, SQL Server, Snowflake, DuckDB, and SQLite.

Data Migration Testing | Data Reconcilation