Exasure One · Core Modernization

Fortune 100 Carrier Moves Claims & Policy DWH to AWS

Fortune 100 Multi-Line Insurance Carrier
2024
California, US
Homeowners Insurance
The Situation

Serving Underserved Markets Needed a Modern Foundation

A Fortune 100 insurer’s Claims and Policy Data Warehouse built on Teradata, Oracle, and Talend had become a costly liability. With high operational overhead and zero scalability, they needed a zero-disruption migration to AWS cloud.

The Challenges

On-prem Teradata and Oracle DWH with high infrastructure and maintenance costs
120+ ETL jobs in legacy Talend and SQL, brittle and slow
500+ tables to migrate with no tolerance for data quality issues
Need for on-demand scalability without disrupting live operations
How We Solved It

1

Built processing layer on Databricks with Delta Lake on AWS

2

Developed Raw, Harmonization, and Curation layers for structured data flow

3

Migrated ETL routines using PySpark and SQL on Databricks

4

Used Tosca for data verification and quality assurance across all layers

Tech Stack
AWS
Glue
Databricks
Delta Lake
Tosca
PySpark
Business Outcomes

What Delos Gained

500+

Tables Migrated

40%

Reduction in Maintenance Overhead

30%

TCO Savings
Key Benefits

Built to Compete. Designed to Grow.

✓
On-demand scalability, scale up or down based on processing needs
✓
Faster query processing and analytics across policy and claims data
✓
Covers Policy Center and Claim Center subject areas fully
✓
Cleaner data quality through automated Tosca verification
Case Details
Client
Fortune 100 Multi-Line Insurance Carrier
Segment
Homeowners Insurance
Region
California, US
Year
2024
Status
● Live
Product
Exasure One
Platform
Multi-Line
Headline Numbers
Go-Live
4 Months
Integrations
10+
Cost Impact
Launch Speed
Faster
See how Exasure One can accelerate your Guidewire journey.
Talk to an Expert