The ETL Testing group is part of the Computer Science Department at Colorado State University. We are sponsored by the University of Colorado School of Medicine. Our research focuses on developing systematic testing techniques for the Extract, Transform, Load (ETL) process in an enterprise health data warehouse. The warehouse is called Health Data Compass and it uses Google Big Query headquartered at the University of Colorado Anschutz Medical Campus.

Current research includes:

  • Data quality testing: We test for a set of data quality rules defined by six healthcare organizations on the Health Data Compass on Google BigQuery.
  • Data balancing testing:  We compare the data in the source with the data in the destination model in the Data Warehouse and test it for consistency and completeness.