Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

ETL Testing: From Beginner to Expert

via Udemy

Overview

ETL Testing: Essential course for all software testing professionals.

What you'll learn:
  • Understand the concepts of Business Intelligence Data warehousing
  • Get to know what is ETL Testing, QA Lifecycle and RDBMS Concepts
  • Gain an in-depth understanding of Data Warehouse WorkFlow and comparison between Database Testing and Data Warehouse Testing
  • Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Business Rules Testing, Negative Scenarios, Dependency Testing
  • Perform data Checks using SQL and understand the scope of BI Testing

DW/BI/ETL Testing Training Course is designed for bothentry-level and advanced Programmers. The course includes topics related to the foundation of Data Warehouse with the concepts, Dimensional Modeling and important aspects of Dimensions, Facts and Slowly Changing Dimensions along with theDW/BI/ETL set up,Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL,Scope of BI testingand as a bonus you will also get the steps to set up the environment with the most popular ETL tool Informatica to perform all the activities on your personal computer to get first hand practical knowledge.

Syllabus

  • Welcome! Thank you for learning the ETL Testing Course with me!
  • Before we start
  • The Basics - Data warehouse Concepts course
  • Data Mart
  • Data Warehouse Architectures
  • Dimensional Modeling
  • How to build a Dimensional Model?
  • Various Objects in a Dimensional Model
  • Data Integration and ETL
  • ETL Vs ELT
  • Typical Roles In DWH Project
  • DW/BI/ETL Implementation Approach
  • DW/BI/ETL Test Stratergy and Data Centric Approach
  • Different Categories Of Projects where DW/BI/ETL Testing is required
  • Roles and Responsibilities of an ETL Testing Professional
  • Database Testing
  • Basics of ETL Testing
  • Database Testing Vs ETL Testing
  • Defect Management
  • Possible Reasons for Defects & Bugs
  • Issues/Defect Management Process
  • Issue Severity Table
  • Quality Center Defect Category Descriptions
  • Categories of ETL Testing
  • Different Tools/Technologies used in DWH/BI/ETL Testing
  • Informatica Power Center (ETL Tool)
  • Installation and Configuration of Informatica Power Center
  • Informatica - Pre-Requisites to start the Hands on
  • Client Tools and Sample WorkFlow Creation
  • Introduction to Transformations
  • Transformation's functions in brief
  • Data Types in Informatica
  • Different Types of Ports in Informatica
  • Functions in Informatica
  • Workflow Manager
  • Informatica PowerCenter Monitor
  • Other important objects and activities in Informatica
  • Practical Scenario : Flat File Source to Flat File and Relational Targets
  • Retired Lectures
  • Questions from Students
  • Bonus Section

Taught by

Sid Inf

Reviews

4.5 rating at Udemy based on 3151 ratings

Start your review of ETL Testing: From Beginner to Expert

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.