HASHMAP SOLUTION PROFILE

DIVERSIFIED FINANCIAL SERVICES

Modernizing & Migrating Data Products to the Cloud

CHALLENGE

  • Migrate a multi-TB data warehouse appliance to the cloud for a wide range of applications and data products

  • Modernize data acquisition and transformation from traditional ETL flows to ELT in order to leverage the elasticity and scalability of a cloud data warehouse

  • Deliver secure, cloud-based financial services datasets in a simple, speedy, sustainable, and self serve approach

OUTCOME

  • Transitioned to a data as a service based approach

  • Delivered a comprehensive cloud data warehouse for financial services analytics and reporting that enables trusted, efficient, and scalable consumption 

  • Rapid, targeted, and effective data product delivery supporting the increasing demands of all consumers including data analysts, data scientists, and data engineers

APPROACH

  • Assisted in business alignment, understanding, and requirements definition engaging with business stakeholders, solution users, and technical owners

  • Collaborated on the design, architecture, and best practices for the overall solution approach

  • Implemented a set of use cases to validate flows, technology choices, and patterns across all dimensions of the solution

SOLUTION

  • Snowflake Cloud Data Warehouse in AWS (Migration from Netezza)

  • ELT / ETL

    • Matillion

    • DBT

    • IBM Datastage

  • Tableau

  • Control-M

  • AWS Data Sync and S3

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

Connect Now >