FinCrime data was scattered around different teams at the bank in many different formats, resulting in inaccurate reporting.
Create a unified data hub with automatic ingestion for all FinCrime data that can serve accurate, up-to-date data to Tableau for report generation.
We set up a system of automated StreamSets pipelines that ingest data directly from source systems such as Oracle and MongoDB into a Snowflake data hub. Data Quality checks, error handling, and monitoring are performed on the pipelines, and Tableau reports connect directly to Snowflake for final reporting.
StreamSets
Scala, Spark
Snowflake
Tableau
Amazon S3
AutoSys
Tivoli
