4.8

Description

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.

Key Features

  • 30 hours of Instructor Led ETL Testing Training
  • Lifetime Access to Recorded Sessions
  • Practical Approach
  • 24/7 Support
  • Expert & Certified Trainers
  • Real World use cases and Scenarios
Trusted By Companies Worldwide

Course Overview

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.

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

FAQ's

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

Certifications

Certification is a matter of demonstrating your skills and establishing your credibility. Tekslate will provide you with a course completion certificate. After the course completion, you will be in a position to clear the certification exam. We advise you to take up the following certification exam.

 

  • Oracle Fundamental Certification from Oracle.

  • Testing fundamentals Certification.

  • ISTQB Certification.

  • Click here to get certified.