ETL Testing Online Training

 35 Hours
 24/7 Digital Library Access
 3012 Total Learners

ETL Testing Training

Mega Offer

Self-Paced Learning

Rs 12,000/ Rs 7,999/- 

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 Training

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

About Course

Learn 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

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

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


Related Courses


Let us know your convenient schedule
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 for sample video
Register For Free Digital Library
Quick Enquiry
We respond as soon as possible.
Register For Course Demo
Thanks for your interest.
Our Senior Course Adviser will get back to you soon.
Follow us
Submit your details
PGlmcmFtZSB3aWR0aD0iMTAwJSIgaGVpZ2h0PSIxMDAlIiBzcmM9Imh0dHBzOi8vd3d3LnlvdXR1YmUuY29tL2VtYmVkL0Qyc2h6dFc4WWhFIiBmcmFtZWJvcmRlcj0iMCIgYWxsb3dmdWxsc2NyZWVuPjwvaWZyYW1lPg==
Attend Live Demo