HASHMAP SOLUTION PROFILE

CONVENIENCE STORE RETAILER

Cloud & Data Modernization Enabling Customer 360, Loyalty Analytics, and Merchandising Analytics

CHALLENGE
  • Simplify and increase analytics velocity from the previous Hadoop Data Warehouse environment

  • Replicate the existing Hive environment to the cloud in AWS and Snowflake while keeping the data pipelines sustainable and minimizing rework

  • Increase the level of SQL usability via to match with the existing skillsets

  • Provide end user self service consumption via Tableau 

  • Lower overall costs for the data platform and services

OUTCOME
  • Provided initial technical assessment and justification for enabling both a business and technical approval for a cloud based service approach for retail analytics including Customer 360, Loyalty, and Merchandising

  • Facilitated a cloud migration and modernization that included data acquisition (one-time bulk load and incremental CDC), data transformation, data persistence, and data consumption

  • Helped in saving significant opex by moving away from a annual contract model to a pay-by-the-second credit based approach with Snowflake

APPROACH
  • Mentoring and coaching during the migration featuring hands-on demonstrations and quick mini-POCs across a variety of dimensions showcasing Snowflake features and capabilities including:

  • Data loading of table extracts

  • Cloned tables, staged stables, connected via JDBC and via Tableau

  • Databricks to Snowflake connector

  • Knowledge transfer

  • Snowpipe ingestion from S3

  • Best practices and guidelines

  • Provided documentation

SOLUTION
  • Snowflake 

  • AWS

  • Attunity Replicate

  • Tableau

  • Databricks

  • Hashmap Consulting Services: Assessment, Design, and Architecture Enablement Services, Cloud Modernization and Migration Services, Data Engineering and DataOps Enablement

HashmapLogoBlack_edited.png
  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Hashmap Stories
  • Data Rebels on Tap on Spotify
  • Hashmap on YouTube
  • Hashmap on Instagram

© 2020 by Hashmap, Inc.