![case study](https://cdn.quantiphi.com/2024/03/e1433d1b-banner-image.jpg)
Centralized Lake House
Banking & Financial ServicesBusiness Impacts
70%
Reduction in time to market
Operational Efficiency due to self-triggering ETLs and data transformations for warehouse ingestions
Single view of data with a centralized lake house
Customer Key Facts
- Location : India
- Industry : Financial Services
Challenges
- Insurance claim data was highly confidential, thereby needed to be secured in transit
- The business had around 1600 tables and a lot of attributes to work with for reporting
- Absence of proper Data dictionary and Data Lineage tracking feature
Technologies Used
![AWS Glue](https://cdn.quantiphi.com/2024/02/e5b01517-arch_aws-glue_64@5x-1.png)
AWS Glue
![Amazon Redshift](https://cdn.quantiphi.com/2024/02/Amazon-Redshift_light-bg@4x-1.png)
Amazon Redshift
![Amazon S3](https://cdn.quantiphi.com/2024/02/9c40e5d8-amazon-s3.png)
Amazon S3
![Amazon EC2](https://cdn.quantiphi.com/2024/02/Amazon-EC2_light-bg@4x.png)
Amazon EC2
![AWS Lambda](https://cdn.quantiphi.com/2024/02/83e09c49-aws-lambda.png)
AWS Lambda
![AWS IAM](https://cdn.quantiphi.com/2024/02/AWS-Identity-and-Access-Management_IAM_light-bg@4x.png)
AWS IAM
![Amazon VPC](https://cdn.quantiphi.com/2024/02/Amazon-VPC@4x.png)
Amazon VPC
![Amazon SNS](https://cdn.quantiphi.com/2022/11/Amazon-Simple-Notification-Service-SNS_light-bg@4x.png)
Amazon SNS
Solution
Quantiphi helped to migrate historical data and built integrated data sources pipelines for daily incremental data ingestion and processing. We also built automated ETL pipelines for cleaning, transforming data, and loading it to serve as a data warehouse.
Results
We have successfully created a centralized Data Lake across three banking verticals for BI Dashboarding and efficient reporting purposes