ETL Testing Training

ETL Stands for Extract Transform and Load. ETL tools will integrate various kind of data format into the desired data. ETL tools will support different type of vendors with different software. In addition, ETL tools will do transformation of data within systems involving complex business rules. Various ETL tools are available in market like Informatica, Microsoft SSIS, Clover, Oracle Warehouse Builder, etc.,

ETL will perform the following operations

  • Extraction of data from various sources
  • Transformation of data involve following activities
    • Cleansing the existing data
    • Standardizing the data
    • Reformatting the data
    • Aggregation of data
    • Applying complex business rules with existing data
  • Transformed data will be loaded into the desired data format

ETL Training Placement

  • Students will get 100% placement assistance from Hope Tutors until they get placed

Best Online ETL Testing Training

Hope Tutors is well equipped with latest infrastructure and experienced trainers to provide Online ETL Training.

Contact us today to know more about our Testing Training and schedule a free demo class.

Related Testing Courses

Course Curriculum

ETL Testing - Concepts
Test plan & Testing strategy in data warehousing 00:00:00
Report testing and Data warehousing testing 00:00:00
Testing plan 00:00:00
Test cases possibilities in Data warehousing 00:00:00
HP ALM and HP QC – Defect raising and re-testing 00:00:00
Basic DATABASE Concept and SQL
Basic history of database concept: DBMS, RDBMS, ORDBMS 00:00:00
SQL Language overview : DQL, DML, DDL, DCL, TCL 00:00:00
Data Manipulation Language DML and Transaction Control Language TCL
DML : INSERT, UPDATE, DELETE, MERGE 00:00:00
TCL : COMMIT, ROLLBACK, SAVEPOINT 00:00:00
Data Definition Language - DDL
DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE 00:00:00
DEFAULT OPTION. 00:00:00
Restricting and Sorting Data
WHERE Clause – Character Strings and Dates, number 00:00:00
General Comparison Conditions = > >= < <= <> 00:00:00
Other Comparison BETWEEN , IN , LIKE , NULL 00:00:00
Logical Conditions AND OR NOT 00:00:00
ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns 00:00:00
Constraints
NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK 00:00:00
Column Level Constraint, Table Level Constraint – Naming constraints and usage 00:00:00
Adding a Constraint, Dropping a Constraint, 00:00:00
Disabling Constraints, Enabling Constraints 00:00:00
Validating Constraints 00:00:00
Single-Row Functions
Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE 00:00:00
Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS 00:00:00
Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date 00:00:00
Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE 00:00:00
General Functions: NVL , NVL2 , NULLIF, COALESCE 00:00:00
CASE Expression, DECODE 00:00:00
Nested function with real-time usage 00:00:00
JOINS
EQUI JOIN / SIMPLE JOIN / NORMAL JOIN 00:00:00
ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER 00:00:00
INNER JOIN, JOIN … USING clause, JOIN … ON clause, 00:00:00
CROSS JOIN, NON-EQUI JOIN, SELF JOIN 00:00:00
ORACLE STANDARD OUTER JOINS. 00:00:00
Multi table Joins, Complex Joins – How to simplified complex joins. 00:00:00
Multi-row Functions
Group Functions Rules, SUM, MIN, MAX, COUNT, AVG 00:00:00
Creating Groups of Data: GROUP BY Clause 00:00:00
Filtering Group Results: The HAVING Clause 00:00:00
Sub-queries
Single-Row Subqueries- Rules, Operators : = > >= < <= <> 00:00:00
Null Values in a Subquery 00:00:00
Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL 00:00:00
Views
Simple Views and Complex Views – Create, Drop 00:00:00
Rules for Performing DML Operations on a View 00:00:00
Inline Views 00:00:00
Materialized View – Create, Refresh, Drop – Usage 00:00:00
Other Database Objects
Sequence- NEXTVAL and CURRVAL 00:00:00
Index
Index – When to Create an Index, When Not to Create an Index. 00:00:00
Synonyms
Synonyms 00:00:00
SET Operators
UNION 00:00:00
UNION ALL 00:00:00
INTERSECT 00:00:00
MINUS 00:00:00
Advanced Date-time Functions
TIME ZONES 00:00:00
SYSDATE, SYSTIMESTAMP 00:00:00
CURRENT_DATE , CURRENT_TIMESTAMP 00:00:00
SESSIONTIMEZONE 00:00:00
TO_YMINTERVAL 00:00:00
TO_TIMESTAMP , numtodsinterval, cast, compose, decompose 00:00:00
Analytic Functions
WM_CONCAT, LAG, LEAD, RANK, DENSE_RANK 00:00:00
Query_by partition_clause with sum, min, max, avg, count 00:00:00
order_by_clause with sum, min, max, avg, count 00:00:00
Data warehouse Concepts
Business Intelligence 00:00:00
Data Warehousing Concepts (What/Why/How) 00:00:00
Data Modeling (Schemas, FACTS and DIMENSIONS) 00:00:00
Data Mart 00:00:00
Metadata 00:00:00
OLAP VS OLTP 00:00:00
Dimension 00:00:00
Fact 00:00:00
Types of Dimension tables 00:00:00
Types of Fact tables 00:00:00
Star Schema 00:00:00
Snowflake Schema 00:00:00
Slowly Changing Dimensions 00:00:00
Top down and Bottom up approach 00:00:00
E T L Informatica Power Center 9.X.X
Why do we need ETL tool and Why Informatica? 00:00:00
Introduction to Informatica
Introduction 00:00:00
Getting started 00:00:00
Informatica Suite Components 00:00:00
Informatica Architecture 00:00:00
Informatica Server 00:00:00
Informatica Power Center Client Components
Repository Manager 00:00:00
Designer 00:00:00
Workflow Manager 00:00:00
Workflow Monitor 00:00:00
Informatica Building Blocks
Source & Targets 00:00:00
Transformations 00:00:00
Mappings 00:00:00
Mapplets 00:00:00
Sessions 00:00:00
Workflows 00:00:00
Sources
Working with Relational Source 00:00:00
Working with Flat file Source 00:00:00
Working with heterogeneous sources 00:00:00
Targets
Working with Relational Targets 00:00:00
Working with Flat file Targets 00:00:00
Direct and Indirect file loading 00:00:00
Different Transformations
Active and Passive Transformations 00:00:00
Connected and un-connected transformations 00:00:00
Source Qualifier Transformation 00:00:00
Filter Transformation 00:00:00
Expression Transformation 00:00:00
Sorter Transformation 00:00:00
Aggregator Transformation 00:00:00
Router Transformation 00:00:00
Rank Transformation 00:00:00
Sequence Generator Transformation 00:00:00
Joiner Transformation 00:00:00
Lookup Transformation 00:00:00
Connected Lookup 00:00:00
Un Connected Lookup 00:00:00
Update Strategy Transformation 00:00:00
Union Transformation 00:00:00
Normalizer Transformation 00:00:00
Transaction Control Transformation 00:00:00

Course Reviews

4.4

143 ratings
  • 5 stars4
  • 4 stars4
  • 3 stars3
  • 2 stars0
  • 1 stars0
  1. Profile photo of Bhargav

    Best training

    I Got a real – time knowledge in ETL. My training is full of practical sessions. Thanks Hope Tutors

  2. Profile photo of Girish

    Best Institute for ETL testing

    I completed my ETL Course in Hopetutors . My training is very useful .I got placed in MNC.

  3. Profile photo of Abirami

    Best Institute

    I learned ETL training in Hope Tutors. The experience was really useful and good. thanks

  4. Profile photo of janaki

    My Training Experience in Hope Tutors

    The way my trainer explained the concepts is very simple and understandable. End of my training i done a real time project its useful to develop my carrier. Thanks for the useful training.Good experience .

  5. Profile photo of Jeyand

    Best training institute for professionals

    I am already working in Testing field for my project change i Learn ETL advance concepts in Hope Tutors. Both the trainer and training is real – time one. Useful and one of the best institute for professionals

  6. Profile photo of Albert

    ETL training

    I am new to this testing , but for my project i learn this concepts in Hope Tutors.The training is full of practical with real – time examples. My trainer really a stuffed guy. Thanks

  7. Profile photo of Trazyjoesphin

    good experience

    I am a automation tester for my onsite project i learn ETl , Really nice experience. Fast track classes but trainer support me a lot during training.thanks Hope

  8. Profile photo of Prithvi

    Useful Training

    Hope Tutors give me a good and quality training for ETL. Really useful and lot of new concepts i learned thanks

  9. Profile photo of NareshKumar

    Best Training institute

    One of the best institute for ETL .Trainer really support me and help me to complete my project. good experience

  10. Profile photo of sainthavi

    Best Trainer and Training institute

    I search lot of institute for my training finally i got a best trainer and training institute . Hope Tutors really give me a good and practical oriented training.

  11. Profile photo of Daniel

    Best trainer For my training in Hope tutors

    Thanks for my trainer kumar for the best training he gived. the training was very useful and informative one. He explained a lot of new concepts .

PRIVATE COURSE
  • PRIVATE
  • 1 Days
  • Average Rating4.4
192 STUDENTS ENROLLED
  • Profile photo of Bhargav
  • Profile photo of Girish
  • Profile photo of Abirami
  • Profile photo of janaki
  • Profile photo of Jeyand


Course Reviews

  • ASP.NET

    5

    I have studied dotnet in Hope Tutors.Here excellent training provided by trainers.My trainer name is Dhandapani. He is kind in nature and explain the concepts with real manner. Interactive session and practically explained here.
    Profile photo of Shakthi
    Shakthi
  • Microsoft SQL Server

    Excellent Institute 4

    Excellent Training institute.Trainer name is Deepan who is having more than 8 years of experience in IT industry.Hope Tutors having excellent syllabus in hand which will provide depth knowledge in SQL server.
    Profile photo of Shakthi
    Shakthi
© 2017 Hope Tutors. All rights reserved.