Course Description
ETL & Data Warehouse Testing [A205] is a 36-clock-hour, short-term, non-degree training program that introduces students to data warehouse concepts, ETL processes, database validation, and testing techniques used to verify data as it moves between source and target systems.
Students learn data warehouse and ETL fundamentals, source-to-target validation, data mapping, SQL-based data validation, data quality testing, transformation testing, and common ETL testing processes through instructor-led instruction and hands-on exercises.
Learning Objectives
Upon successful completion of the course, students should be able to:
• Explain ETL and data warehouse fundamentals.
• Describe source, staging, transformation, and target data processes.
• Understand common data warehouse architecture and terminology.
• Review source-to-target mapping requirements.
• Develop ETL testing scenarios and test cases.
• Use SQL queries to validate source and target data.
• Perform data completeness, accuracy, and transformation validation.
• Identify and document data discrepancies and defects.
• Apply ETL testing concepts through instructor-guided exercises.
Hands-On Training
Students participate in instructor-guided exercises involving sample databases, data sets, mapping documents, SQL queries, and ETL testing scenarios.
Program Information
Course Code: A205
Duration: 36 Clock Hours
Delivery Method: Hybrid – Classroom + Online
Credential: AITE Certificate of Completion
Program Disclosure
This is a short-term, non-degree training program. Successful completion results in an AITE Certificate of Completion. AITE does not guarantee employment, job placement, salary, professional licensure, or third-party certification as a result of completing this course.
Prerequisites
Basic computer skills are recommended. Familiarity with software testing, databases, or SQL is helpful but not required.