ETL Testing Training

  • (4.6)
  • 2707 Ratings
  • Learners : 2732
Try Live Demo

Trusted By Companies Worldwide & 3,50,850+ Learners

ETL Testing Course Overview

Tekslate offers the best Extract Transform Load (ETL) training. This course is designed based on real-time applications and testing case studies, and the curriculum is prepared by experienced trainers. You will learn several ETL testing tools like QuerySurge, Informatica Data Validation, ICEDQ, and Talend Open Studio for Data Integration.
Course Duration 30 hrs
Live Projects 2
Next Batch 21 Nov, 2019
23 Nov, 2019
26 Nov, 2019

ETL Testing Course Curriculum

  • Data warehousing architecture

  • OLAP,ROLAP, MOLAP

  • Data mining

  • Meta data

  • Tables, views

  • Constraints

  • Fact and Dimensional Tables

  • Partitioning of tables

  • Concepts of Referential Integrity

  • Concepts of Modelling

  • Database Schema

  • Concepts of normalization

  • Concepts of Slowly Changing Dimensions

  • Concepts of Data Mart

  • Full and Incremental extraction Process

  • Change Data capture

  • DDL, DML commands

  • All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions)

  • Joins

  • Practice SQLs for some sample test scenarios

  • Creating, running and analysing sessions/workflows in Informatica

  • Preparation of Test strategy, Test plan and estimations

  • Testing scenarios, creation of test cases and scripts

  • Test case execution and defect tracking and reporting

  • Validation of the report data with DB and UI testing

  • Preparation of Test data

  • Unit testing

  • Integration testing

  • Module testing

  • System testing

  • Uat

For Individuals
For Corporates

ETL Testing Upcoming Batches

  • Weekend

    21 Nov - 21 Dec

    7:00 AM IST
  • Weekday

    23 Nov - 23 Dec

    7:00 AM IST
  • Weekend

    26 Nov - 26 Dec

    7:00 AM IST
  • Weekday

    28 Nov - 28 Dec

    7:00 AM IST
  • Weekend

    1 Dec - 31 Dec

    7:00 AM IST
  • Weekday

    5 Dec - 04 Jan

    7:00 AM IST
  • Schedules Doesn't Suit You ?

    Our Team can set up a batch at your convinient time.

    Let us know

    ETL Testing Course Objectives

    By the end of Extract Transform Load testing training, you will be able to:

    • Perform validation and prevent the defects.
    • Provide information and verify the performance and functionality of the data warehouse

    • Implement the quality analysis of data.

    • Optimise user experience.

    • The transformation occurred in data warehouse testings has created a huge requirement for ETL testers. The count is gradually increasing and is likely to continue well in near future.

    • Certified ETL testers are being hired by top MNCs like Oracle, Informatica, and IBM.

    • The average earnings of a certified ETL tester are around $59000 per annum.

    • Working IT professionals

    • web developers

    • Database Administrators.

    • Software programmers

    • Business Analysts

    • Data Warehousing engineers

    Basic knowledge related to programming and databases is required. The following job roles will get benefited by taking up this course:

    • Software programmers.
    • Data Warehousing engineers.

    • The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.

    Have More Questions

    Contact us

    ETL Testing Course FAQ's

    Have questions? We’ve got the answers. Get the details on how you can grow in this course.

    • Our trainers are well experienced professionals and certified in working with front-end development technologies.
       
    • We will record all the Live sessions you go through, and we will send the recording of the class you missed.
       
    • For practical execution, our trainer will provide server access to the student. 
       
    • All our training classes are live. This is to solve all the student queries directly with the trainer.
       
    • Live online training means, our trainer will be in online with you to solve your issues.
    • Pre-recorded training means, there will be no trainer available to solve your issues.
       
    • You can contact our Tekslate support team, or you can send an email to info@tekslate.com for your queries.
       
    • Yes, you can access the course material after completing course by the recorded training videos we shared with you during training.
       
    • To avail all discounts offered by Tekslate, you need to visit the website regularly. However, there will be a group discount for 2 or more participants.
       
    • Yes, you will get your refund by cancelling some administration fee from the course. But, you should cancel your enrolment within 48 hours of registration, and then the refund will be retained within 30 days of a request.
       

    Have More Questions. Reach our Support Team

    Contact us

    Join a Free ETL Testing Demo Session

    See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate

    Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in ETL Testing

    By providing us with your details, We wont spam your inbox.