ETL Testing Online Training 2018-10-08T11:55:31+00:00

ETL Testing Online Training

 35 Hours

 24/7 Digital Library Access

 3012 Total Learners

 10% Off

Instructor-led Online Training

Interactive Live training
Real Time, Certified, Expert Trainers
Job oriented & Industry ready curriculum
Free Course Access for 365 Days
Fast-track / Regular / Weekend

Recorded Video Online Training

Learn at your own convenience
Certified & Industry Experts Trainers
Email & Forum support for 365 days
Priority Certification support
Multi Instructor sessions

ETL_Testing_video-BigClasses

Upcoming Batches

16
June

Sat – Sun ( Weekends )

08:30 AM – 10:30 AM ( IST )

20% Off

22
June

Mon – Fri ( Weekdays )

05:30 AM – 06:30 AM ( IST )

20% Off

Can’t find convenient schedule? Let us know

Learn ETL Online training

What is ETL Testing Online 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 training can equip you to take up good jobs in some of the biggest companies in the world.

Who Can Learn

  • ETL and SQL Developers, software engineers and analysts
  • BI, Mainframe, and database Project managers

Pre-requisites

  • A basic knowledge of SQL concepts can be helpful.

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

Information will be Available Soon…

Frequently asked questions

We are having ample of experience in ETL Testing Online training. After every session recordings will be provided and soft copy of ETL Testing Training material will be provided.

Bigclasses offers 365 days access to videos, course materials, 24/7 Support, and course material upgrading to latest version. Bigclasses involves working with real time projects,test cases and assignments.The entire course content is in line with clearing ETL Testing Certification exam.

We offer four types of Modes:

  • Instructor-led Online Training
  • Recorded Video Training
  • Corporate Training
  • Project Support

Apart from technical training & hands-on project work bigclasses will guide the students to get placed in there dream roles and we would be happy to assist students with the process of preparing yourself for the interview and the job.
We provides you email support to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact BigClasses even after completion of training to get support and assistance.

Request a Demo

  • For Instructor-led Online
  • For Recorded Video
  • For Corporate Training
  • For Project Support
For Instructor-led Online

For Recorded Video

For Corporate Training

For Project Support

Get Free Digital Library Access