About the program

In this course you will be able to learn about complete ETL process, ETL testing areas and techniques, ETL testing tools, ETL testing SQLs, and a best practice of ETL testing that you can apply it in real ETL test environment.  

After completing this course you will be:

  • Clear about ETL process  and DWH(data WareHouse)
  • Know ETL testing areas and know testing techniques
  • Able to use ETL testing tools: QuerySurge, Informatica, …
  • Able to apply our work environment ETL testing technique

Audience:

This tutorial is designed for anyone who wants to learn ETL testing complete. It is especially going to be useful for testers want to be or is working in big data processing environment.

This lesson needs basic experience RDBMS and SQL. If you are not you may find these lessons from our portal.

Contact US

Call us : +1-800-543-5571
Mail us : training@infotek-solutions.com

Course curriculum

  1. ETL Architecture and process
    1. Extract data from source
    2. Transform data
    3. Load data to DWH
  2. Functions of ETL tools
    1. On Staging layer
    2. On Data integration layer
    3. On Data access layer
  3. Objective of ETL testing
  4. Challenges for ETL testers
    1. In terms of data
    2. In terms of access limitation
    3. In terms of complexity
  5. Tasks of ETL testers
    1. Understand business process
    2. Understand the source and reporting data
    3. View the data model
    4. View all mappings
    5. View schema and packages
    6. Understand ETL tools
    7. Go for testing
  6. ETL vs Database Testing
    1. Goal of test
    2. System type
    3. Tools used
    4. Business needs
    5. Modeling type
    6. Database type
    7. Data type
  7. ETL testing workflow
    1. Understand the business process and the ETL system
    2. Develop test scenarios
    3. Write test cases
    4. Choose testing tools: informatica, IBM datastage, QuerySurge
    5. Run testing and issue bugs
    6. Report and close test
  8. ETL testing Scenarios
    1. Structure validation
    2. Mapping document validation
    3. Constraint validation
    4. Data consistency validation
    5. Data completeness validation
    6. Data correctness validation
    7. Data quality and format validation
    8. Null and duplicate value validation
  9. ETL testing techniques
    1. Source to target count
    2. Source to target record check
    3. Check source to target data type
    4. Check source to target data range
    5. Check target constraints
    6. Duplication checkup
    7. Data mapping test
    8. Data increment test
    9. End data to report testing
    10. Minus query test
  10. Entity level testing
    1. Record test
    2. Column test
    3. Table constraint test
    4. Null value and duplicate test
  11. Attribute level testing
    1. Record test
    2. Datatype test
    3. Null value test
  12. Data accuracy test
  13. Data transformation test
  14. Data completeness test
  15. Data quality test
  16. Data increment test
  17. Metadata test
  18. SQL queries for ETL testing
  19. ETL non functional testing
    1. Performance testing
    2. Scalability testing
    3. Data accuracy testing
    4. Backup and recovery test
  20. Data warehouse level testing
    1. New DW testing
    2. DW migrating test
    3. DW change test
    4. Report testing
  21. Common types of ETL bugs
    1. Graphical interface bugs
    2. Boundary value bug
    3. Calculation bug
    4. Data loss bug
    5. Data type and range bug
    6. Input/output : valid/invalid value acceptance bug
    7. Multi user bug
    8. System crash bug
    9. H/W not responding bug
  22. Automation of ETL testing
  23. Tips and Tricks for ETL testing

Meet your mentor

About Trainer Rahul:

  • 7 years of IT experience in software testing, quality assurance and quality management.
  • Experienced in leading and managing medium to large testing teams.
  • Have extensively trained participants in the areas of Software Testing Concepts, Quality Assurance, Quality Center, QTP, LoadRunner, Bugzilla, JIRA and Selenium.
  • Testing process owner at the organization I have worked.
  • Have mentored resources and helped set a career path and achieve testing certifications.