A cumbersome and slow Enterprise Data Warehouse (EDW) solution which adhered to a stringent set of schemas. The company needed a way to ingest data from various sources & house it in an easily accessible repository. Following this, they also needed to transform the data, storing business-critical metrics & KPIs in data marts, which would then be utilized by business users for analytics, visualization, & advanced data science activities.