Search in
Courses Providers, List Your Courses for FREE
Menu
Subjects Covered & Categories
Learn: Extract, Transform and Load (ETL)

Category: Data Integration, BI & Analytics


Basic Details
Medium of instruction:English
Overview, Content & Syllabus

DataWare Housing 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)


Course Schedule & Price
Online
When Duration Where Remarks Price

No attendance for this course
Not Specified Study Online (on your computer) Course Duration : 30 Hours Price On Request

Venues (Locations)
Hyderabad, Ameerpet (Head Office):- #402, 4th Floor, Koushik Sai Residency Srinivasa Nagar Colony(East) Ameerpet, Hyderabad - 500038, Andhra Pradesh, India


About Course Provider

Big Classes


BigClasses.com is been into the IT market since a decade. We have started our career 10 years back as a class room training provider. After 5 years in the classroom training, as a part of expansion in 2008, we have moved to online training. We are offering the services globally with local and international standards with real time exposure. Now, after 10 years of expertise in software training, we are one of the best online training service portals of the industry. This shows our standards and commitment towards the software learners.

Since inception of BigClasses.com, it has evolved into a cherished and most reliable retail and Corporate Training Company.

BigClasses.com Training is one training institute where online interactive training is a common experience and many students in the past have learnt, mastered, got certified and landed excellent jobs on their way to their careers. Our training takes place with well-prepared training materials. We provide documentation and the best interview preparation materials for learners.

BigClasses.com has access to a faculty of esteemed and highly qualified consultants to deliver the courses. These instructors are not in any way academics, but rather specialists actively involved in consulting to business in their particular fields. This gives the learners a fuller insight of the needs and as well as knowledge about actual and future trends in the market, and makes the courses extremely practical and relevant.

We don’t just give training and leave you on your own but support you even after you get into the job. We are providing web based online training in major IT Courses, where you can sit at home in front of the system and learn without travel or relocate during the training program. You can practice exercises and real-time projects which are given by our esteemed instructors.

Training is conducted by experienced and certified Instructors. Prestigious clients are included in our Clientele list and 100% Successful placement for excellent candidates.

BigClasses.com Institute is an online provider of IT technologies training products for individual and for corporate groups our training manuals and programs are designed to be used in a self-study or home based training environment. This allows any student the ability to learn at their own pace and on their own schedule.

Self-paced training is a very effective method of training and can be used with any schedule and with no previous experience. Effective results can be achieved in as little as 15 minute blocks of time not hours or days as is common with seminars and schedule courses.

All our materials are available with instant download which means you can get started on your training within minutes. The result is that you can show noticeable improvement in less than a day with our training Bigclasses.com.

Our materials are designed to be used in a self-study or home based environment so anyone can fit this training into any schedule no matter how busy it may be. Self-study also allows an individual the ability to train at their own pace and not have to worry about missing any concepts or being forced to proceed too slow like what might happen in a class or schedule group class.

We are dedicated to providing the very best in Bigclasses.com training while providing quality training at affordable prices. Our goal is to product training that is within the budget of anyone who desires to improve their IT skills.

Corporate Group Training: For companies or large groups who wish to provide quality Customer Service training for their employees, Bigclasses.com online training Institute is proud to announce their Corporate! Under our Corporate Training Program, we offer our Training package at group rates. This course encompassing 6 training modules covering both basic fundamentals and advanced techniques.

Bigclasses.com Training Certificate Program: A complete course in Bigclasses.com Training from Basic fundamentals through advanced skills, this complete course offers a single source for all your requirements and needs. Each module is designed as either a stand lone module or as part of a complete series so the student can target their most pressing needs first for maximum benefit. Upon successful completion of the program and the passing of a short test, a full color Certificate of Completion will be issued to the student.

Browse similar courses by category


Subscribe & get details about interesting courses & events free in your mail