1 / 2

ETL Testing life cycle

ETL testing requires manual testing steps and testers who understand the essential of an ETL Tool, Database, SQL, basic UNIX commands, etc., following are the varied phases typically followed in ETL Testing.

bhanu2149
Download Presentation

ETL Testing life cycle

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ETL Testing life cycle ETL testing requires manual testing steps and testers who understand the essential of an ETL Tool, Database, SQL, basic UNIX commands, etc., following are the varied phases typically followed in ETL Testing. Requirement Understanding:- ➢Review BRD, Technical specification document, and data mapping document. ➢Attend Technical Specification Walkthroughs ➢Work with business analysts and understand the structure, usage of source data. ➢Identify all the problems and work with business analysts to clarify the data-related issues mapping issues data transformation logic's etc., and confirm that there are not any gaps. Test Plan:- ➢Test Estimation ➢Preparation of test cases with all the test scenarios possible. ➢Review the test cases with Business Analyst. Test Data Creation:- ➢Understand the structure of source data. ➢confirm that each one the tables are updated with referential data if the source or target data is in one or more tables. ➢make sure that the test data is made altogether the associated tables ofter thoroughly understanding the info model.

  2. Test case Execution and Test Results Reporting:- ➢Run the ETL application jobs. ➢Check the target data and structure and confirm that the info is complete and valid for the test. ➢Write simple to complex SQL Queries to see the expected results when the info sources are in multiple tables. ➢Check the ETL tool logs for the abnormal termination error causes. ➢Work closely with the developers and business analyst for all the testing related issues. ➢document the test metrics with variety of test cases, no of defects, source of every defect, etc., for every test cycle For more information About this courses Please go through this link ETL Testing Online Training Contact Information: USA: +1 7327039066 INDIA: +91 8885448788, 9550102466 Email: info@onlineitguru.com

More Related