pexels-kateryna-babaieva-2760243_edited.jpg

HASHMAP SOLUTION PROFILE

WORLDWIDE MANUFACTURING & INDUSTRIAL MACHINERY COMPANY

Reducing Data Latency with Snowflake & Matillion

CHALLENGE
  • Migrate from an on-premise Oracle data warehouse and Informatica ETL environment to the cloud to enable speed, simplicity, sustainability, and scale

  • Reduce load times and data availability latency to allow for new ERP and operational data sources and cloud-based data sources to be added quicker and easier

  • Engineer and architect new ELT pipelines to connect data sources to the cloud in Snowflake

  • Ensure minimal impact on existing teams

  • Create a roadmap for future architecture, migration, implementation, and everything above

OUTCOME
  • Modernized the overall technology stack, validated architecture, and(or) replaced/enhanced existing tools to better align with client needs

  • Generated detailed assessment and documentation outlining current solution landscape, target architecture, capacity planning, configuration, cost modeling, implementation, & migration 

  • Defined end state of data and analytics platform within Snowflake and Matillion

  • Proposed recommendations and shared best practices and documentation

APPROACH
  • Discover - Worked with key stakeholders to assess on-premise migration requirements, source systems, dashboards, DevOps, data pipelines, etc.

  • Design - Detailed documentation on current environment, pros/cons, and desired outcomes for future state solution

  • Develop - Collaborated in a series of design sessions and workshops to align with client vision and business outcomes

  • Deliver - Provided architecture for future state design, job migration plans, data pipeline designs,best practices, migration timeline/cost review

SOLUTION
  • Snowflake Cloud Data Platform (Migration from Oracle)

  • Matillion (Migration from Informatica)

  • Qlik

  • AWS

  • Hashmap Consulting Services 

    • Snowflake Cloud Data Strategy & Advisory

    • Snowflake Cloud Data Design, Engineering, & Architecture

    • Snowflake Optimization & Management

    • ELT migration accelerators