ETL testing is a demanding process that should be completed in the following order :
Define the business requirements : Liaise with the client to understand their reporting needs and define the scope of the project
Validate data sources : Perform a data count check and ensure check keys are in place
Design ETL logic : Design the mapping sheet, SQL script, and transformational codes
Extract source data : Identify any bugs during the extraction phase
Transform data : Make sure data is transformed consistently
Load data : Perform a record count check and verify the accuracy of the loaded data
Review process : Verify the validity, layout, and export functionality of the summary report
File test report : Share test results with the relevant stakeholders