ETL Testing

etl testing online training

ETL Testing Online Course Content

Course Duration: 30 Hours(Online Live & Interactive Sessions)

  • Data warehousing Concepts
    •  What is Data warehousing and why is it needed?
    •  Architecture
      •  Various Stages in Data warehouse
      •  Marts and Warehouse
    •  What is ETL and need for ETL
    •  Facts and Dimensions
    •  OLAP and OLTP
    •  Various Schema’s in a warehouse
    •  SCD types / Slowly Changing Dimensions
    •  Normalization and De-Normalization
    •  Types of Loads
      •  Seed Data
      •  Incremental Data
      •  Historical Data
    •  ETL tools
  • Types of ETL Process
    •  Data Cleansing & Data Scrubbing
    •  Data Masking
  • Testing Overview:
    •  SDLC
    •  Bug Cycle, Agile BUG Cycle
    •  Defect and Process Tools
    •  Difference between Database testing, BI testing and Data warehousing testing
    •  Difference between Manual testing and Data warehousing testing
    •  Need for ETL testing
    •  Challenges and risks in ETL testing
  • Installation and Set up of MSQL
  • Loading of Data
  • SQL (Separate Module)
    • DDL,DML,DCL
    • Operators and Functions
    • Aggregate and Group By
    • Partition By
    • Sub Queries
    • Joins (Inner, Outer, Self, Left)
    • Inserts and Updates
    • Temp tables creation
  • ETL testing methodologies:
    • Smoke Testing and Sanity Testing
    • DDL Validation
    • Duplicates Validation
    • Referential Integrity Validation
    • Count Validation
    • Data Validation
    • Security/Masking Validation
  • ETL Testing Process Flow
    • Understanding Mapping Document
    • Understanding Data Model
    • Test cases preparation
    • Test plans, Test Scripts and Test Evaluation Summary
    • How to prepare test Queries using mapping and performance tune them
    • How to detect and report the bugs in the ETL testing
  • Performance Testing
  • Usability testing