TRAINING

Enroll Now

ETL Testing Training

ETL Testing Training Course is designed for both entry-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 the DW/BI/ETL set up, Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL, Scope of BI testing and 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.

Who is the target audience?

• BI/ETL Developers
• Testers who want to get job on ETL Testing, to get more salary and also who want to get job quickly.
• IT professionals with very basic knowledge on Database concepts
• Project Managers, Database Professionals, Mainframe Professionals, SQL Developers

DATAWARE HOUSING CONCEPTS:

• What is Data Ware House?
• Difference between OLTP and DataWare Housing

DATA ACQUISITION

• Data Extraction
• Data Transformation
• Data Loading

DATA MARTS

• Dependent Data Mart
• Independent Data Mart

DATA BASE DESIGN

• Star Schema
• Snow Flake Schema
• Fact constellation Schema

SCD(SLOWLY CHANGING DIMENSION)

• Type-1 SCD
• Type-2 SCD
• Type-3 SCD

BASIC CONCEPTS IN SQL

• Overview of ETL Tool Architecture
• White Box and Black BOX Testing Functionality on Different Transformation Rules

DATA WARE HOUSE LIFE CYCLE

DIFFERENT TYPES OF TESTING TECHNIQUES IN ETL .

• Minus Queing
• Count Queing

ETL TESTING CONCEPTS

1. Introduction

• What is use of testing
• What is quality & standards
• Responsibilities of a ETL Tester

2. Software development life cycle

• Waterfall model
• V-model
• Agile model & methodology
• Prototype model
• Spiral model

3. Testing methodologies

• White box testing
• Black box testing
• Grey box testing
• ETL Testing Work Flow Process
• How to Prepare the ETL Test Plan
• How to design the Test cases in ETL Testing.
• How to reporting the Bugs in ETL Testing ?
• ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
• How to detect the bugs through database queries
• ETL Performing Testing & Performing Tuning