ETL Testing Training

Online informatica training also offers Online ETL Testing Training, ETL testing is Having the ample of opportunities in the market, online informatica training provides Online ETL Testing Training by real time industry experts. Online ETL Testing Training also advises them quality and guidelines to improve the familiarity. Online ETL Testing Training trainers are certified having the expertise in teaching.
Course Duration:  30 Hours

  • Online ETL Testing Training
  • Data Ware 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
    • White Box and Black BOX Testing Functionality on Different Transformation Rules
    • Data Ware House Life Cycle
    • Different Types of Testing Techniques in ETL
    • Minus Query
    • Count  Query
  • 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