USA : +1 732 325 1626
IND : +91 800 811 4040
Mail ID : info@bigclasses.com
Online Training

ETL Testing Interview questions and answers



Click Here for Updated New and FAQ'S and Interview Questions On SAP,Data Warehousing,JAVA,Oracle,Oracle DBA,Micro Soft,Hadoop,Business Analyst,Testing Tools. http://learn.bigclasses.com/


For more Informatica Interview Questions and answers


Click HERE:

Set Your Career Path by ETL Testing Online Training

We provide ETL testing online training worldwide with the help of real-time scenario. Our ETL testing training program is designed to give learners the skills & knowledge to gain a competitive advantage in starting a career in ETL testing.
ETL is known as Extract Transform and Load and it collects the data from different data source of Heterogeneous System; then transforms the data into the target Data warehouse. In computing, Extract-Transform-Load refers to a procedure of database usage and it also involves extracting data from outside sources, transforming it into the desired form to fit the operational needs, loading it into the final target database.

Our ETL testing online training is designed for experienced and novice learners also. Our real-time experienced expert trainers are the main pillar of our organization and responsible for delivering the outstanding online sessions. The features of our ETL testing training:
  •          Flexible sessions
  •          100% quality training by expert trainer
  •       Latest technologies are used in every online session to deliver effective and interactive online training
  •           We provide high quality and structured digital study materials
  •          Structured course content
  •          Trainers have minimum 5-7 years real-time experience and they also have training expertise
  •          We provide 24 hours support to the learners
  •          100% job oriented training


For detailed course content of our ETL testing online training call us or leave a mail to info@bigclasses.com. We will get back to you soon.
USA: +1-7323251626, India: +91-8008114040.

ETL Testing Online Training Content

Data WareHousing Concepts:

      What is Data Ware House?
      Difference between OLTP and DataWare Housing

Data Acquisition

      Data Extraction
      Data Transformation
      Data Loading

Data Marts

      Dependent Data Mart
      Independent Data Mart

Data Base Design

      Star Schema
      Snow Flake Schema
      Fact constellation Schema

SCD(slowly changing dimension)

      Type-1 SCD
      Type-2 SCD
      Type-3 SCD

Basic Concepts in SQL

    Overview of ETL Tool Architecture
    White Box and Black BOX Testing Functionality on Different Transformation Rules

Data Ware House Life Cycle

Different Types of Testing Techniques in ETL

      Minus Queing
      Count  Queing

  ETL Testing Concepts

1.Introduction

       What is use of testing
       What is quality & standards
       Responsibilities of a ETL Tester

2.Software development life cycle

       Waterfall model
       V-model
       Agile model & methodology
       Prototype model
       Spiral model

3.Testing methodologies

       White box testing
       Black box testing
       Grey box testing
       ETL Testing Work Flow Process
       How to Prepare the  ETL Test Plan
       How to design the Test cases in ETL Testing.
       How to reporting the Bugs in ETL Testing ?
       ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
       How to detect the bugs through database queries
       ETL Performing Testing & Performing Tuning

Projects
Projects on Different Domains(Banking , Health Care, Telecom , Insurance)