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.
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
