fbpx
ETL Testing Online Training2020-03-03T15:08:56+05:30

ETL Testing Online Training

 35 Hours

 24/7 Digital Library Access

 3012 Total Learners

 Lifetime Access

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 online training

Upcoming Batches

22 Dec

Sat – Sun ( Weekends )

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

20% Off

24 Dec

Mon – Fri ( Weekdays )

07:30 AM – 08: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 online 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

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

  • 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 reporting the Bugs in ETL Testing?
    • ETL Testing Responsibilities
    • How to design the Test cases in ETL Testing.
    • 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
    • Slowly Changing Dimension 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

  • 5 + 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

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

          paynow

          Our Meeting Partners

          Get Free Digital Library Access