ETL Testing Online Training

2982 Ratings

35 Hours

24/7

3012 Learners

Instructor-led Live Online Training

Interactive training
Certified & industry expert Trainers
Industry ready curriculum
Fast-track / Regular / Weekend

Pre-recorded Video Training

Learn at your own convenience
Certified & Industry Experts Trainers
Multiple Training Delivery Models
Customize Course

Current Offer

30% OFF

ETL Testing Course Curriculum

Duration: 35 Hours

  • Software Testing Life Cycle
  • Software Development Life Cycle
  • Manual Testing Experience is Plus
  • Usage of HP quality Center
  • Defect Life Cycle
  • What is Data Ware House?
  • Difference between OLTP and Data warehousing
  • Data Extraction
  • Data Transformation
  • Data loading
  • Star Schema
  • Snow Flake Schema
  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD
  • SELECT
  • Single Row Functions
  • Aggregate Functions
  • JOINS
  • SUBQUERYS
  • SET Operators
  • Analytical Functions
  • DDL, DML, Views (High level Concepts)
  • Minus querying
  • Count Querying
  • 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
  • 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

Trainer Information

  • 6 + years of work experience in IT Industry
  • Well-equipped in performing ETL operations with Informatica Power Center.
  • Excellent interpersonal and communication skills.


Related Courses


Attend Live Demo
Suggest me a course for a better career
Donor Details
Donee Details
(Your Details)
(To whom you want to gift a course)
Request a Demo
Register For Free Digital Library
Quick Enquiry
We respond as soon as possible.
Register For Course Demo
Course Highlights:
Free Course Access for 365 Days.
Real Time, Certified, Expert Trainers.
Email & Forum support for 365 days.
Fast-track / Regular / Weekend.
Job oriented & Industry ready curriculum.
Register For Free Live Demo
Thanks for your interest.
Our Senior Course Adviser will get back to you soon.
Follow us