FOR FREE DEMO contact :
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894

ETL Testing Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided
ETL Testing COURSE CURRICULUM
(the course agenda can be modified as per your requirements):

Introduction to Data warehousing and Business Intelligence:
  • What is Data Ware House?
  • Difference between OLTP and Data Warehousing
  • Data Acquisition
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Data Marts
Test Plan - Distinctive Features For BI-DW Projects:
  • Testing Objectives
  • Testing Strategies
  • Testing Deliverables
ETL Testing Concepts:
  • Introduction
  • What is use of testing
  • What is quality & standards
  • Responsibilities of a ETL Tester
Assignments and Use cases on ETL Testing:
  • Bug Identification
  • Usage of Sql for automating the process
  • Auditing count of records
  • Validation of data and identifying issues
  • Exceptional handling
  • Meta Data
  • Performance Testing (ETL, Query)
  • Volume Testing
Testing - Cube:
  • Batch Totals
  • Query on Data Mart and Cube
Analysis:
  • Reports (DW / DM / Cube)
  • OLAP Analysis (DW / DM / Cube)
  • DashBoard