What types of testing should be performed on ETL pipelines? How do you validate that an ETL job is working correctly?

Sample answer preview

ETL testing ensures that data pipelines work correctly and produce reliable results. Different types of tests address different aspects of pipeline quality. Data completeness testing verifies that all records from the source make it to the target.