contact@hashmapinc.com (general inquiries/questions)

-or-

careers@hashmapinc.com (send your CV/Resume to start the process of becoming a Hashmapper)

(770) 857-3919

ATLANTA

1000 Holcomb Woods Pkwy

Building 100, Suite 118

Roswell, GA 30076

HOUSTON

440 Cobia Drive

Building 204

Katy, TX 77494

TORONTO

4145 North Service Road

2nd floor

Burlington, Ontario L7L6A3

INDIA

Midas Tower

Plot # 44, RGIP Phase 1

Hinjewadi, Pune

Maharashtra, India

  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Hashmap Stories
  • Listen to IoT on Tap with Hashmap
  • Hashmap on YouTube
  • Hashmap on Instagram

©2019 by Hashmap, Inc.

OKC

1141 W Sheridan Ave

Suite P2

Oklahoma City, OK 73106

SNOWFLAKE 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
     

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

OUTCOME
  • Comprehensive migration and testing plan confirming that the migration is accomplished for reasonable effort, time, risk, and cost

    • Solves for Netezza end of life support

    • Provides for better SLAs via Snowflake’s SaaS

    • Optimizes infrastructure cost including hardware and licensing spend

  • Provided the following

    • Technical Architecture

    • Financial TCO

    • Migration Plan and Timeline

    • Migration Cost Estimates

SOLUTION
  • Snowflake Cloud Data Warehouse in AWS

  • S3

  • Informatica

  • Hashmap Consulting Services: Cloud Data Architecture, Data Warehouse Migration Services, Data Warehouse Engineering, Data Integration & Pipelining

Connect with Hashmap

  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Tech & Engr Blog
  • IoT on Tap with Hashmap
  • Hashmap on YouTube