* Stage Tables
* Business Logic Transformation
* Target table loading from the staging table, once we apply the transformation.
Responsibilities of ETL tester are :
* ETL tester tests the ETL software thoroughly.
* The tester will check the test component of the ETL Data Warehouse.
* The tester will execute the data-driven test in the backend.
* The tester creates the design and executes the test cases, test plans or test harness, etc.
* Tester identifies the problems and will suggest the best solution also.
* Tester approves the requirements and design specification.
* Tester transfers the data from flat files.
* They write the SQL queries for the different test scenario.
