iClass Chennai center - etl testing Training in Chennai

Training classes in chennai by working professionals

training in chennai by experienced trainers

iclass certification training classes in chennai

iclass chennai offers certification training courses

ETL Testing Training Chennai Benefits

Real Time Trainers
100% Placement
Small Training Batch
Flexible Timings
Practical Guidance
Excellent Lab Facility
ETL Testing Resume Preparation
Hands on Experience
etl testing Certification Support

etl testing Training Support

Enquiry : +91 8099 902 902

Enquiry : +91 8099 620 260

ETL Testing training Chennai Reviews

ETL Testing training Chennai

Reviewed by

Aaradhya

on 2014-04-09

Friends, This is Aaradhya from Chennai, got trained in ETL Testing in iClass training got ETL Testing job in 60 days. thank you.

Rating:

3/5

ETL Testing training Chennai

Reviewed by

Nandakumar

on 2014-03-25

good trainer for etl testing and very good teaching.

Rating:

4/5

ETL Testing Training in our Branches

Best ETL Testing training institute in chennai

ETL Testing Training in Chennai & Best Data warehousing ETL testing Training Institute in Chennai

4 out of 5 based on 7 ratings. 2 user reviews.

iClass Chennai provides real-time and placement focused etl testing training in chennai . Our data warehousing etl testing course includes basic to advanced level and our etl testing course is designed to get the placement in good MNC companies in chennai as quickly as once you complete the etl testing certification training course. Our etl testing trainers are data warehousing etl testing certified experts and 6 years experienced working professionals with hands on real time multiple ETL Testing projects knowledge. We have designed our etl testing course content and syllabus based on students requirement to achieve everyone's career goal.

iClass Chennai offers etl testing training with choice of multiple training locations across chennai. Our data warehousing etl testing training centers are equipped with lab facilities and excellent infrastructure. We also provide data warehousing etl testing certification training path for our students in chennai. Through our associated etl testing training centers, we have trained more than 144 etl testing students and provided 78 percent placement. Our data warehousing etl testing course fee is value for money and tailor-made course fee based on the each student's training requirements. etl testing training in chennai conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.

ETL Testing training course content and Syllabus in Chennai

ETL Testing Course Content

Oracle Basics & Concepts

DBMS
RDBMS
DBMS vs RDBMS
Why Database Required
Different types of databases and difference
ASCII vs UNICODE
PL/SQL Basics
Oracle Architecture
Diff B/W Database & Files
OLTP
OLAP, ROLAP, MOLAP
METADATA
DDL,DML,DCL
BASIC ADMIN ACTIVITIES
DATATYPES
TABLES
SQL ,SUB QUERIES,CORELATED SUB QUERY
INNER QUERY,OUTER QUERY
FUNCTIONS AND TYPES AND IMPORTANCE
JOINS AND DIFFERENT TYPES
VIEWS n MATERIALIZED VIEWS
INDEX
CONSTRAINTS
REFERENTIAL INTEGRITY
PARTITIONING
PERFORMANCE TUNING
DIFFERENT TYPES OF TECHNIQES
DATABASE SCHEMA

DWH Concepts

WHAT IS DWH ?WHY WE REQUIRE THAT ?
DWH ARCHITECTURE
DATA MART and TYPES
DM vs DWH
DATA CLEANZING
DATA SCRUBING
DATA MASKING
NORMALIZATION
ODS
STG AREA
DSS
Diff B/w OLTP vs ODS,OLAP vs DSS
DIMENTION MODELING
DIMENSIONS
FACTS
AGGREGATES
DWH SCHEMA designing
STAR SCHEMA,SNOWFLAKE SCHEMA,GALAXY SCHEMA,FCS
SLOWLY CHANGING DIMENSIONS
SCD TYPE1,TYPE2,TYPE3
INITIAL LOAD
INCREMENTAL LOAD
FULL LOAD
CDC- change data capture

ETL Testing Concepts

Introduction of ETL-Extract,Transform,Load
ETL TOOLS and Diff Types of ETL Tools
ETL ARCHITECTURE
ETL TESTING AND WHY WE REQUIRE
DIFFERENT ETL TOOLS ARCHITECTURES
SDLC and Methods/Models
STLC and Methods/Models
SDLC vs STLC
Reverse Engineering
QC(Quality Center and BugZilla)
Roles and Responsibilities
Minus,Duplicate,Count,Intersection
Detect Defects
Defects Logging and Reporting
How to prepare Queries very quickly with the help of mapping
Performance Tuning and Performance Testing,Report Testing,UI Testing
Quality and different standards that tester should follow,Why?
Testplan Preparation
Testcases Preparation
Preparation of Test data
Process Of ETL Testing

Testing Concepts

Whitebox Testing
Blackbox Testing
Gray Box Testing
Regression Testing
Smoke Testing vs Sanity Testing
User Testing
Unit testing
Intigration testing
Module testing
System testing
UAT

ETL Tool and Testing

Data Extract
Data Transform
Data Load
Import Source
Import Target
Mappings,Maplets
Workflows,Worklets
Transformations,Functionalities,Rules and Techniques
Import and Export
Coping and Rules
Queries Preparation based on Transformations
Importance of ETL Testing
Creating of Mappings,Sessions,Workflows
Running of Mappings,Sessions,Workflows
Analyzing of Mappings,Sessions,Workflows
Tasks and Types

Practice:

Testing scenarios, creation of test cases and scripts
Test case execution and defect tracking and reporting
Preparation of Test data
Practice ETL Testing with Real Time Scenarios and FAQ�s

ETL Testing training duration in Chennai

Regular Classes( Morning, Day time & Evening)

Duration : 3 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

Duration : 4 Weeks

Fast Track Training Program( 1+ hours classes daily)

Duration : within 1 weeks

ETL Testing trainer Profile & Placement

Our ETL Testing Trainers

More than 6 Years of experience in ETL Testing Technologies
Has worked on 6 realtime ETL Testing projects
Working in a MNC company in Chennai
Trained 144+ Students so far.
Strong Theoretical & Practical Knowledge
ETL Testing certified Professionals

ETL Testing (data warehousing etl testing) Placement Training in Chennai

More than 144+ students Trained
78 percent Placement Record
64 Interviews Organized
Placement Supported by InterviewDesk.com

ETL Testing training Locations in Chennai

Our Data warehousing ETL testing Training centers

Adyar
Ambattur
Adambakkam
Anna Nagar
Anna Salai
Ashok Nagar
Choolaimedu
Chromepet
Ekkattuthangal
Guindy
Kodambakkam
Madipakkam
Mylapore
Porur
Saidapet
T. Nagar
Tambaram
Vadapalani
Velachery
Villivakkam
Virugambakkam