ETL Testing Training

ETL is the process of extracting data from heterogeneous sources, transforming it in order to make it fit for operational needs and finally loading it into the end target. ETL testing is different from conventional training as it involves handling of incompatible, duplicate, complex & voluminous data.

ETL testing online training

is primarily aimed at identifying and mitigating existing data defects and general errors occurring prior to the processing of data for analytics and reporting.

We all know that data plays a very important role in helping business for making the critical business decisions. ETL testing plays a significant role in validating and ensuring that the business information is exact, consistent and reliable. It also minimizes hazard of data loss in production. Let’s have a look at the ETL training course offered by BestOnlineTrainers.

Course Overview
Target Audience
Why choose us
Trainer Profile

ETL Testing Training Course Details

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

Data Ware House Life Cycle

Overview of ETL Tool Architecture

Components in ETL Tool

Different Types of Testing Techniques in ETL

Minus Querying
Count Querying

SCD (slowly changing dimension)

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

Testing Introduction

QA&QC
Verification & Validation
Software development life cycle
Quality standards
Testing Types

Testing Levels

Software Development Life Cycle

SDLC Proces
SDLC models analysis
Software Testing Life Cycle (STLC)
Testing Vs SDLC
Web Development Life Cycle
Manual Defects Analysis
BUGS Life Cycle
Severity and Priority of BUGS
BUG report
Types of BUGS
Manual Testing Documents

Test Plan Preparation Content

Master Test Plan Content
Test Strategy and Methodology
Rules
Designing Test Cases Techniques
Manual Testing FAQ's
ETL Testing Concepts

Introduction

What is use of ETL TESTING?
Responsibilities of a ETL Tester

Software development life cycle

Waterfall model
Agile model & methodology
Prototype model
Spiral model

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

Documentation for ETL Testing Projects

Work procedure with Automation Tools for ETL Testing

White Box and Block Box testing functionality in different transformation rules:

SAMPLE Loading from source to target
SORTER Transformation
FILTER Transformation
ROUTER Transformation
EXPRESSION Transformation
JOINER Transformation
UNION Transformation
AGGREAGATOR Transformation
RANK Transformation
STORED PROCEDURE Transformation
SEQUENCE GENERATOR Transformation
Flat File
SQL Transformation
Look up Transformation
SCD type 1
SCD Type 2
SCD Type 3
Update Strategy
XML Source Qualifier
Types of load (Full, incremental, Refresh)

Project Explanation

Projects on Different Domains (Banking, Health Care, Telecom, Insurance)

FAQ’s

Resume Preparation

ETL testing training is intended for:

IT professionals who are looking to advance their career in ETL testing or looking for a change in career path or want to learn a new skill set
Students who want to make their career in Software Quality Assurance/Testing

We guarantee learning at your convenience & pace.

Instant Access:
Get instant access to self-paced training after signup.
Streaming video recording:
Watch lessons any time at your schedule, free recording.
Exercises:
Practical exercises help you test what you are learning as you go.
Free Demo:
Sign up for free demo to check whether the course is right for you and interact with the faculty live.
Experienced Trainers:
We only hire the industry’s best trainers
Live free interactive web sessions:
Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
Structured Curriculum Schedule:
Progress with your complete daily interactive lessons and assignments.
Faculty Mentoring:
Turn in daily and weekly homework for personalized feedback from faculty.
Virtual Office Hours:
Live interaction with the faculty and other students around the world.
Hands on Live Projects:
Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

N/A

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K