Course Description and Objectives
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.
- Project managers.
- QA managers and test leads.
- ETL test engineers.
- Acceptance test analysts.
- ETL developers.
- ETL and BI architects.
- Data and business analysts.
- Business Intelligence (BI) program and project managers.
Recommended Prerequisite Knowledge / Experiences
Knowledge of databases and their interaction is a distinct advantage as technical terms are often used.
- Basic data and database technologies (ex., Relational database concepts, XML files, flat files).
- Principals and methodologies of data warehousing.
- Experience with Excel data functions (ex., sorting, filtering) **
- SQL programming skills for database queries **
- Experience with DB editors (ex., Toad, SSMS) for query execution **
- Familiarity with principals of data profiling **
Up to eight hours.
Instructor lecture with Q & A.
What You Can Expect from This Course
At the end of this course, class participants will:
- Identify the testing challenges unique to DWH and data integration in order to develop an effective testing approach.
- Comprehend data models and data mapping documents and how to create test cases from them.
- Understand the role of the data warehouse QA process as a key component of the software development lifecycle whether agile or traditional.
- Identify methods for effective test planning and test execution.
- Craft effective test scenarios based on business and user requirements for the data warehouse.
- Acquire new testing methods and the circumstances where each is most effective.
- Generate the ability to develop DWH QA strategies, test plans and test cases; what they are and how to develop them, specifically for DWH and data integration projects.
- Learn how to test data warehouse, data migration and data integration systems throughout the development lifecycle from requirements to deployment.
- Be capable of estimating testing resources as well as conducting a risk assessment specific to DWH testing.
- Learn typical ETL tester job descriptions with an understanding of the skills the QA team needs.
Post-Course Follow-up Service
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.