Soluções
Seguradora nacionalSaída de armazém legado
Migração faseada de SQL Server e ETL manual para lakehouse com cutovers validados para sinistros e apólices.
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.
Como abordámos
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.
O que entregámos
- Ondas de migração com escrita dupla e reconciliação
- Mapeamento de esquemas, contratos de dados e testes de regressão
- Planos de cutover sem downtime e ensaios de rollback
- Plano de descontinuação de servidores e jobs antigos
Resultados
One reconciled path for claims metrics across channels
Faster incident diagnosis with lineage to source systems
Decommissioned legacy footprint with archived audit trail
Stack representativo