ETL Testing Training

Today’s businesses have to work with data in multiple formats extracted from multiple sources. All this makes ETL testing all the important. The extracting, transforming and loading of data has to be verified and any anomalies found have to be fixed. Thus there is a need for testers in ETL and Data Warehouse domains. This ETL testing online training can equip you to take up good jobs in some of the biggest companies in the world.

ETL Testing Training Projects

The practical projects that you will work on during this certification training include

Knowledge of business intelligence and data warehousing principles
Learn more about Data Warehouse Workflow and how Database Testing and Data Warehouse Testing compare.
Utilize SQL to perform data checks, and be aware of the BI Testing’s limitations.
Recognize many ETL Testing scenarios, including Dependency Testing, Business Rules Testing, Source to Target Testing, and Constraint Testing.
Learn about QA Lifecycle, ETL Testing, and RDBMS Concepts.

Why should you choose

The average salary of an ETL Tester in India is 4.92 lakhs per annum! – glassdoor.co.in
There are 15,000 ETL Tester job openings in India, according to LinkedIn and Naukri.
ETL Tools like IBM Infosphere Information Server, Informatica Power Center, Oracle data Integrator, Microsoft SSIS have in huge demand in the Industry.

Objectives

The practical sessions throughout the course will help you in reinforcing your technical skills.
It is curated by working professionals with the changing requirements of the ETL Testing profession.
The assignments will further help reinforce your knowledge about ETL Testing and varied Data Warehousing scenarios. All of those will allow you to become an Industry-Ready Professional proficient in handling the bulk of real-world situations.

Prerequisites of Signing Up

Healthcare project will be explained in Class and other documentation for Telecom
Banking, Insurance related data will be provided

ETL TESTING COURSE CURRICULUM

Prerequisites

Software Testing Life Cycle
Software Development Life Cycle
Manual Testing Experience is Plus
Usage of HP quality Center
Defect Life Cycle

Data warehousing Concepts

What is Data Ware House?
Difference between OLTP and Data warehousing

Data Acquisition

Data Extraction
Transformation
Data loading

DataBase Design

Star Schema
Snow Flake Schema

SCD (slowly changing dimension)

Type-1 SCD
Type-2 SCD
Type-3 SCD

Basic Concepts in SQL in Oracle

Different Types of Testing Techniques in ETL

Minus querying
Count Querying

ETL Testing Concepts

Introduction
- What is use of ETL TESTING?
- Responsibilities of an ETL Tester
Testing methodologies
- Smoke Testing
- Functional Testing
- System Testing
- ETL Testing Work Flow Process
- How to Prepare the ETL Test Plan
- How to reporting the Bugs in ETL Testing?
- ETL Testing Responsibilities
- How to design the Test cases in ETL Testing.
- How to detect the bugs through database queries
- ETL Performing Testing & Performing Tuning

Documentation for ETL Testing Projects

BIEE
- BI Test cases
- Data validation with OBIEE
- UI Testing with OBIEE
Different Tools
- SQL Developer
- Informatica PowerCenter Client Tools
- OBIEE Reporting Tool