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