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

Blog: http://apex-it-online-trainings.blogspot.in


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