HASHMAP SOLUTION PROFILE

GLOBAL TECHNOLOGY COMPANY

Migration Assessment and Validation Testing for Netezza to Snowflake in AWS

CHALLENGE

Assessment and validation testing for migration of an on-premise Tier 1 Netezza Data Warehouse to Snowflake for a 1,500 user base
Netezza operates in a series of peaks and valleys and has a narrow data load window from source systems
Assess and test existing ETL workflows for code compatibility issues

OUTCOME

Comprehensive migration and testing plan confirming that the migration will be a reasonable effort, time, risk, and cost
- Solves for Netezza end of life support
- Provides for better SLAs via Snowflake’s SaaS
- Reduces infrastructure cost including hardware and licensing spend
Provided the following
- Technical Architecture
- Financial TCO
- Migration Plan and Timeline
- Migration Cost Estimates

APPROACH

A series of assessments and technical testing validations across a number of dimensions including:
- Migration style
- Migration design planning
- Model/User Migration Considerations
- Data Migration Options
- Query and Workload Migration Options
- ETL to ELT Migration Process
- Parallel Operations
- Financial Impact

SOLUTION

Snowflake
AWS
Informatica
Hashmap Consulting Services including:
- Cloud Data Architecture
- Data Warehouse Migration Services
- Cloud and Data Engineering
- Data Integration & Pipelining

Reach Out >