<img alt="" src="https://secure.rate8deny.com/219096.png" style="display:none;">

Global Insurance Company modernizes their legacy Oracle / Informatica platform to Snowflake

A successful enterprise modernization that transformed Oracle and Informatica into a modern Snowflake ecosystem. 

Case study summary: Oracle Exadata and Informatica to Snowflake in 10 months

A leading multinational insurance provider modernized its Oracle Exadata and Informatica BDM environment to Snowflake in 10 months. Next Pathway re-architected more than 120,000 SQL objects and 20,000 ETL jobs into Snowflake, dbt and Apache Airflow, including 209 Informatica BDM mappings, 8,586 PL/SQL scripts converted to the Snowflake Task Framework and 5,355 PL/SQL scripts converted to dbt Cloud and Airflow. Next Pathway's NEXA Platform captured the logic and dependencies across Oracle and Informatica in its Enterprise Intelligence Graph, giving frontier models the context to automate translation across the estate.

Results: 1.3 PB of data and 800 billion records modernized onto Snowflake in 10 months; 8x faster data processing; near real-time streaming replacing micro-batch processing; ETL to ELT re-architecture unlocking Snowflake's parallel processing.

AI readiness: unified legacy data on a cloud-native platform built for advanced analytics, regulatory compliance and AI.

Download your free case study

Get the full story of how a global insurer modernized Oracle Exadata and Informatica to Snowflake in 10 months.

By providing information in this form, you agree to Next Pathway’s Privacy Policy

What Next Pathway's Global Insurance Provider Case Study Covers

A leading multinational insurance provider modernized Oracle Exadata and Informatica to Snowflake with Next Pathway's NEXA Platform, creating a scalable cloud-native data platform for faster analytics, regulatory compliance and AI.

d5ec1934-3478-43ae-9bef-1a9ed1fe5801

Oracle Exadata and Informatica Modernization

The insurer modernized its Oracle Exadata and Informatica environment to the Snowflake AI Data Cloud in 10 months, re-architecting more than 120,000 SQL objects and 20,000 ETL jobs with automated translation.

Snowflake-Powered Cloud Data Platform

Next Pathway re-architected legacy ETL into a modern ELT architecture on Snowflake, dbt and Airflow, delivering 8x faster data processing and near real-time streaming in place of micro-batch processing.

AI-Ready Data Foundation

The cloud-native platform gives the insurer a scalable foundation for advanced analytics, regulatory compliance and AI, with unified data access for faster insights.

billion-Icon

1 Billion+

Lines of legacy code translated

160-Icon

160+

Migrations and modernizations delivered

80-Icon

80%

Faster than manual and semi-automated approaches

Oracle Exadata and Informatica to Snowflake: frequently asked questions

Answers drawn from the global insurance provider case study.

How long did the Oracle Exadata and Informatica to Snowflake modernization take?

10 months. In that time 1.3 PB of data and 800 billion records were modernized onto Snowflake, and the insurer's legacy code and ETL were re-architected into Snowflake, dbt and Apache Airflow.

What legacy code and ETL was converted?

More than 120,000 SQL objects were converted to Snowflake-compatible SQL and more than 20,000 ETL jobs were converted to dbt and Airflow. That included 209 Informatica BDM mappings converted to dbt and Airflow, 8,586 PL/SQL scripts converted to the Snowflake Task Framework and 5,355 PL/SQL scripts converted to dbt Cloud and Airflow.

How did Next Pathway's NEXA Platform automate the translation?

Next Pathway's NEXA Platform captured the logic and dependencies across Oracle and Informatica in its Enterprise Intelligence Graph, giving frontier models the context to automate translation across the estate. Automated mapping and testing then confirmed data accuracy at scale.

What results did the insurer achieve?

Data processing became 8x faster, near real-time streaming replaced micro-batch processing, and automated translation removed manual recoding. The insurer now has unified data access that supports better customer outcomes, regulatory compliance and agile decision-making.

Why move from ETL to ELT on Snowflake?

Moving from ETL to an ELT architecture runs transformations inside Snowflake, which unlocks Snowflake's full parallel processing. Combined with pay-as-you-go cloud analytics, it gave the insurer a scalable, cloud-native foundation for advanced analytics, compliance and AI.

What Industry Analysts Say

Image (Rob Enderle)
Rob Enderle

ENDERLE GROUP

"Next Pathway is providing a solution that accelerates the migration process, giving organizations a faster route to realizing value from their data."
Eric Kavanagh
Eric Kavanagh

THE BLOOR GROUP

"SHIFT Cloud enables a remarkably swift and robust transition from traditional data warehousing to the cloud."

What a structured Snowflake modernization covers

A successful Snowflake modernization requires a clear plan across four disciplines.

Discovery and dependency mapping

Every code object, ETL pipeline and data dependency is identified and documented before modernization begins, so hidden complexity surfaces early and the program stays on schedule.

Code translation and modernization

Legacy SQL, stored procedures and ETL pipelines are converted into optimized, Snowflake-native workloads. Automated translation removes manual rework and covers the full estate.

Validation and functional parity

Every modernized workload is validated against the legacy source to confirm data accuracy and functional equivalence. Parity is proven before cutover.

Production cutover planning

Cutover needs a defined plan covering resources, rollback decisions and business sign-off. Teams that plan cutover from the start move faster and with greater confidence.

Latest Insights on Modernization

Cloud Migration Resources

DB2 & DataStage to Azure & Databricks
DB2 & DataStage to Azure & Databricks

Modernizing healthcare data with Azure and Databricks for faster analytics and AI readiness.

Informatica Workflows to Snowflake
Informatica Workflows to Snowflake

Hospitality Company Modernizes Informatica Workflows to Snowflake.

Teradata, DataStage, Informatica & Talend to Snowflake
Teradata, DataStage, Informatica & Talend to Snowflake

Global Financial Firm Modernizes with Snowflake Migration.

Start Your Snowflake Modernization

Thinking beyond migration? 
We help you modernize your data platform, end to end.

Contact sales