+91 9884833550 info@glimtechnologies.com

Reviews

1845 Ratings

p

Testing (programming)


ETL TESTING ONLINE TRAINING 


LMS Access

365 Days

Skill Level

Intermediate

ETL Testing Online Training provided by real time experts.ETL Testing Online Training  will be 100% practical training with real time examples.

What is ETL Testing?

ETL Testing has gained popularity since lots of companies has started using ETL tools like Informatica,Datastage for moving their data from legacy systems to Datawarehouse.ETL testing Online Training course  will cover testing concepts along with Basics of Informatica tool and SQL fundamentals.Professionals who are working in Manual testing and Other automation tools who are willing to move into Datawarehouse/ETL Testing can take up this course.

Why Glim Technologies,Best ETL Testing Online training ?

ETL Testing Online training  provided by best ETL Testing training. Best ETL Testing Online Training course provided by ETL Testing certified professional with more than 10 years of experience. ETL Testing training is given by our real time experts who have more experience in the Data warehousing and ETL tool. The training method will be based on the real time scenarios with 90% of practical sessions. ETL Testing course content is framed to cover both experienced and Non-experienced students in Data warehousing.

What we do at Glim Technologies, best ETL Testing training ?

Glim Technologies, provides Real time training in ETL Testing and placement. Our ETL Testing training  faculty has lot of Real time experience and well qualified in training the professionals. The faculty has 11+ years of Data warehousing experience and handled many corporate training. Separate session will be handled for ETL Testing Interview questions. Glim Technologies is recognized as Best ETL Testing Online Training by the students. For all the students, ETL Testing and Data warehousing basics is covered to understand the fundamental concepts.

Whom ETL Testing Online training course is suitable for?

ETL Testing Online Training is suitable for all Professional who has IT background and Non-IT background which can be easily learnt as it’s a GUI tool. Those who want to become a DWH specialist and more interested in data integration and analysis. This course can easily learnt by other technology professional like Java, .Net, Mainframe etc.,

Whom do we train at GLIM, best ETL Online Testing training ?

We are more experienced in giving training to professionals across all experience 0 -18 years and we have separate ETL Testing course content for Developer, Lead and Project manager. We customize the syllabus covered according to the role requirements in the industry.

Why GLIM Technologies ETL Testing  Online Training ?

GLIM Technologies provides real-time training focused placement oriented ETL Testing Online training . GLIM Technologies ETL Testing Online Training course covers basics to advanced topics and ETL Testing course syllabus is framed in such a manner that students will easily get placed after completing ETL Testing Online training . Our ETL Testing trainers are certified experts with more that 10 + years of experience with hands on real time multiple ETL Testing projects knowledge. We have the ETL Testing course content and syllabus covering more practical scenarios based on real-time experience. The course fee is affordable and less when compared to other institute and course fee is completely based on requirements of students. ETL Testing Online training conducted on day time classes, weekend training classes, evening batch classes and fast track training classes. GLIM Technologies ETL Testing trainers have trained more than 100 + students so far with successful placements. We provide excellent lab facilities for ETL Testing Online training in focused on ETL Testing Online training.

ETL Testing Online Training Syllabus

Data Warehouse Introduction

  1. Definition
  2. Informatica Introduction
  3. Fact and Dimension tables

Oracle SQL Fundamentals

  1. Overview of Oracle SQL
  2. Selecting required data
  3. Restricting required data
  4. Sorting required data

Data types in Oracle

  1. Introduction to data types
  2. Character data types
  3. Numeric data types
  4. Date Data types

Conditional Output

  1. DECODE and CASE function
  2. NVL, NVLIF and COALESCE function
  3. WITH clause

Aggregate data

  1. Aggregate functions
  2. GROUP BY function
  3. Having clause

Handling multiple tables

  1. Joining multiple tables
  2. Inner joins
  3. Outer joins
  4. Self Joins
  5. Cartesian products

Sub-queries Usage

  1. Define sub-queries
  2. Single-row and multiple row sub-queries
  3. Co-related sub-queries
  4. Nested sub-queries
  5. Inline views
  6. Hierarchical queries
  7. Distributed queries

Set operators

  1. UNION and UNION ALL
  2. INTERSECT
  3. MINUS

Data Manipulation Language

1.Insert records in a table

  1. Raw data insertion
  2. Copy data from table to table
  3. Conditional insert

2.Update records in a table

  1. FOR UPDATE clause

3.Delete records in a table

Views and Synonyms

  1. Simple and complex views
  2. Select from views
  3. Private and public Synonyms
  4. Materialized views

Power Center Components Overview

  1. Designer
  2. Repository Manager
  3. Workflow Manager
  4. Workflow Monitor
  5. Power Center Admin Console

Sources

  1. Working with relational Sources
  2. Working with Flat Files
  3. XML

Targets

  1. Working with Relational Targets
  2. Working with Flat file Targets
  3. XML

Simple Mapping Creation

  1. File to File
  2. File to Oracle
  3. Oracle to File
  4. Oracle to Oracle
  5. XML to File
  6. File to XML

Introduction

  1. Input
  2. Variable
  3. Output

Slowly Changing Dimension Overview

1.SCD Type1

2.SCD Type2

  1. Date
  2. Flag
  3. Version

3.SCD Type3

Debugger Overview

Preparation on test cases and execution of testing case

Bug Tracking Mechanisms

Introduction to various testings

  1. Unit Testing
  2. QA/UAT testing

Preparation of SQL statements according to requirements

StartsBatchDurationDaysTime (IST)
12th JuneRegular6 WeekMon - Fri08:00AM - 09:30AM
17th JuneWeekend8 WeekSat & Sun10:00AM - 01:00PM
19th JuneRegular6 WeekMon - Fri06:30PM - 08:00PM
24th JuneWeekend8 WeekSat & Sun04:00PM - 07:00PM
26th JuneRegular6 WeekMon - Fri01:00PM - 02:30PM
03th JulyFast Track5 WeekMon - Fri08:00AM - 10:00AM
08th JulyWeekend8 WeekSat & Sun12:30PM – 03:30PM
10th JulyRegular6 WeekMon - Fri06:30PM - 08:00PM
15th JulyWeekend8 WeekSat & Sun04:00PM - 07:00PM
17th JulyRegular6 WeekMon - Fri12:30PM – 03:30PM
24th JulyFast Track5 WeekMon - Fri06:00PM - 08:00PM

 

ETL Testing Online Training Features 

  • Training is handled by ETL Testing Certified Professionals with 10+ years of Experience.
  • Strong Theoretical & Practical Knowledge.
  • More than 300+ students have been trained and have been successfully placed in MNC companies.
  • Practical Oriented sessions with real time scenarios.
  • Individual attention will be given to all students.

“Hi,I did ETL Testing Online training from Glim Technologies,I really thankful for My trainers. His training is really good and practical oriented one. They referred me for One MNC. Now I got selected in that MNC.”

-John

ETL Testing Online Training by Glim Technologies is best coaching center for ETL Testing. Thanks to Glim Technologies.”

-Steve

“I am Sukumar working for an MNC. The overall training is excellent which helped me to gain knowledge on ETL Testing. The trainers over here are very excellent and supportive. They assisted us in every means in terms of course materials, timings of class. Thanks a lot to Glim Technologies. Definitely with no doubt I will refer others Glim Technologies,best ETL testing Online training

-Sukumar

“I did ETL Testing Online training  from Glim Technologies. Really I thank each and every Trainers of Glim Technologies. Very good and Practical oriented ETL Testing Online training was provided in Glim Technologies .”

-Narayanan

“Really Great ETL Testing Online Training from Glim Technologies. Really practical oriented only. They explain each and every Concept in Detail Manner.”

-Sruthi Naydu

Interested in training your team ? Get a custom quote.

+91 988 464 4550

+91 988 483 3550

Glim Technologies        5 out of 5 based on 1218 ratings.

Summary
Review Date
Reviewed Item
Glim Technologies
Author Rating
51star1star1star1star1star