ETL Testing Online Training

ETL Testing
Extraction Transformation Loading

Best ETL Testing Online Training qatraininghub
ETL Testing Online Training
Average Rating: 4.6
Votes: 109
Reviews: 87

Overview

QA Training Hub - Best Online ETL Testing Training Institutes in Ameerpet Hyderabad, Bangalore, Chennai, Mumbai, Pune, Delhi, Noida, Gurgaon, India, USA, UK, Canada.

ETL stands for Extract Transformation and Load. As the name implies, ETL testing is the process of pulling data from source database and placing it in the destination database. It is also used to convert database from one type to another. The migration of data from one database to another forms data marts and data warehouses.

ETL testing uses two important documents for its migration process. They are ETL mapping sheets and DB schema of source and target. Before the testing process initiate, these two documents should be in complete state. The ETL mapping sheet consists of detailed information about the source and destination tables. It also includes information about every column that is present in the table.

ETL testing is categorized into four types namely new data warehouse testing, migration testing, change request and report testing. In new data warehouse testing, new data warehouse is created and built from the scratch. In migration testing, the data is moved to an existing data warehouse. In change request, new data from different sources is added to the existing data warehouse. In report testing, reports are tested by validating its layout and data.

Benefits of using ETL

  • Ensures that data is transformed without any data loss
  • Ensures that data is transformed correctly with regard to the business requirements
  • Provides improved performance and scalability
  • Ensures that the prescribed data is transferred within the allotted time frame
  • Provides an error free integration of data from different departments

As ETL is rapidly and successfully growing in the testing industry, it has become an essential for a professional in the testing field to know all the details about it.

Our trainers train you through the complete ETL testing phases that include understanding and validating of business requirements, test estimation and planning, designing test cases and preparing test data and execution and preparation summary reports.

We focus on all ETL testing use cases which include production validation testing, source to target testing and application upgrades. ETL Testing needs knowledge of SQL queries that may be used to validate data at any stage. We give you training using real time projects that provide you experience in writing complicated queries.

ETL Testing Online Course Content

Module 1
  • What is Data warehouse?
  • Need of Data warehouse?
  • Introduction to OLTP, ETL and OLAP Systems
  • Data Warehouse Architecture
  • Data Marts
  • Operational Data Store
  • Dimensional Modeling
  • Difference between Relational and Dimensional Modeling
  • Star, Snowflake Schema, Schema and fact constellations schema
  • What are fact and Dimensional tables?
  • Normalization and De-Normalization?
  • Several realtime business scenarios
  • Types of SCD's
Module 2
  • Introduction to informatica power center 9.x version
  • Introduction to all the informatica Mapping
  • Introduction to workflow, worklet, Mapping, Mapplet
  • Installing informatica and Unix in laptop or Desktop
Module 3
  • ETL Testing (Data warehouse testing)
  • ETL Architecture
  • What is ETL and Importance of ETL Testing
  • How DWH testing is different from Manual and Automation Testing
  • SDLC/STLC
  • Challenges in DWH Testing compared to other testing
  • Imcompatable and Duplicate Data
  • Loss of Data During ETL Process
  • Volume and Complexity of Data
ETL Testing Workflow activities
  • Analyze and interpret business requirements /workflows to create estimations
  • Prepare the test cases with the help of design documents provided by the development team
  • Execute System Testing and Integration Testingv
  • How to detect the bugs in the ETL Testing
  • How to report the bugs in the ETL Testing
Types of ETL Testing
  • Data Completeness
  • Data Trnasformations
  • Data Quality
  • Performance and Scalability
  • Integration Testing
  • SQL Queries for ETL Testing
  • Incremental load Testing
  • Initial Load/ Full Load Testing
  • Different ETL Tools available in the Market
  • Informatica, Abinition, Datastage
Power Center Components
  • Designer, Repository Manager
  • Work Flow Manager, Work Flow Monitor
  • Mapping Document,Preparation of Test Cases
  • Execution of Test Cases
  • Data Validation in Source and Target
  • Regression Testing
Module 4
  • Detailed SQL Foundation for Beginners
  • Select, Insert, Upate, Delete, Drop, Truncate, Filter, Where, Group By, Having, Order By Commands
  • Arithmetic, Comparision and Logical Operators
  • IN, NOT IN and Set Operators
  • Union, Union All, Intersect
  • Cross Join
  • Simple Queries
  • Constraints
  • Aggregate Functions
  • Alias Joins
  • Simple Join, Equi Join, Self Join, Inner Join, Outer Join, SubQueries, Nested SubQueries
  • Rank and Dense Rank
Module 5
  • Learning all the file operation of UNIX for ETL tester
  • Basic UNIX command
  • Basic UNIX file operations
  • Learning regular expression like grep sed awk
Module 6
  • Interview preparation
  • Resume writing
For QA Testing Tools Online COURSE: Click here
For SOAP UI Online COURSE : Click here
For SAP Online COURSE: Click here
For ETL Online COURSE : Click here
For JMETER Online COURSE : Click here
For Automation Online COURSE [HP+QTP/UFT] : Click here

More ideas & Relevant Searches for this Online Training Selenium Course Content...
  • ETL DWA Online Training
  • ETL Testing Online Training
  • DataWarehousing training
  • ETL Testing Corporate training
  • ETL Testing training in Delhi
  • ETL Testing training in Hyderabad
  • ETL Testing Training in India
  • ETL training online india
  • ETL testing online training in usa

  • Thanks for visiting our qatraininghub.com

    "Let's Share, Sharing is Caring" & Like Our Fb Page..!

Mr. Srivastava & Mr. Jeet

10+ Years


 


Copyright © 2016 QA Traing Hub.All Rights ReservedPowered byWEBNIXX