1. ETL Testing overview

ETL Testing tool testing extracts data from all data sources and loads it into the destination or Data Warehouse.  This testing course has been designed for software testing professionals to gain in-depth knowledge of Data Warehouse workflow and get to know ETL testing concepts.

2. Course Features

40 – 45 hours of Instructor-led classes, assignments after every class, a live project to get hands-on experience, quizzes and real-time project, self-paced online learning, certification after successful completion of course

3. Who is Eligible to Take Up This Course?

The following professionals can take up the Automation Testing course offered by Mansard Software Solution.

  • Software Testing Professionals
  • Software Test Managers
  • QA Engineers
  • QA Leads & Managers
  • Freshers who aspire to be Software Testing Professionals and must possess a basic understanding of any programming language

4. Prerequisites

Must have a basic understanding of any programming language.

About the Course

ETL Testing Training and Certification Program from Mansard offered for individuals to learn the key concepts of Business Intelligence Data Warehousing and help to gain hands-on experience creating ETL test cases.

Introduction to Data Warehousing Concepts

Goal: In this module, you will learn about the fundamentals of Data Warehouse, ETL concepts, know about Data Mart.

  • Data Warehouse Concepts, Design
  • Need of Data Warehouse
  • Introduction to OLTP, ETL and OLAP Systems
  • Data Warehousing Architecture
  • Dimensional Modeling
  • Data Marts and ODS
  • Star Schema and Snowflake Schema
  • SCD (slowly changing dimension)
  • Types of Fact and Dimension Tables

SQL Concepts

Goal: In this module, you will learn the fundamentals of SQL and its data types.

  • Basic Concepts in SQL
  • Data Types
  • Select statement usage
  • Joins
  • Sub Queries
  • Performance Tuning Tips & Tricks

ETL Testing – Introduction

Goal: In this module, you will learn about ETL’s architecture and how it works.

  • Introduction to ETL
  • ETL Architecture
  • What is the use of testing
  • What is quality & standards
  • Responsibilities of ETL Tester
  • Sub Queries
  • Performance Tuning Tips & Tricks

ETL Testing – Procedure

Goal: In this module, you will learn about the process of ETL Testing.

  • Steps in DWH Testing
    • Prerequisites of DWH Testing.
    • Levels of DWH Testing
  • The Data Warehousing process
    • Coverage of ETL Testing
    • How DWH Testing is Different from Application Testing?
    • Challenges in DWH Testing

Testing Methodologies

Goal: In this module, you will learn the testing methodologies and the process to detect the bugs.

  • ETL Testing Workflow Process
  • How to Prepare the ETL Test Plan
  • How to design the Test cases in ETL Testing
  • How to report the Bugs in ETL Testing
  • ETL Testing Responsibilities
  • How to detect the bugs through database queries
  • ETL Performance Testing

BO and Reports

Goal: In this module, you will learn about the components of testing, reporting.

  • Overview
  • Reports Testing Process
  • Components of BO Testing

Query & Tools

Goal: In this module, you will learn about popular tools.

  • Informatica / Datastage / Cognos
Advertisements