Testing Tools
You are here: Home Our Services Testing Tools ETL Testing

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.

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

Testing Introduction

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

Testing Levels & SDLC

  • SDLC Process
  • 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

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
  • AGGREGATOR Transformation
  • RANK Transformation
  • STORED PROCEDURE Transformation
  • SEQUENCE GENERATOR Transformation
  • Flat File
  • SQL Transformation
  • Look up Transformation
  • SCD type 1 / 2 / 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

Target Audience

  • 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

Why Choose Best Online Trainers?

  • 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 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.

Trainer Profile

  • Industry-tested ETL testing professionals
  • 10+ years of data warehousing and QA experience
  • Proven success in academic and enterprise training
  • Passionate mentor, interactive live sessions available

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:

 

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