ETL Testing Online Training Course Content

ETL Testing Training Course Content Outline :

ETL Testing Online Training by Tekson IT Services Excellent Online ETL Testing Training with experienced trainers. Tekson IT Services hires only professional and ETL Testing Online Training experts who has more then 10 years of experience. We will give you ETL Testing recorded classes in case required based on the special request by the student. We use excellent training platform Goto Meeting, Cisco Web-ex in order to organize the training. We tailor the course content according the students requirement. The ETL Testing course content designed based on the general requirement which is based on the present IT demand. Each and every trainers their on course content which is up-to date in the market based on various versions & updates.

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

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

Software development life cycle

  • Waterfall model
  • V-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

Leave a Reply