Claims Data Modernization: From Multi-Stack Chaos to a Unified Data Lakehouse

The Situation

Serving Underserved Markets Needed a Modern Foundation

A major US auto carrier was running claims data across Cloudera, SQL Server, Informatica, and multiple legacy ETL tools with Tableau and Business Objects pulling from different sources. The result: governance gaps, duplicate data, and no enterprise-wide source of truth.

The Challenges

Claims data fragmented across multiple on-prem stacks

Tableau and BO reports drawing from different data sources gave inconsistent outputs

300+ ETL jobs spread across Informatica, SSIS, Sqoop with high maintenance burden

No single source of data for enterprise BI consumption

How We Solved It

Replaced legacy architecture with a unified AWS Data Lakehouse (S3 + Redshift)

Migrated 1,800+ entities from Cloudera on premises to AWS

Replaced legacy ETL with AWS Glue, Lambda, and PySpark

Enabled advanced analytics and ML capabilities on a unified model

Tech Stack

AWS S3

Glue

PySpark

Redshift

Guidewire CDA

Business Outcomes

What Delos Gained

1,800+

Entities Migrated

300+

ETL Jobs Modernized

3+

Subject Areas Unified

Key Benefits

Built to Compete. Designed to Grow.

✓

Single source of truth for BI and reporting across ClaimCenter, PolicyCenter, and BillingCenter

✓

Reduced infrastructure and maintenance costs significantly

✓

Faster data processing and ingestion timelines

✓

Improved security with fine-grained access control and operational resilience