ETL Testing Training

ETL Refers to “Extraction of Data from different Applications” developed and supported by different Vendors, Managed and operated by different persons hosted on different Technologies “into Staging Tables –Transform data from Staging Tables by applying a series of rules or Functions which may include Joining and Duplication of Data, Filter and Sort the Data using specific Attributes, Transposing Data, Make Business Calculations etc. To derive the data for loading into the Destination System, Usually the Data ware House is used for Business Intelligence & Reporting Issues. ETL basically standsfor (EXTRACT TRANSFORM LOAD) which simply implies the process where you extract data from Source Tables and Transform them in to the desired Format based on certain Rules and finally load them onto Target Tables. So ETL Testing implies, Testing this entire Process using a Tool or at Table Level with the help of Test Cases and Rules Mapping Document. With the help of SQL Queries’ we need to validate Data from Source to Target.

829 Voted
4.4/5

Attend Demo

Introduction

  • The Data in Data ware house system is loaded with an ETL (Extract,Transform,and Load)Tool. As the Name suggests it performs the following 3 operations:
  • Extracts the Data from your Transactional System which can be an Oracle,Microsoft or any other Relational Database.
  • Transforms the Data by performing the Data cleansing operations
  • Loads the Data into the OLAP Data warehouse.
  • You can also extract Data from Flat Files like Spread Sheets and CSV Files using an ETL Tool and Load it into OLAP Data warehouse for Data Analysis and Reporting

What are Career Opportunities?

ETL Testing / Data Warehouse Testing though is a niche area with in the Software Quality Industry it has gained much prominence in recent years.Currently 15,000 ETL Testing Job Positions are open for this exciting career PAN India.

 

Who are eligible to take ETl Testing Training?

  • Testers who want to get Job on ETL Testing, to get more Salary and also who want to get Job Quickly.
  • Any Bachelor Degree(B.Tech, Any Degree, M.Tech, MBA)

ETL Process

E- Extract the Data

It involves the extracting the Data from different heterogeneous data Sources.Data extraction from a Transcationl System varies as per the requirement and the ETL Tool in use.It is normally done by Running Scheduled Jobs in Off-Business hours like running jobs at night or over the weekend.

T-Transforming the Data

It involves Transforming the Data into a suitable Format that can be easily loaded into a DW System.Data Transformation involves applying Calculations,Joins and defining Primary and Foreign Keys on the Data. For example – if you want % of Total Revenue which is not in Database,you will apply % Formula in Transformation and Load the Data.Data Transformation also involves the Data correction and cleansing of Data, Removing incorrect Data,Incomplete Data Formation and Fixing Data errors.It also includes Data Integrity and Formatting Incompatible Data before Loading it into a DW System.

L-Loading the Data into a DW System

It involves loading the Data into a DW System for Analytical Reporting and Information.The Target System can be a simple Delimited Flat File or a Data warehouse.

Course Content

  • SQL Overview
  • About Database
  • Database
  • Operation
  • Table
  • Normalization
  • DBMS, RDBMS,
  • ORDBMS
  • Introduction to
  • SQL
  • About SQL
  • Connect using
  • Tools
  • Data Types
  • SQL Commands
  • SELECT Statement
  • Restricting and
  • Sorting
  • Data/Records
  • Wildcard Uses
  • Different Types of
  • Operators
  • Keywords
  • Dual Table
  • Pseduo Column
  • Release Format
  • Common Table
  • Expression
  • SQL Clauses
  • Operators
  • 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
  • Default Constraint
  • Check Constraint
  • Sub Query
  • Sub/Inner Query
  • Correlated Sub
  • Query
  • Nested Sub Query
  • Object
  • Index
  • Synonym
  • View
  • Tablespace
  • Set Operator
  • Union
  • Union All
  • Intersection
  • Minus
  • Built-in Functions
  • Aggregate
  • Functions
  • Character Function
  • String Functions
  • Case Manipulation
  • Functions
  • Date Functions
  • Analytical
  • Functions
  • Datawarehouse Fundamental
  • Datawarehouse Overview
  • DWH Characteristics and benifits
  • Data Mart
  • Database vs Data Warehouse
  • DWH Architecture
  • Datawarehouse Terminologies
  • Data Cleansing
  • Partitioning
  • Staging area
  • Metadata
  • OLTP, OLAP, ROLAP, MOLAP
  • Surrogate Key
  • Snapshot, View and Materialized View
  • Data Mining
  • Data Cube
  • Dimension Modeling
  • Facts and Dimensions
  • Hierarchies and Levels
  • Measures
  • DWH Schema
  • Star, Snow-flake and Galaxy Schema
  • ETL Overview
  • Process Flow of ETL
  • Types of Sources and Target
  • ETL Data Load types
  • Active vs Passive Transformation
  • Extraction Methods in ETL
  • Introduction to ETL Tool
  • 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
  • How to create ETL Test Case
  • Types of ETL Bugs/Defects
  • Database Testing vs ETL Testing
  • Responsibilies of ETL Tester
  • Compare Source and Trarget Data
  • OBIEE/BI/Report
  • Introduction to OBIEE
  • Business Intelligence Basics
  • Dashboard vs Report
  • Slice and Dice
  • Roll-up and Drill-down
  • Pivot
  • Report Terminologies
  • Report UI Usecase
  • ETL/Report Testing Documents
  • Business Requirement
  • Mapping Document
  • Calculation Logic Sheet
  • Dashboard/Report UI Design
  • Test Scenarios and Test Cases
  • Database/Backend Testing
  • What is Database/Backend Testing ?
  • How to do Backend Testing ?
  • Areas to cover in Database Testing
  • Database Testing
  • Database Testing Test Scenarios
  • Front-end vs Back-end Testing
  • Migration Testing
  • Overview of Data Migration
  • What is Migration Testing?
  • Types of Migration
  • Migration Testing Phases
  • Challenges in Data Migration Testing
  • Data Migration Testing Strategy
  • Application and Data Centric Testing
  • Types of Testing
  • Reasons caused for Data Centric
  • Testing on Store Procedure
  • What is Store Procedure?
  • Steps for testing Store Procedure
  • Benefits of Store Procedure
  • Disadvantages of Store Procedure
  • Store Procedure vs Function
  • Execute Procedure with Parameter
  • NoSQL Concept
  • What is NoSQL?
  • When to use SQL and NoSQL ?
  • SQL vs NoSQL
  • Differences between SQL and NoSQL
  • Informatica Power Center Tool Overview
  • Introduction to Informatica
  • How developers work on Power Center
  • Different components and uses
  • Tasks/Session
  • Mapping, Worklet, Workflow, Mapplet
  • Naming Conventions
  • Designer Component
  • Working with Sources and Targets
  • Working with Flat Files
  • Source and Target
  • Uses of Mapping Wizards
  • Workflow Manager Component
  • Uses of Workflow Wizard
  • Worklet Designer
  • Creating and Configuring Task
  • Link Workflow and Session
  • Validating Tasks and Workflows
  • Scheduling and Running Workflows
  • Workflow Monitor Component
  • Uses of Workflow Monitor
  • Working with Tasks and Workflows
  • Workflow and Task Status
  • Using Gantt Chart and Task Views
  • Session and Workflow Logs
  • Transformation
  • Source Qualifier
  • Transformation
  • Aggregator Transformation
  • Expression Transformation
  • Filter Transformation
  • Sorter Transformation
  • Sequence Generator Transformation
  • Normalizer Transformation
  • Router Transformation
  • Union Transformation
  • Rank Transformation
  • Joiner Transformation
  • Project Guidance
  • Real time Project Overview
  • Import and Export DB Data
  • Real Environment Used
  • Handling Challenging Tasks
  • Testing Entry/Exit Criteria
  • Interview Preparation
  • Resume Formats and Design
  • Technical FAQ discussion
  • Non-Technical Q&A
  • Roles and Responsibilities

we love them

what our students have to say

How real people said about Digital IT Training Hub Institute…

“What we learn with pleasure we never forget.”

- Alfred Mercier