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

Connect Now >