What is Data Testing/ETL Testing and the Challenges in ETL testing?

ETL is commonly associated with Data Warehousing projects but there in reality any form of bulk data movement from a source to a target can be considered ETL. ETL testing is a data centric testing process to validate that the data has been transformed and loaded into the target as expected.

In this lecture we also talk about data testing and challenges in ETL testing.