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.