Nationwide

Supporting a large-scale Netezza-to-Snowflake migration with precise data validation.

Project Details

Data Services, Data Engineering, Data Migration, SQL Validation

Country:United States
Industry:Financial Services
Engagement:Data Engineering | Data Migration | Data Services | SQL Validation
71-Website Project Portfolio Image

About

Nationwide is a Fortune 100 insurance and financial services organisation based in Columbus, Ohio, known for innovation and a people-first culture.

The Challenge

Nationwide needed to migrate over 600 data tables (each with millions to billions of rows) from IBM Netezza to Snowflake, while ensuring absolute data integrity.

The Solution

auticon’s autistic data engineers validated data by running comparative SQL queries in Databricks to ensure consistency between source and target, receiving platform training and certification during the process.

The Benefits

Accurate and efficient migration of massive data sets

  • Up-skilled team in modern platforms
  • Inclusive hiring aligned with corporate values

The Highlights

Used Databricks for dual-query validation

  • Team trained and certified on-the-job
  • Full data integrity ensured across complex schemas

Social Impact

Enabled neurodivergent engineers to gain real-world platform experience while delivering high-value outcomes for a Fortune 100 company.

It requires a human touch to successfully execute a data migration project of this magnitude… We felt confident in deploying auticon because of its reputation for delivering first-class work.

Jim Fowler
Chief Technology Executive, Nationwide
Skip to content