Etl Testing

An ETL tool extracts the data from all these heterogeneous data sources, transforms the data (like applying calculations, joining fields, keys, removing incorrect data fields, etc.), and loads it into a Data Warehouse. This is an introductory tutorial that explains all the fundamentals of ETL testing

 Module 1 - Data Warehousing Concepts
  • Introduction to OLTP, and OLAP Systems
  • Introduction to Data Warehousing
  • Data Modelling
  • Normalization/De-normalization
  • Schema
  • Star Schema
  • Snowflake Schema
  • Types of Dimension Tables (Confirmed, Junk, Degenerated)
  • Types of Fact Tables (Additive, Semi-Additive, Non-Additive)
  • Dimensional Modelling
  • Fact less Fact table
  • Change Data Capture (CDC)
  • Slowly Changing Dimensions (SCD Type1, SCD Type2, SCD3 Type3)
  • MD5
  • Data Loading Techniques (Initial/Full, Incremental/Delta)
 Module 2 - Oracle Concepts / T-SQL
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Retrieval Language (DRL)
  • Capabilities of the SELECT statement
  • SET Operators
  • Creation of Backup Tables
  • Numerical Functions
  • String / Character Functions
  • Date / Time Functions
  • Data Conversion Functions
  • Data Analytical Functions
  • Pseudo Functions
  • Type of Joins
  • Creating Views and Indexes
  • Data Keys, Constraints
  • Practicing on TOAD and SQL Loader
  • Regular Expressions
  • Materialized views
  • Stored Procedures, Functions
 Module 3 – Manual Testing Concepts
 Module 4 – UNIX Basic Commands
 Module 5 – Agile Methodology (Scrum Framework)
 Module 6 – HP QC/ALM
 Module 7 – ETL Testing
  • What is ETL Testing ?
    ETL Testing Strategies
    Informatica Power Center Components
    • Designer, Repository Manager, Workflow Manager, Workflow Monitor Source Analyzer, Target Designer, Mapping, Session, Workflow
 ETL Testing with Informatica
  • SAMPLE Loading from source to target
  • SORTER Transformation
  • FILTER Transformation
  • ROUTER Transformation
  • EXPRESSION Transformation
  • Look up Transformation
  • JOINER Transformation
  • AGGREAGATOR Transformation
  • SEQUENCE GENERATOR Transformation
  • Update Strategy
  • Flat File - Source/Target
  • Excel - Source/Target
  • SCD type 1
  • SCD type 2
  • SCD type 3
  • Types of load (Full/Initial, Incremental/Delta)
 Module 8 – ETL Testing with SSIS
 Module 9 – Difference between Oracle SQL and Microsoft SQL (T-SQL) Functions
 Module 9 – Difference between Oracle SQL and Microsoft SQL (T-SQL) Functions
 Module 11 – Interview Questions & Answers

Click here to Download the Etl testing syllabus.


  • Address: #12, 3rd Floor
    Dental College Main Road,
    Munekolalu, Marathahalli,
    Bangalore - 560037
  • Email:
  • Website:


Selenium Training in Bangalore Automation Testing Training in Bangalore Selenium Training in Marathahalli Best Selenium Automation Training in Bangalore
Software Testing Training in Bangalore Java Selenium Automation Training in Bangalore Automation Testing Training in Marathahalli Selenium Training Institutes in Bangalore
Best Selenium Training Institute in Bangalore Cucumber Training in Bangalore Best Cucumber Training in Bangalore Best Cucumber Training in Marathahalli