This course provides attendees with an end-to-end understanding of how data warehouse (DWH), data integration, and ETL testing can be successfully accomplished in a planned and disciplined manner.
Class participants are introduced to each phase of ETL (Extract-Transform-Load) testing and validation. They will learn to develop and execute a testing strategy that leads to effective and complete testing.
In order to assure that the ETL development process, ETL tools for extraction, business rules for data transformation and data loads are correct, it is essential to carefully prepare test plans and test cases using best methods, processes, and tools. The QA team and project managers, along with business and other IT participants, will gain confidence in their data warehouse and BI development only after efficient and successful testing of the entire ETL process – one that is well planned and executed by a team of test experts who are proficient in ETL testing.
The course demonstrates how to choose the categories of testing you’ll want to include in your DWH quality assurance plan so that you can flexibly redefine a test plan as needed to grow from a simple data mart effort all the way to enterprise warehousing projects that require multiple releases.
ETL quality assurance is addressed from several perspectives: why test, what to test, tester qualifications, when and how to test. We identify how to choose the categories of testing you’ll want to include in your planning so that you can flexibly define a test plan as needed to grow from a simple data mart effort to enterprise warehousing projects that require multiple releases.
The course is appropriate for novice and experienced IT staff. The typical student will be a data warehousing practitioner, database developer, or database tester although it is not uncommon to have purely business individuals or people new to this space on the course.
Knowledge of databases and their interaction is a distinct advantage as technical terms are often used.
Course Duration: Up to eight hours.
Training Delivery: Instructor lecture with Q & A.
At the end of this course, class participants will:
After the course, the instructor will answer any follow-up questions and provide additional related advice, papers, presentations, sample test plans and test scenarios from a large collection resulting from years of research into ETL and BI testing. Attendees are encouraged to take advantage of this valuable support available for free 5 days after the course.
Following is the course syllabus describing session topics, learning objectives and agenda.
The Introduction and Concepts topic provides basic concepts as a common basis for each of the following topics. Other topics basically follow the order of planning, resourcing, and execution of DWH QA ramp-up.
Learning objectives and agenda: At the end of the presentation, learners should be able to understand the terms that will be used throughout the course, the basic flow of data and testing on an ETL QA project, and the ability to comprehend DWH requirements as expressed in data mapping documents.
Learning objectives and agenda: As a result of this subject matter, participants will understand the variety of test planning and execution challenges to be addressed before detailed planning and resourcing is implemented. Root causes of several challenges will be described so that they can be appropriately addressed.
Learning objectives and agenda: Based on information in this topic, participants will gain an understanding of how to initiate the test planning process based on goals and a standard master test plan template. Through observations of a DWH planning template and associated checklists, participants will be able to derive from these to create effective plans of their own. Attendees will learn the importance of test plan static reviews among the QA team and others on the project.
Learning objectives and agenda: Students will be exposed to examples of numerous DWH test defects and the phases of verification in which they may be found. In addition, they will be able to write test cases which are likely to expose those issues. Basic SQL queries and data profiling techniques are presented so that participants can delve more deeply into learning these key skills which are essential for DWH testers.
Learning objectives and agenda: Class participants learn how to address the difficulties often encountered when planning, then selecting, test data. The variety of choices for data selection, and challenges associated with each, are discussed so that testers can make wise choices.
Learning objectives and agenda: Students are presented with overviews of risk assessments for the ETL test planning and test execution phases. With each potential risk, strategies are presented for mitigations based on their probability of occurrence and the forecasted impact. As a conclusion, participants will experience a list of DWH QA risk management best practices.
Learning objectives and agenda: Since most DWH projects are different from one another and require diverse test support tools, class participants are exposed to names and descriptions of tools that are most often needed… no cost tools and commercial tools. Students will learn which ETL tests are most amenable to automated testing and they will learn how to select types of tests to automate and which tools may be most helpful and cost effective.
Learning objectives and agenda: Staffing and training the QA team is among the most important steps in the test planning process. Tester skills and learning goals are presented in such a way that job descriptions can be prepared and candidates effectively interviewed. Key DWH QA abilities are outlined so that QA team members are prepared for all facets of testing.
Learning objectives and agenda: A comprehensive list of best practices is discussed so that participants can take with them what has been learned and successfully accomplished by experienced ETL testers.