ETL Testing Online Training

ETL Testing Online Training

ETL Testing Online Training
ETL Testing Online Training

ETL Testing Online Training Course Content:

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
Data Ware Housing Concepts
  • What is Data Ware House?
  • Difference between OLTP and Data Ware 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
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 Data Stage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

Drop your query

What my Client's Say?

 

  • It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand

  • All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin

  • It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla

  • Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig

  • Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala

  • It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar

  • The course was really good because it was a practical course.~ M.Radha patel

  • I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria