ETL Testing Training in BTM Layout, Bangalore

Best ETL Testing Training in BTM Layout with Placement Assistance


ETL Testing Training

TecMax is one of the leading ETL Testing Training Institute in Bangalore. Certified experts at TecMax are real-time consultants at multinational companies and have more than 5+ years of experience in ETL Testing Training. Our Trainers have conducted more than 200 classes and have extensive experience in teaching ETL Testing in most simple manner for the benefit of sudents.

We have advanced lab facilities for students to practice ETL Testing course and get hands-on experience in every topics that are covered under ETL Testing Training. In the presence of ETL Testing Trainer, students can execute all the techniques that has been explained by the instructor. Course Material for ETL Testing is specifically designed to cover all the advanced topics and each of the module will have both theory and practical classes. ETL Testing Batch Timings at TecMax are flexible and students can choose to join the batch as per their requirements. We have a batch starting every week for ETL Testing for regular students. Weekend batches and fast track batches for ETL Testing training can be arranged based on the requirement. 

All our students will get placement assistance in ETL Testing after successfully completing the ETL Testing training from our institute. We are committed to provide high-quality training and provide assistance to get you the right job.


ETL Testing Training Course Content

ETL Testing training course content and Syllabus in Bangalore
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
Test cases 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
Integration 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



Quick Enquiry


ETL Testing Reviews

Tecmax

4.9 out of 5 based on 11 Reviews



TECMAX © 2017 | All Rights Reserved
i