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