contact@abzooba.com
Get In Touch
Why Abzooba
Industries
Retail
Advanced Analytics
Big Data and Cloud
Healthcare
Advanced Analytics
Big Data and Cloud
BFSI
Advanced Analytics
Big Data and Cloud
Others
Advanced Analytics
Big Data and Cloud
Technology
Big Data and Cloud
Advanced Analytics
Partners
Platform
xpresso.ai
Olive
Pine
Resources
10th Anniversary
COVID-19
Case Studies
Advanced Analytics
Retail
BFSI
Healthcare
Others
Big Data and Cloud
Retail
BFSI
Healthcare
Others
Blogs
White Papers
News & Events
Videos
AASTHA – Our Responsibility
Olive
Olive – Product Information
Olive – Product Information for Azure Marketplace
Home
>
Data Warehouse Monitoring
Case Study: Healthcare
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