COURSES‎ > ‎

ETL Testing Online Training By hands-On Professionals



ETL Testing Training makes you experience the real-time implementation of ETL Testing projects by exploring Data Warehouse, Data Acquisition, Data Loading, Data Warehouse Schema, Testing Strategies, Performance Testing (ETL, Query) etc. Also you will learn about ETL testing tools such as, QuerySurge, Informatica Data Validation, ICEDQ, Talend Open Studio for Data Integration and many more. 


FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107  
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com


ETL Testing Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided
  

ETL Testing  COURSE CONTENT
(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