ETL Testing Training: It has been observed that Independent Verification and Validation is gaining huge market potential and many companies are now seeing this as prospective business gain. Customers have been offered different range of products in terms of service offerings, distributed in many areas based on technology, process and Solution. ETL or Data warehouse is one of the offerings which are developing rapidly and successfully. Best ETL Testing Greens Technology Velachery in Chennai is Greens Technology Velachery , Even Fresher’s can Take ETL Testing Online Course. Learn ETL Testing with Real Time Working ETL Trainer having more than 12+ Years of Experience.

ETL Testing Training Services

  • ETL Testing Training in Chennai
  • ETL Testing Online Training
  • ETL Testing Corporate Training
  • ETL Testing  Training with Placement Assistance

Course Curriculum

No curriculum found !


ETL Testing Course Content

  • What is ETL Testing ?
    • Overview about ETL testing
  • Difference between ETL Testing and Database Testing

Data warehousing Concepts

  • What is a Data warehouse?
  • Introduction to Data warehousing.
  • Why Data warehouse and why not Database?
  • What is ETL ?
  • What is a Datamart?
  • Different types of Mapping in Data warehouse.
  • Different types of Schemas.
  • Slowly Changing Dimensions.

Database / SQL Concepts

  • What is Database?
  • Files VS Databases
  • Different types of Databases.
  • What is SQL
  • DDL,DML,DRL,DCL,TCL overview
  • Select statements basics
  • Primary key
  • Foreign key
  • Unique key
  • Not Null
  • Check
  • Default
  • Table Creation, Updation, Inserting and Delete
  • Table Alter, Truncate, Drop
  • Commit & Rollback
  • Views
  • Mathematical operations
  • Columns aliasing
  • Where clause
  • Having clause
  • Difference between where and having clause
  • Group by
  • Order by
  • Logical operators
  • Special operators
  • Arithmetic functions
  • String functions
  • Date and Time functions
  • Ranking functions
  • Null functions
  • Case expression
  • Aggregate functions
  • Set operators
  • Table aliasing
  • Joins
    • Different types of joins
  • Sub queries
    • Multiple subqueries
    • Correlated subqueries

ETL Concepts

  • Normalisation
  • Denormalisation
  • Datawarehouse Architecture
  • Staging Area
  • Dimensional modelling
  • Dimensional Table
  • Fact Table
  • Star schema
  • Snow flake schema
  • Types of Dimensional tables
  • Data merging
  • Data cleansing
  • Data scrubbing
  • Data Aggregation
  • Types of Loads
  • Conformed dimensional table
  • Degenerated dimenstion table
  • Junk Dimensions

Informatica Workflow Monitor Tool

  • What is informatica
  • Workflow monitor tool usage
  • Types of transformations
UNIX Basics
ETL Testing Project Essentials
  • Types of ETL testing
  • Understanding ETL Testing Project Architecture
  • Project objective
  • Project Documents(BR, FR, mapping documents, TDD, Technical Specifications)
  • Testing Life cycle in the ETL project
  • Test cases preparation and execution
  • Test Data Preparation
  • Testing Techniques

Course Reviews


72 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

Key Features

We provide Job Oriented hands on practical training by real time working professional. its suitable for fresher and professional.

We provide hard copy for classroom students / soft copy for online students.

You will get lifetime video access - Online Students

we provide 24/7 support by any type of issues regarding classes and accessing.

You will get course completion certificate when you finished the course.

Greens Technology Velachery provides you job assistance, we have 150+ clients across the globe. We don’t charge any extra fees for this.

Copyright © 2018 Greens Technology Velachery. All rights reserved.