ETL Testing – Process

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.