Data Warehouse Monitoring
Client
For a healthcare provider based in Pennsylvania
Business Problem
- Monitor and support QlikView, ETL and batch jobs for a healthcare provider in Pennsylvania
- Communicate with downstream/upstream systems in case of any delays
- Track runtimes and monitor health of the components
Abzooba’s Solution:
- Proactive job monitoring through out the job runtime
- Periodic checking includes manual query run and checking DataStage logs to proactively find any delay or failure situation
- Scripts and ETL job development along with changes in existing job
- QlikView data load time analysis, data migration SQL scripts, mapping documentation and unit testing
- Data extract validation – Hospital data, Ambulatory data, AJRR data, etc.
Business Benefits:
- Maintaining automated batch execution independent of time of trigger file arrival
- High volume tables converted from full load to incremental load thereby reducing the overall execution time
- Prioritizing load for extract related tables to start extract ETL processes on schedule
Tech Stack
