Solutions
Assureur nationalSortie d’entrepôt legacy
Migration par vagues depuis SQL Server et ETL artisan vers un lakehouse avec bascules validées pour la sinistralité et les polices.
Years of SQL Server jobs and hand-built ETL meant the same metrics were calculated three different ways. We staged a lakehouse-shaped target, validated every cutover with reconciliation, and retired legacy servers on a schedule the business trusted.
Notre approche
Wave planning
Claims and policy domains migrated in waves with dual-write windows and explicit exit criteria before widening scope.
Contracts & tests
Schema mapping with data contracts, regression packs, and signed-off parity checks between old and new pipelines.
Cutover discipline
Zero-downtime playbooks, rollback drills, and on-call bridges so operations knew exactly who to call during migration night.
Ce que nous avons livré
- Vagues de migration avec double écriture et rapprochements
- Mapping schémas, contrats de données et jeux de tests de non-régression
- Plans de bascule sans interruption et exercices de retour arrière
- Plan de décommissionnement des serveurs et jobs historiques
Résultats
One reconciled path for claims metrics across channels
Faster incident diagnosis with lineage to source systems
Decommissioned legacy footprint with archived audit trail
Stack représentatif