Sub-Pages

ETL Testing Online Training

ETL Testing Online Training

 

ETL Testing Course Content

Extract, Transform, and Load is a process in Data Warehousing. Mantra Online Trainings provides ETL Testing course. You can learn from fundamentals to testing methodologies. Check the below concepts of ETL testing. 

 

DATA WAREHOUSE FUNDAMENTALS

• An Introduction of Data warehousing
• Purpose of Data warehouse
• Data ware Architecture
• OLTP Vs Data warehouse Applications
• Data Marts
• Data warehouse Lifecycle
• SDLC

 

DATA MODELING

• Introduction of Data Modeling
• Entity Relationship Model
• Dimensions and Fact Tables
• Logical Modeling
• Physical Modeling
• Schemas Like Star Schema & Snowflake Schemas
• Fact less Fact Tables

 

SCD TYPES

• Type 1 SCD
• Type 2 SCD
• Type 3 SCD

 

PROCESS OF ETL (EXTRACTION, TRANSFORMATION AND LOAD)

• Introduction of Extraction , Transformation and Loading
• Types of ETL tools
• Key tools in the market

 

DIFFERENT TYPES OF TESTING TECHNIQUES IN ETL
ETL TESTING CONCEPTS

• Purpose of testing
• How to maintain quality & standards
• Responsibilities of a ETL Tester

 

UNDERSTANDING ETL RELATED TECHNICAL DOCUMENTS

• Analysing the Business Requirement Documents
• Understanding Mapping sheets
• Following Job Dependency

 

SQL CONCEPTS AND CREATING QUERIES

• Basic Select Statements
• Creating Sub queries
• Using Different type of Joins

 

TESTING METHODOLOGIES

• ETL Testing Work Flow Process
• How to Prepare the ETL Test Plan
• How to design the Test cases in ETL Testing.
• How to reporting the Bugs in ETL Testing?
• ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
• How to detect the bugs through database queries
• ETL Testing & Performance Tuning

 

UNIX BASICS

• What is UNIX?
• How to Create, List Files and directories
• Displaying or searching the contents of a file
• Moving files from one directory to another