Home>Big Data Administration

Big Data Administration

Client

Healthcare Provider

Business Problem

Our client was looking for a partner to help them manage their ETL and Visualization platforms and monitor the health of associated components

Objective

  • Monitor and support QlikView, ETL and batch jobs for a healthcare provider in Philadelphia
  • 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