Your Team,
Your Location,
Our Instructors

TDWI Data Integration Testing: Ensuring Quality for ETL and Data Consolidation

Duration: One Day Course or Two Day Workshop

Prerequisite: None

Preview Course Materials Course Outline

Testing of software systems is always challenging, but testing data integration systems is especially difficult. Complex logic for consolidating data from disparate sources, data quality problems in source systems, "surprise" changes in source systems, and other factors combine to make data integration testing uniquely challenging. Although concepts of unit testing, stream testing, and system testing are still important, they alone are not adequate to the task of ensuring quality in data warehousing and data integration systems.

This course uses a combination of lecture, examples, and practice to teach effective testing techniques for data integration. From data profiling to stress and regression tests, you'll learn about effective models that can be used to apply the most powerful testing techniques throughout the data integration lifecycle.

You Will Learn

  • Why data integration testing is particularly challenging
  • The data quality challenges that are inherent in data integration systems and projects
  • Several testing techniques and the circumstances where each is most effective
  • How to test data integration systems throughout the lifecycle from requirements to deployment
  • Methods for effective test planning and test execution

Geared To

  • ETL and data integration system developers; data integration systems designers and architects; testing and quality assurance specialists; data warehousing and data migration project managers

Contact Us to Get Started Today


Yvonne Baho

Yvonne M. Baho Director, Enterprise Learning
Phone: 978.582.7105
E-mail: ybaho@tdwi.org


Check out the Onsite Brochure

Download Now


“Very good overall view of DW concepts and provided valuable insight for such a varied audience.”

Jerry Bundt
Nestle Purina

“This was the best training class I’ve had in my 20 year career.”

Tim Grieb
Seattle Children’s Hospital

“The instructor did an excellent job and demonstrated an understanding of real world applications.”

Sean Dewulf
Con-way Freight

Discover the impact Onsite Education has had on real Fortune 500 clients through practical in-depth training.

  • Banking
  • Healthcare
  • Manufacturing
TDWI has provided education to 95% of the Fortune 100 companies.
Our expert instructors will help your company surge ahead of the competition.