Informatica MDM
DWH Extension
Informatica MDM Extension for Snowflake & Google BigQuery for Retail Domain
Requirement
Informatica, being one of the leader MDM Solution provider wanted their customer to be privileged with out of box solution to ingest their master data to customers’ DWH and then build analytical pipeline to load data and build analytical use cases for retail domain
Technology
- Informatica IICS
- Google BigQuery, Snowflake
- Google Looker, PowerBI
What We Did
- Created Staging Data Model for Snowflake and Google BigQuery aligned with Informatica's Master Data model
- Created Analytical Data Model aligned with retail use cases
- Implemented Informatica egress Jobs to load data from Informatica to DWH staging layer
- Implemented Informatica PDO (Push Down Optimized) jobs to load data from stage to analytical data model in DWH
- Created retail specific dashboards on top of analytical model of DWH using Google Looker and PowerBI
Value Delivered
- Out-box jobs bundled with Informatica to ingest master data to Google BigQuery and Snowflake.
- Out-of-Box Data model for staging and analytics readily deployable in customer DWH hosted in Snowflake or Google BigQuery
- BI Dashboard using Google Looker and PowerBI