Datawarehousing - ETL Testing

Book your Seat by a One-time Registration Fee of Rs.2000/-

Course Overview

We provide ETL Testing Training in Pune & Informatica training in Pune. ETL stands for Extract, Transform and Load. An ETL tool extracts the data from different RDBMS source systems, transforms the data like applying calculations, concatenate, etc. and then load the data to Data Warehouse system. The data is loaded in the Data Warehouse system in the form of dimension and fact tables. Our ETL Testing Course gives you insights about the tools and tables used to test the whole ETL process.
Our ETL Testing Trainers are industry professionals and certified ETL experts working in the industry from past 5+ years. Our trainers provide hands on real time ETL Testing Projects thereby imparting a thorough knowledge to the students and help them to achieve their career goals. Our main focus is to provide individual training and corporate training in Data Warehouse using ETL Tool Informatica. Join us Build your career in Data Warehousing (DWH) as a real time professional.

Course Features

  • Trainers from Industry Experts
  • Hands on Experience on One Live Project.
  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Missed Sessions Covered
  • Multiple Flexible Batches
  • Practice Course Material


  • Knowledge of Manual Testing and DBMS/SQL is advantageous.
  • Duration : 36 Hours

    Who can join this course?

    • Data Analysts
    • Testers who want to get a job in ETL Testing
    • Project Managers,Database Professionals
    • IT professionals interested in data driven work

    Course Syllabus

    Datawarehousing - ETL Testing
    1. Database/SQL
      • RDBMS Concepts
      • Data Models
      • Entity Relationship Model
      • Normalization
      • SQL Overview
      • Introduction to SQL
      • Data types
      • SELECT Statement
      • Operators
      • Pseudo Column
      • SQL Statements
      • Data Definition Language (DDL)
      • Data Manipulation Language (DML)
      • Transaction Control Language (TCL)
      • Data Control language (DCL)
      • Join
      • Inner/Equi Join
      • Non-Equi/Cross Join
      • Self Join
      • Outer Join
      • Constraints
      • Primary Key Constraint
      • Foreign Key Constraint
      • Unique Key Constraint
      • Not Null Constraint
      • Check Constraint
      • Set Operator
      • Union
      • Union All
      • Intersection
      • Minus
      • Sub Query
      • Sub/Inner Query
      • Correlated Sub Query
      • Object
      • Index
      • Synonym
      • View
      • Built-in Functions
      • Aggregate Functions
      • Character Function
      • String Functions
      • Case Manipulation Functions
      • Date Functions
      • Analytical Functions
    2. Datawarehousing/ETL
      • Datawarehousing Fundamental
      • Datawarehousing Overview
      • DWH Characteristics
      • Types of Datawarehousing
      • Data Mart
      • Database vs Data Warehouse
      • Data Mart vs Data Warehouse
      • Data Warehouse benefits
      • DWH Architecture
      • Datawarehousing Terminologies
      • Data Cleansing, Partitioning
      • Staging area, Metadata
      • Surrogate Key
      • Snapshot, View and Materialized View
      • Meta Data, Data Mining& Data Cube
      • Dimension Modeling
      • Facts and Dimensions
      • Hierarchies and Levels
      • Measures & DWH Schema Schema
      • Additive, Semi Additive, Non Additive Fact/Measure
      • ETL Overview
      • Process Flow of ETL
      • Types of Sources and Target
      • ETL Data Load types
      • Active vs Passive transformation
      • Extraction Methods in ETL
      • Tracing Level
      • Types of Data used for ETL Process
      • Slowly Changing Dimension
      • What is Slowly Changing Dimension?
      • SCD Types : Type-1, Type-2, Type-3
      • ETL Testing Process
      • Categories of ETL Testing
      • ETL Test Scenarios and Test Cases
      • Types of ETL Bugs / Defects
      • Responsibly of ETL Tester
      • OBIEE / BI Overview
      • Introduction to OBIEE
      • Business Intelligence Basics
      • Overview of Reports
      • Slice and Dice
      • Roll-up and Drill-down& Pivot
    3. Informatica Power Center Tool
      • Informatica Tool Overview
      • Introduction to Informatica
      • How developers work on Power Center
      • Different components of Power Center and uses
      • Tasks performed in different Components
      • Mapping, Session, Worklet, Workflow, Mapplet
      • Naming Conventions
      • Designer Component
      • Working with Sources
      • Working with Flat Files
      • Working with Targets
      • Data Transformation Source and Target
      • Mapping Parameters and Variables
      • Uses of Mapping
      • Workflow Manager Component
      • Workflow Manager Overview
      • Workflow Designer
      • Task Developer
      • Worklet Designer
      • Creating a Task
      • Configuring Task
      • Workflow links
      • Validating Tasks,Workflows
      • Scheduling and Running Workflows
      • Workflow Monitor Component
      • Workflow Monitor Overview
      • Using Workflow Monitor
      • Working with Tasks and Workflows
      • Workflow and Task Status
      • Using Gantt Chart and Task Views
      • Session and Workflow Logs
      • Transformation
      • How to use Transformations
      • Aggregator Transformation
      • Expression Transformation
      • Filter Transformation
      • Router Transformation
      • Union Transformation
      • Rank Transformation
      • Sorter Transformation
      • Joiner Transformation
      • Overview of UNIX Operating System
      • Basics of Unix/Linux
      • Useful Commands
      • Command Manuals
      • Regular Expressions
      • Filter
      • File Attributes
      • Job Scheduling
      • Archive/Compress File
      • Editor : vi, sed
      • Processes
      • File copy/transfer in UNIX Server


    1. Will I get any certificate after this course?

    After the course completion, an exam will be conducted to judge your knowledge along with the live project work completion check and you will be awarded a certificate from 3RI Technologies.

    2. Will I get any placement assistance after the course completion?

    Yes, we provide 100% placement assistance to our students. We have a dedicated team for Placement and tie ups with 300+ MNC’s and SME companies.

    3. Do you provide any demo classes for this course?

    Yes we conduct demo classes every weekend. Please contact us for more details.

    Inquire Now