Online Training on ETL Testing

ETL TESTING Training

Curriculum

Oracle Basics & Concepts
  • What is Data
  • DBMS
  • RDBMS
  • Difference between DBMS and RDBMS
  • OLTP
  • OLAP, ROLAP, MOLAP
  • MetaData
  • Data Types
  • Tables
  • SQL ,SUB QUERIES,CORRELATED SUB QUERY
  • CONSTRAINTS

DWH Concepts
  • What is Data Ware House(DWH) 
  • DWH Architecture
  • DATA MART 
  • DM vs DWH
  • Data Cleansing
  • Normalization
  • Denormalization
  • ODS
  • Staging Area 
  • Landing Area
  • Dimension Modeling
  • Dimensions
  • Facts
  • Aggregations
  • SCHEMA Types
  • Star Schema
  • Snow Flake Schema
  • Slowly Changing Dimensions(SCD)
  • SCDs Types
  • Type 1
  • Type 2
  • Type 3
  • Dimension Types
  • Junk Dimension
  • Degenerate Dimension
  • Confirmed Dimensions
  • Fact Less Fact Table
  • Incremental Load
  • Full Load

ETL Testing Concepts
  • Introduction of ETL-Extraction,Transformation,Loading
  • ETL TOOLS and Different Types of ETL Tools
  • ETL Architecture
  • ETL Testing and Why it is required?
  • Different ETL TOOLS & Its Architectures
  • SDLC and Methods/Models
  • Reverse Engineering
  • Roles and Responsibilities
  • Minus,Duplicate,Count,Intersection,etc…
  • Detect Defects
  • Defects Logging and Reporting
  • ETL Tuning
  • ETL Bottlenecks
  • How to prepare Queries very quickly with the help of mapping
  • Performance Tuning and Performance Testing,Report Testing,UI Testing
  • Quality and different standards that tester should follow,Why?
  • Test plan Preparation
  • Test cases Preparation
  • Preparation of Test data
  • Process Of ETL Testing
Testing Concepts
  • White box Testing
  • Black box Testing
  • Gray Box Testing
  • Regression Testing
  • Smoke Testing vs Sanity Testing
  • User Testing
  • Unit testing
  • Integration testing
  • Module testing
  • System testing
  • UAT
ETL Tool and Testing
  • Data Extract
  • Data Transform
  • Data Load
  • Import Source
  • Import Target
  • Mappings, Maplets
  • Workflows, Worklets
  • Transformations,Functionalities,Rules and Techniques
  • Import and Export
  • Coping and Rules
  • Queries Preparation based on Transformations
  • Importance of ETL Testing
  • Creating of Mappings,Sessions,Workflows
  • Running of Mappings,Sessions,Workflows
  • Analyzing of Mappings,Sessions,Workflows
  • Tasks and Types
Practice:
  • Testing scenarios, creation of test cases and scripts
  • Test case execution and defect tracking and reporting
  • Preparation of Test data
  • Practice ETL Testing with Real Time Scenarios