ETL testing essentials

ETL Testing Essentials training course is a mix of case driven, instructor-led, and self paced learning, designed to enable Participants learn, experiment and implement the concepts involved in ETL/Data Warehouse Testing. They will be presented with ample examples, exercises and case studies to understand and apply the concepts taught.

ETL Testing Essentials class is appropriate for both Novice and Experienced Software Engineers under the following category:

  • Test Engineers
  • Quality Assurance Specialists
  • Project / Test Leads
  • Participants are expected to have basic knowledge on software testing

By attending ETL Testing Essentials workshop, Participants will:

  • Review the fundamental concepts of data warehousing and its place in an information management environment
  • Learn about the role of the testing process as part of software development and as part of data warehouse development
  • Learn about test strategies, test plans and test cases – what they are and how to develop them, specifically for data warehouses and decision support systems
  • Create effective test cases and scenarios based on business and user requirements for the data warehouse
  • Plan and coordinate usability testing for data warehousing
  • Conduct reviews and inspections for validation and verification
  • Participate in the change management process and document relevant changes to decision support requirements

COURSE AGENDA

  • Understanding of Data Transformation, Mapping and Business Rules
  • Understanding of Data Centric Testing
  • Test Case and Test Design Methodology
  • Categorization of Testing based on objectives of testing and reporting
  • Database testing and data Warehouse Testing – A comparision
  • Testing Approach, planning and Strategy
  • Introduction to ETL TOOLS
  • Introduction to ETL and its Components
  • Landing Zone
  • Data Profiling
  • Data Quality / Reconciliation
  • Transformation Rules
  • Staging Databases
  • Loading to Reporting/Final Data Warehousing
  • Introduction OLTP-Databases Modelling Concepts
  • ERD – Entity Relationship Diagrams
  • Logical and Physical Schema for Database Design
  • Database Constraints – Primary , Foreign Key , Unique Keys, Surrogate Keys
  • Advanced SQL Statements
  • Views and Materialized Views
  • Meta Data and Operational Data
  • Need/Business Drivers Data warehouse
  • Data Warehouse – Characteristics
  • Data Modelling – Fact , Dimensions, Star , Snowflake Schemas

Copyright © 2025 All Rights Reserved by Cuesys Infotech.

Designed By  99 DESIGN AGENCY