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 validate the data in the data warehouse in isolation to detect violations of syntactic and semantic properties of the data.
  • Data balancing testing: We compare the data in the sources with the corresponding one in the target warehouse, and report undesired differences.