We offering ETL Testing Online Training USA quite a lot of features. Our faculty has Real Time experience in IT industry. We offer Best ETL Testing Online Training at your comfortable timings from your home with flexible schedules. Student can select regular fast track and weekend ETL Testing Classes. Each trainer regularly assessed to candidates given the best quality of ETL Testing in Online Training. Demos are conducted by every day and you can choose flexible timings according to your requirement.

We provide free demo on ETL Testing Online Training Classes and course materials an in-depth knowledge of ETL Testing which focuses on real time scenarios. Recorded sessions are provided after each class. We arrange regular and weekend ETL Testing Training for employees and students. Resume build as per corporate standards according to the job description and we will market your resume for top companies. We provide ETL Testing Online Training and project support across the World like USA, UK, South Africa, Malaysia, Singapore, Australia and Japan.

ETL Testing Online Training Course Content

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
  • Data 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

  • SELECT
  • Single Row Functions
  • Aggregate Functions
  • JOINS
  • SUBQUERYS
  • SET Operators
  • Analytical Functions
  • DDL, DML, Views (High level Concepts)

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 design the Test cases in ETL Testing.
  • How to reporting the Bugs in ETL Testing?
  • ETL Testing Responsibilities
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

Documentation for ETL Testing Projects

ETL Testing with Informatica PowerCenter

  • SAMPLE Loading from source to target
  • SORTER Transformation
  • FILTER Transformation
  • ROUTER Transformation
  • EXPRESSION Transformation
  • JOINER Transformation
  • UNION Transformation
  • AGGREAGATOR Transformation
  • RANK Transformation
  • STORED PROCEDURE Transformation
  • SEQUENCE GENERATOR Transformation
  • Flat File
  • Look up Transformation
  • SCD type 1
  • SCD Type 2
  • SCD Type 3
  • Update Strategy
  • XML Source Qualifier
  • Types of load (Full, incremental, Refresh)

BI Testing with OBIEE

  • BI Test cases
  • Data validation with OBIEE
  • UI Testing with OBIEE

Different Tools

  • SQL Developer
  • Informatica PowerCenter Client Tools
  • OBIEE Reporting Tool