pexels-james-wheeler-1598075_edited.jpg

HASHMAP SOLUTION PROFILE

NORTH AMERICAN TRANSPORTATION,
FREIGHT, & LOGISTICS COMPANY

Migrating  On-Prem Data Sources to Snowflake in Azure

CHALLENGE
  • Accelerate the design, validation, and implementation of a new cloud architecture to ensure timely delivery of target business cases and migration of key data sources (SQL Server, Netezza, Hadoop, and Exadata)

  • Implement cloud infrastructure & a variety of data pipelines

OUTCOME
  • Successfully migrated legacy on-prem workloads to the cloud

  • Utilized terraform to deploy and automate cloud solutions

  • Developed data pipelines for multiple source systems 

  • Defined procedures and patterns for new use cases developed in the data lake

  • Implemented Cost Savings and Cost Monitoring approaches

  • Delivered detailed reference architecture for the future-state cloud data platform

  • Provided executive summary/comparison of Snowflake/ Azure Synapse

  • Shared security guidelines and best practices for cloud infrastructure and enterprise data platform

APPROACH
  • Discover - Provided cloud architecture design, infrastructure deployment, and use case delivery services

  • Design - Validated and augmented existing cloud reference architecture by providing analysis of component alternatives, architecture gaps, and iterative deployment strategies that emphasized automation and CI/CD processes

  • Develop - Migrated source systems and allocated compute resources for cost control and established automation and security practices for rapidly-maturing cloud foundation

  • Deliver - Shared detailed reference architecture for the future-state cloud data platform and successfully migrated source systems

SOLUTION
  • Azure

  • Azure Data Factory

  • ADLS

  • Databricks

  • Terraform

  • Snowflake

  • Hashmap Consulting Services 

    • Cloud Data Strategy & Advisory

    • Cloud Data Design, Engineering, & Architecture

    • Migration & Modernization Services

    • Cloud Cost Monitoring and Security Services