ETL Testing

Have Queries? Ask us +91 72592 22234

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on ETL Testing which gives you the opportunity to interact with a ETL Testing instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content

Data Warehousing concepts:

  • DBMS and RDBMS
  • What is Data Warehousing and necessity of it?
  • Data warehousing architecture
  • Data mining
  • Meta data
  • Tables, views
  • Constraints
  • Fact and Dimensional Tables
  • Partitioning of tables
  • Concepts of Referential Integrity
  • Concepts of Modelling
  • Database Schema
  • Concepts of normalization
  • Concepts of Slowly Changing Dimensions
  • Concepts of Data Mart
  • Full and Incremental extraction Process
  • Change Data capture

SQL Concepts:

  • DDL, DML commands
  • All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions)
  • Joins
  • Practice SQLs for some sample test scenarios

ETL testing:

  • What is ETL and importance of ETL testing??
  • Creating, running and analysing sessions/workflows in Informatica
  • Preparation of Test strategy, Test plan and estimations
  • Testing scenarios, creation of test cases and scripts
  • Test case execution and defect tracking and reporting

Report Testing:

  • Validation of the report data with DB and UI testing
  • Preparation of Test data

Levels of testing

  • Unit testing
  • Integration testing
  • Module testing
  • System testing
  • Uat

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234