ETL testing covers all the steps involved in an ETL lifecycle. It starts with understanding the business requirements till the generation of a summary report.
The common steps under ETL Testing lifecycle are listed below −
Understanding the business requirement.
Validation of the business requirement.
Test Estimation is used to provide the estimated time to run test-cases and to complete the summary report.
Test Planning involves finding the Testing technique based on the inputs as per business requirement.
Creating test scenarios and test cases.
Once the test-cases are ready and approved, the next step is to perform pre-execution check.
Execute all the test-cases.
The last step is to generate a complete summary report and file a closure process.