Oracle HCM Cloud Placements and Training

ETL Testing Online Training

One of the top ETL Testing Online Training institutes in Bangalore with highly skilled trainers

  • 4.7
  • 105 Google reviews
Class Availability
Weekdays & Weekends
Course Duration
40-45 Hours
Training Methodology
25% Theory & 75% Practical

Class Availability

Weekdays & Weekends

Course Duration

40-45 Hours

Training Methodology

25% Theory & 75% Practical

4970

Profesionals Trained

350

Workshops Every Month

50

Countries And Counting

100

Corporate Served Successfully

ETL Tool Online Training in Bangalore

ETL Tool Online Training in Bangalore

IQ Stream Technologies is one of the top ETL Informatic Testing or Data Warehouse Testing training institutes in Bangalore with highly experienced and skilled trainers. IQ Stream Technologies Bangalore also offers placement assistance for students who enrolled in Advanced ETL Testing (Extract-Transform-Load) or Data Warehouse Testing Training Courses. We offer advanced ETL Testing or Data Warehouse Testing classes, ETL testing online training OLTP, OLAP, Warehouse Architecture, ETL testing concepts, ETL data warehouse, Data Marts, data warehouse testing, ODS, Dimensional Modelling, ETL testing tools, data warehouse concept, Star Schema and Snowflake Schema learning experiences and tools for better learning, understanding and experience. We offer ETL Testing Training classes and more other software testing courses in Bangalore BTM with advanced and most updated syllabus and excellent classrooms. IQST also offers Corporate Training for ETL Informatic Testing or Data Warehouse courses to improve the knowledge and standard of your employees.

Expert ETL Training Institute

Expert ETL Training Institute

Become and Expert Developer in ETL Testing or Data Warehouse Testing with IQ Stream Technologies’ advanced ETL Testing learning programmes. ETL testing course content includes ETL testing basics, data warehouse testing tools, ETL testing automation, ETL testing concepts with examples, ETL testing common SQL queries, etl automation testing tools, ETL automation testing framework, data warehouse design, informatica testing etc.Main highlights of our ETL Testing Training include in Bangalore (BTM Layout) Intensive Practical Training, Advanced Learning Materials & Tools (Oracle Warehouse Builder (OWB), SAP Data Services, IBM Infosphere Information Server etc), Friendly Classrooms etc. IQ Stream Technologies offer beginner, intermediate and advanced lessons (ETL testing course content) for you to become an expert in the area and one of the best among ETL testing institutes in Bangalore. Special ETL Testing or Data Warehouse corporate training also delivering at IQ Stream Technologies, Bangalore location. IQST offers ETL Testing corporate training if your organization wish to train their employees on ETL Testing processes and responsibilities.

Course Overview

Course Name ETL Testing Training
Venue IQ Stream Technologies
Official URL ETL Testing Online Training
Demo Classes On Demand
Training Methodology: 25% Theory & 75% Practical
Course Duration 40-45 Hours
Class Availability Weekdays & Weekends
Demo Training Email ID : info@iqstreamtech.com

Syllabus

Importance of ETL testing

Importance of ETL testing

A super market has implemented DWH it has become easy for the high level management to take decision on

  • How to increase the market share of the company by 5%?
  • Which product is not doing well in the market?
  • Which department needs help with selling products?
  • What is the quality of the customer service provided and what improvements are needed?
  • what products are sold
  • what is not selling
  • when does the sale go up
  • what is the age group of customers who are buying a particular product and several other queries

Scope of ETL testing

Scope of ETL testing

In early days of 80s, there were simple applications. With the speed of light, the world progressed from mainframes and batch applications to personal computers and online applications. At the same time, there emerged a class of data applications that are now known as business intelligence and data warehousing.

Data warehousing lets people look at corporate data as never before. Patterns, trends, seeing the forest and the trees — all became a possibility with data warehousing. Business people were able to look at their enterprises as no one had ever been able to previously and entire industries and multi-billion dollar companies grew out of this love of knowing more. Companies saw that business intelligence and data warehousing allowed them to make important corporate decisions based on new perspectives gained from data gathered from all over the corporation.

However, the thirst for more insight into data created by warehousing techniques created a virtual flood of data. Data Warehouses stored detailed data, historical data, and data integrated from a wide variety of sources. There was an inevitable formula that applied to every data warehouse that has ever been built –

Detail x History x Many Sources = Lots of Data

Fortunately, technology grew to the extent that large volumes of data could be handled. However, even today only a few solutions offer true unrestricted ad hoc access to this class of data.

So the corporate or MNC’s requirement in india and abroad is to recruit more and more people with adequate knowledge in Datawarehouse and Business Intelligence. Areas where DWH can be implemented are:

Banking
Retail
Insurance
Telecom
Healthcare etc..

Datawarehouse Concepts

Datawarehouse Concepts

  •  DWH architecture
  • Charactersitics of DWH
  •  DataBase
  •  Difference between DWH and DB
  •  ETL
  •  DATA MART
  •  Data Mart vs DWH
  •  OLTP vs OLAP
  •  Data Modelling
  •  Dimensions &Facts tables

ETL Testing

ETL Testing

  • ETL architecture
  • What is ETL and importance of ETL testing
  • How DWH ETL Testing is different from the Application Testing
  • SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
  • Challenges in DWH ETL Testing compare to other testing
    • Incompatible and duplicate data.
    • Loss of data during ETL process.
    • Testers have no privileges to execute ETL jobs by their own.
    • Volume and complexity of data is very huge.
    • Fault in business process and procedures.
    • Trouble acquiring and building test data.
  • ETL Testing Work flow activities involved
    • Analyze and interpret business requirements/ workflows to Create estimations
    • Approve requirements and prepare the Test plan for the system testing
    • Prepare the test cases with the help of design documents provided by the developer team
    • Execute system testing and integration testing.
    • Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
    • How to detect the bugs in the ETL testing
    • How to report the bugs in the ETL testing
    • How to co-ordinate with developer team for resolving the defects
  • Types of ETL Testing
    • Data completeness.
    • Data transformation.
    • Data quality.
    • Performance and scalability.
    • Integration testing.
    • User-acceptance testing.
  • SQL Queries for ETL Testing
  • Incremental load testing
  • Initial Load / Full load testing
  • Different ETL tools available in the market
    • Informatica
    • Ab Initio
    • IBM Data stage
  • Power Center Components
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
    • Power Center Admin Console
  • Informatica Concepts and Overview
    • Informatica Architecture.
  • SourcesWorking with relational Sources
    • Working with Flat Files
  • Targets
    • Working with Relational Targets
    • Working with Flat file Targets
  • Transformations – Active and Passive Transformations
    • Expression
    • Lookup –Different types of lookup Caches
    • Sequence Generator
    • Filter
    • Joiner
    • Sorter
    • Rank
    • Router
    • Aggregator
    • Source Qualifer
    • Update Strategy
    • Normalizer
    • Union
    • Stored Procedure
    • Slowly Changing Dimension
      • SCD Type1
      • SCD Type2 — Date, Flag and Version
      • SCD Type3
  • Workflow Manger
    • Creating Reusable tasks
    • Workflows, Worklets & Sessions
    • Tasks
  • Session
  • Decision task
  • Control Task
  • Event wait task
  • Timer task
    • Monitoring workflows and debugging errors
  • Indirect Loading
  • Constraint based load ordering
  • Target Load plan
  • Worklet ,Mapplet ,Resuable transformation
  • Migration ?ML migration and Folder Copy.
  • Scheduling Workflow
  • Parameter and variables
  • XML Source, Target and Transformations
  • Performance Tuning
    • Pipeline Partition
    • Dynamic Partition
    • Pushdown optimization
  • Preparation of Test Cases
  • Executing Test case
  • Preparing Sample data
  • Data validation in Source and target
  • Load and performance testing
  • Unit testing Procedures.
  • Error handling procedures.

SQL

SQL

  •  DDL, DML,TCL,DCL Statements
  •  Character functions
  •  Aggregate/group functions
  •  Date functions
  •  Distinct, order by , or, between , like, group by conditions
  •  Set operators
  •  Constraints
  •  Joints
  •  Rowid, rownum, partition by, case statements, rank and dense rank
  •  Creating index, views, back up table

UNIX

UNIX

  • Pwd, ls, ls , ls –l, ls –lrt
  •  Cd , cat , head , tail , more ,
  •  Wc , wc –l, wc –c, cp, mv, rm, rm –r ,diff,
  •  Unzipping a file
  •  Sed, grep
  •  Vi editor
  •  Real time commands like
  •  How to convert a flat file to table using unix
  •  Find the count of flat file\
  • Validating the header of flat file
  • Validating the trailer of flat file
  •  Find the detailed record of flat file
  •  Validating the delimiter of flat file

MANUAL TESTING

MANUAL TESTING

SDLC and various models
Functional, integrating, acceptance , system, regression, smoke and sanity testing
How to write test cases, how to prepare test summary reports
Defect life cycle and how to log defects
STLC
Complete real time knowledge on test management tool QC.

INFORMATICA TOOL

INFORMATICA TOOL

  • Work flow designer, manager and monitor window
  •  Different work flow status
  •  Validations in real time and transformations like
  •  Aggregator ,Filter , Expression , Router , Lookup transformations
  •  Data quality and its rules
  •  Slowly changing dimensions
  •  How to convert flat to data files and vice versa using informatica tool

Konanki Manimala

    • 4.7
Positive: Communication, Professionalism, Quality, Value

Iq stream providing best soft skill class.it was very useful for fresher and who are not able to communicate in front of others.i was thankfull to Sidharth for training me and given confidence that I can speak in English.

Ganesh Nandkhile

    • 4.7
Positive: Communication, Professionalism, Quality, Value
Very useful. Trainer explained the topics with relation to actual work scenario

Geetha KLR

    • 4.7
Positive: Communication, Professionalism, Quality, Value

I had taken Oracle SOA training from Mr. Bhaskar. He is highly experienced and helped us with real time scenarios. The training was very effective. Thanks Mr. Bhaskar for all your support during the training.

    Request Course Demo


    Please prove you are human by selecting the Car.







    Training

    Related Courses

    Enquiry Now
    close slider

      Enquiry

      Please prove you are human by selecting the Flag.





      Call Now ButtonCall Now