IICT Chromepet Reviews | ETL Training in Chennai at IICT, Chennai

IICT Chromepet Reviews about ETL Training in Chennai 

ETL Testing Training

IICT Chromepet is the No.1 Software IT Training Institute in Chennai for ETL Testing and trainer who is handling our ETL Testing training is having around 10+ years of IT Experience. 

Data warehousing Technology is the leading technology in the market and there are many number of tools available in the market especially ETL Training, Informatica, Cognos, Datastage, Abnito, Qlikview etc are available at IICT. 

Our training is offered by the experts who have vast experienced people in leading IT Sectors. Our training review is shown below:

IICT Academy Reviews are shown below:

IICT Academy 

4.7 out of 5 based on 189 ratings.

189 user reviews.

Justdial 

Yet5 

Facebook 

Google+ 

Sulekha 

Asklaila 

Glassdoor 

Thinkvidya 

Video Reviews 

Youtube 

100% hands on real time practical training are offered by IICT Experts. We do provide hands on training with job assistance at IICT.

Our trainers cover following topics in ETL Testing :

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