Home > Data Warehouse Monitoring

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

Speak to AI expert