All exams are online now due to COVID related precautions read more

ETL Testing Table of Contents


Table of Contents
 

 

Software Testing Basics

  • Scope
  • Functional vs. Non-Functional testing
  • Defects and failures
  • Finding faults early
  • Compatibility
  • Input combinations and preconditions
  • Static vs. dynamic testing
  • Software verification and validation
  • The software testing team
  • Software quality assurance (SQA)
  • Testing Methods - The box approach

Data Warehousing Basics

  • Introduction to Data Warehousing
  • Data Warehousing Characteristics
  • OLAP and OLTP
  • Data Warehousing Architecture
  • Data Models
  • Data Schemas (Star and Snow Flake )

SQL Basics

  • Relational Model
  • Normalization
  • DDL Commands
  • DML commands
  • Joins
  • Functions
  • Cursors
  • Procedures

ETL Testing Basics

  • ETL Process
  • ETL Transformations
  • ETL Testing Types

ETL Test Design

  • ETL Testing Challenges
  • ETL Testing Requirements Gathering
  • ETL Testing High Level Design
  • ETL Testing Low level Design

ETL Test Execution

  • Unit Testing
  • Integration Testing
  • ETL Test Development
  • ETL Testing Defects
  • Defects Reporting

ETL Testing Tools

  • Talend Open Studio
  • Informatica Powercenter
  • Pentaho Kettle
  • Cloud based Tools



Apply for Certification

https://www.vskills.in/certification/testing/etl-testing-certification