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
-