ETL TESTING

TechgenLabs is one of the leading IT online Training and Placements Organization in USA. ETL Testing Online Training classes by TechgenLabs with highly qualified and excellent experienced trainers. Our trainers are experts and they have more experience in the real time environment in ETL Testing online training. We provide interactive and effective training for our student. So that you can interact with the faculty to clarify your doubts. Our team of well experienced ETL Testing online trainers with vast real time IT experience in ETL Testing Online Training is dedicated towards providing quality training in ETL Testing Online Training. We provide all real time interview questions to the students. We will provide recorded videos and material for future reference. ETL Testing Online Training is your one stop & Best solution to learn at your home with flexible timings. We placed our students in USA, UK, Singapore, Malaysia, Canada, South Africa, and Scotland. We  provide ETL Testing interview support and project support.

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