ETL Validator is a tool that can greatly simplify testing of Data Integration projects. It uses a data-centric testing approach to help automate ETL testing, Flat File testing and Database testing. Some of the tests of ETL Validator include:

• Compare source and target data to verify that the ETL ran as expected during incremental and full loads
• Verify the data in flat files is as expected and got loaded properly
• Data in the source systems is conforming to data rules for data accuracy, integrity and consistency

Read more about ETL Validator