About the Client
The client is a healthcare technology company that offers software, analytics, network solutions, and technology-enabled services to help create a stronger, more collaborative healthcare system.
Client Need
- The client wanted the data from different sources to be available in the single source system to create meaningful dashboards and reports for better decision-making.
Our Solution
- Leveraged Talend as the ETL tool to migrate data from different sources to AWS hosted EDW which now acts as the input source for dashboards and other front-end tools.
- Created Data Vault Mart (DVM) for Customer Intelligence and Sales and Marketing functions.
- Migrated ETL routines from DataStage to Talend to enable desired transformation of data from different sources.
- Provided production support for multiple datasets which is being consumed by the end user for meaningful dashboards and reports.
Outcome
- Single source of truth for improved data intelligence capabilities.
- A common solution for deployment in on-premise as well public clouds.
- Solution is highly robust, scalable and tool-agnostic.
Tools & Technology
AWS
Salesforce
Oracle
Talend
Amazon
