ETL Testing ( DB/ DWH ) Testing

  Weekend / Weekday Classes
  Free ETL Testing ( DB/ DWH ) Testing Course Online With Certificate
  No programming experience is required.

Live
Classes

Mock
Interviews

1:1
Mentorship

Regular
Assessments

Support,
Lifetime Access

About ETL Testing ( DB/ DWH ) Testing

The benefits of joining dataware testing course are to possess a deep understanding of dataware testing principles, methodologies and technique, our course will be trained by top industry experts with excellent communication and interpersonal skills and have hands-on experience in real world, our best trainers will help you to get job in IT industry or Grow in IT industry.

Why Taking Online Course From Growskill IT

    Learn anything

Explore any interest or trending topic, take prerequisites, and advance your skills.

    Save money

Spend less money on your learning if you plan to take multiple courses this year.

    Flexible learning

Learn at your own pace, move between multiple courses, or switch to a different course.

    Expert Tutors

Earn a certificate for every learning program that you complete at no additional cost.

Key Features

  Program completion certificate from Growskill IT
  Attend Masterclasses from top faculty.
  Growskill IT JobAssist helps you get noticed by top hiring companies
  Earn an industry-recognized Growskill IT certificate after completing of course.
  Industry-recognized certificates for courses
  Engage in capstone projects in 4 domains
  Experiential learning via multiple real-life innovation projects and capstones

ETL Testing ( DB/ DWH ) Testing Course Description

Tools & Skills Covered

Tools : ORACLE + Informatica Power center +Toad + HPALM + QC + SQL Developer
Skills : Manual Testing, Database Testing, ETL Testing, DWH Testing, UNIX

What are the System Requirments ?

Below are the instructions for Growskill IT online java programming course :

- RAM : 2GB
- Processor : Intel Core2 Duo or higher
- Operating System : 32 bit or 64 bit

What are pre-requisites ?

- Programming : No programming experience is required.
- Basic Computer Skills : Communicaton Skills, Surfing Websites, Running Programs, Saving and Opening Documents, etc.

What is the Objective of ETL Testing ( DB/ DWH ) Testing ?

The benefits of joining dataware testing course are to possess a deep understanding of dataware testing principles, methodologies and technique, our course will be trained by top industry experts with excellent communication and interpersonal skills and have hands-on experience in real world, our best trainers will help you to get job in IT industry or Grow in IT industry.

What are the Features of ETL Testing ( DB/ DWH ) Testing ?

Live Classes

Live
Classes

1:1 Mentorship

1:1
Mentorship

Regular Assessments

Regular
Assessments

Capstone Projects

Capstone
Projects

Support Lifetime Access

Support,
Lifetime Access

HR Sessions

HR
Sessions

Mock Interviews

Mock
Interviews

100% Placement Support

100% Placement Support

ETL Testing ( DB/ DWH ) Testing Course Content

A. Manual Testing

Please refer to the "Manual / Database Testing" Course Content Read More

B. Database Testing

Please refer to the "Manual / Database Testing" Course Content Read More

C. Datawarehouse Testing

09 Modules

1. History software Testing?

Introduction to OLTP and OLAP Systems
Difference between OLTP and OLAP

2. What is Datawarehouse?

Characteristics of DWH

3. Data Warehouse Architecture

4. Database

Database Objects examples
Difference between DWH and Web Application Project life cycle
Difference between normal Database and DWH

5. Normalization and De-Normalization

Introduction to Normalization
Types of Normal Forms
Examples

6. DataMart

Types of DataMart/Approaches

7. Data Modeling

8. E R diagrams

Introduction to E – R diagram
Examples

9. Fact table and Dimension table

Different Types of Schemas
Star Schema
Snowflake Schema

D. ETL Testing

09 Modules

1. Introduction to Data Warehouse and Need of Data Warehouse.

Introduction to OLTP and OLAP Systems
Difference between OLTP and OLAP

2. Testing strategy for ETL:

Data Completeness Test
Data Transformation Test
Data Quality
Initial/Load Testing
Incremental Load Testing
Bi/Reports -Testing
Job/Mapping Dependency Testing

3. STM Document

Source to Target Mapping Document

4. Transformations

Active Transformation
Passive Transformation
Different types of Transformation
Aggregator Transformation
Expression Transformation
Filter Transformation
Joiner Transformation
Router Transformation
Sequence Transformation
Lookup Transformation

5. Initial load testing

6. Incremental testing

7. Different Types of Rules

Rules to create test cases in ETL Testing and Template
Data Quality Rules

8. Scheduling Tools

Introduction
Autosys

9. Informatica Powercenter Tool

Software Installation Informatica Powercenter
Installing and set up of software
Working on Informatica Powercenter.
Powercenter designer
Powercenter workflow manager
Powercenter monitor window
Workflow
Maplet
Different statuses in Powercenter

ETL Testing ( DB/ DWH ) Testing Course Certification

Speak To Our Academic Advisors

We are happy to assist you 24/7

By proceeding ahead you expressly agree to the Growskill IT Terms & Conditions and Privacy Policy

Liked the Course ? Start Learning

Talk To Our Academic Advisors


Know More about course instructor ?

Manas Tuwani

Experience : 9+ Years
Expertise : Senior Software Tester

Manas is a Senior Software Tester having 9+ Years of Experience in in Manual & Automation Testing. He is a proven Trainer who has trained 10,000 students in his career and still counting.