An internal tool aimed at integrating various data sources for reporting and analytics. The main aim is to cut down on time and resources spent on manually adding each source every time a new client is added.

Product owner has data coming in all the time from similar sources through similar but separate processes. Why work on the same sources again and again for every new client that comes in? The current sourcing system is not scalable and requires high manual effort in every case.

Features

• Automate data extraction and loading at scheduled times
• Integrate all the data resources in a single data warehouse
• A user-friendly UI to enable all the teams to access tool and add clients as per their requirements
• Data transformation after extracting from the source systems so that data is loaded into AWS Redshift data warehouse faster
• Independent size of the loaded data
• Scalable and marketable

Screenshots