+91-80999 02123201-710-8393

ETL Testing Online Training

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

 

Address

#3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
Hyderabad - 500 029

Phone     : 040- 6464 5154
Email      : info@careeronlinetrainings.com
Website : www.careeronlinetrainings.com

Skype ID : careeronlinetrainings

Testimonials

The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

The thing that the course needs improvement is the format of the assignment

Keerthi
Hyderabad.

I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

The thing that the course needs improvement is the format of the assignment


Mushtak Shaik
Hyderabad.