ETL Testing Online Training in USA and UK

ETL Testing Online Training Course Content:

Data Ware House Concepts:
• Data Ware House overview
• OLTP Vs. DataWare Housing
• Data Acquisition
• Data Extraction
• Data Transformation
• Data Loading
• Data Marts
• Dependent and Independent Data Mart
• Data Base Design
• Star Schema
• Snow Flake Schema
• Fact constellation Schema

Slowly Changing Dimension (SCD)
• Types of SCD
• SQL Concepts
• ETL Tool Architecture overview
• White Box testing & Black BOX testing on various transformation Rules
• Data Ware House Life Cycle

Types of Testing Techniques in ETL
• Minus Queing
• Count Queing

ETL Testing Concepts
• Introduction about ETL Testing
• Use of ETL testing
• Quality & Standards
• Responsibilities of an ETL Tester

SDLC
• Waterfall model
• V-model
• Agile model & methodology
• Prototype model
• Spiral model

Testing methodologies
• White box testing
• Black box testing
• Grey box testing
• Work Flow Process of ETL Testing
• Preparing ETL Test Plan
• Designing the test cases in ETLTesting.
• Reporting the Bugs in ETL Testing
• Responsibilities of ETL Tester in Informatica, DataStage, Abinitio and others.
• Detecting the bugs with database queries
• ETL Performance Testing and performing tuning