Duration : 8-9 Weekends / 60-70 hrs

Trainer : 9+ yrs exp in IT Industry working in CMM Level 5 Company

 Description :
ETL basically stands for Extract Transform Load – which simply implies the process where you extract data from Source Tables, transform them in to the desired format based on certain rules and finally load them onto Target tables. There are numerous tools that help you with ETL process – Informatica, Control-M being a few notable ones.

ETL Testing implies – Testing this entire process using a tool or at table level with the help of test cases and Rules Mapping document.

In ETL Testing, the following are validated :

1) Data File loads from Source system on to Source Tables.
2) The ETL Job that is designed to extract data from Source tables and then move them to staging tables. With Transform process.
3) Data validation within the Staging tables to check all Mapping Rules / Transformation Rules are followed.
4) Data Validation within Target tables to ensure data is present in required format and there is no data loss from Source to Target tables.

Contents :

Below Topics to be covered with Theory and Practical as Real time in this Training course.

  1. Operating System : Unix/Linux related to ETL Testing
  2. Automation Script : Shell Script Basics
  3. Database : DBMS, Oracle SQL
  4. Concepts : Datawarehouse, ETL
  5. ETL Tool : Informatica as per ETL testing Scope
  6. Testing Concept : High Level Software Testing Concept
  7. Practical : Live Scenarios, Assignments
  8. Defect Management Tool : QC
  9. Domain Knowledge : Networking, Banking and Telecom Basics

Who should attend :
àIT professionals and Freshers who are interested to explore career in Datawarehouse, ETL Testing, SQL, UNIX.

Additional benefits :

  • Interview Questions (FAQ)
  • Resume preparations for both Freshers and Experience
  • Real-time Scenarios examples and solution discussion
  • Assignments  
  • Domain Knowledge (Telecom, Banking, Network) discussion as per interview
  • Tie up with some Consultancies/Companies and Job assistance after Training.
  • We also provide you the Software, Study material, Question bank, Interview Questions, Lab Facilty.

Career Path :

After complete the Course  you’ll be able to attend the Interview and can build your career in below IT fields.

  1. Manual Testing with Domain Specific (Banking, Telecom, Networking)
  2. Datawarehouse Testing
  3. ETL Testing
  4. BI Testing
  5. Automation Testing using Shell Script
  6. Regulatory Report Testing
  7. Unix and/or  Database Testing
  8. Production Support  in Unix and/or  Database
  9. Unix Infra

Training Highlights :

Training will be for experienced as well as freshers. Training will be user friendly and will be more focusing on real time programs as per industry standards. We understand the money  you are investing in learning and hence we’ll learn you the best of  ETL/DWH/Unix/Database Testing knowledge. 

Please feel free to contact us and we would be glad to assist if you will have any queries.

Training  Syllabus

Module – I (Unix/Linux)

 

Chapter – 1 : Fundamental of UNIX
Overview of Operating System
UNIX Fundamentals

Features of UNIX
Different flavours of Unix

Chapter – 2 : General Purpose Utilities

Login Commands
Terminal Commands
Online Manual

Displaying Message

Disk related Commands

Other Useful Commands

 

Chapter – 3 : Files and Directories

Files, Directories and Sub-directories

Specifying Files with Pattern Matching

Managing Directories and Files

Splitting File Horizontally and vertically

Searching Files and Directory

cmp, comm, diff Command

Compressing and Archieving Files

Ln : Linking Files

 

Chapter – 4 : Redirection, Piping and Filter

What is Redirection

Types of  Redirection

What is Piping

Differences between Re-direction and Piping

What is Filter

Different Filter Commands

grep, sort, uniq, sed, awk

 

Chapter-6 : Basic File Attributes

Types of  Permission

Changing File Permission and Ownership

umask Command

Chapter – 7 : Processes

What is Process ?

Mechanism of Process creation

ps : Process Status

Running jobs in background

at and batch Command

fg, bg : Job Control Command

nice : Job execution with Low Priority

Positional Parameter

Kill Command

 

Chapter – 8 : Environment Variable

What is Environment Variable

Local and Global Variables

Important Environment Variables

Positional Parameter

 

Chapter – 9 : vi Editors

Different types of  Editors

Different modes of vi editor

Screen Control, Navigation, Cursor Movement in vi editor

Commands saving and exiting

Insert and Delete operation in vi

Searching for a pattern

Replace/Substitute

Joining Lines

Copy and Paste

Move and Delete

 

Chapter – 10 : Shell Script

Different types of shell

What is Shell Scripting

Shell scripting execution

Shell Variables and Parameters

Scripting and Programming Languages

Shell feature

Function

Quoting Mechanism

Decision Making

Loops

How to write and execute Shell Program

 

 

Module – II (Database/SQL)

 

How  to design frequently used testing queries to validate the data in source and target for both of the reasons Data Quality and Correctness to ensure that expected data came into the final and mediator target tables or not. 

 

  • Database Overview
  • DBMS, RDBMS, ORDBMS
  • Why Database Required
  • Different types of Databases and difference
  • Difference between Database & Files
  • Data Model
  • Normalization
  • SQL Overview
  • DDL,DML,DCL, TCL
  • Basic Admin activities
  • Datatypes
  • SELECT Statement
  • Restricting and Sorting Data
  • Aggregating Data using Group Functions
  • Creating and managing Tables
  • Manipulating Data
  • Sub queries, Correlated Sub query
  • Inner query, Outer query
  • Functions and types and importance
  • Joins and different types
  • Views and Materialized views
  • Index
  • Constraints
  • Referential integrity
  • Database Schema
  • Database Object
  • Set Operator
  • PL/SQL Basics

 

Module – III (Datawarehouse Concepts)

 

  • What is Datawarehouse ? Why we require that ?
  • DWH Architecture
  • DWH Characteristics
  • Data Mart and types
  • DM vs DWH
  • Data cleansing
  • Partitioning
  • Staging area
  • Metadata
  • OLTP, OLAP, ROLAP, MOLAP
  • Surrogate Key
  • Dimention Modeling
  • Dimensions
  • Facts
  • DWH Schema designing
  • Advantages of Datawarehouse
  • Star Schema, Snow-flake Schema, Galaxy Schema
  • Future Aspects
  • OBIEE/BI Overview

 


Module – IV (ETL Concepts)

  • Types of Source Files
  • Data Extraction
  • Data Transformation (Different Transformation rules)
  • Data Loading
  • Slowly Changing Dimension
  • SCD (Type-1, Type-2 and Type-3)
  • Introduction of ETL Tool
  • Overview of ETL Tool Architecture
  • ETL Tool Environment
  • Approaches of DW or ETL

Module – V (Advance Level Testing Concepts)

 

Chapter – 1 : Data Warehouse (ETL) Testing Process

  • Software Development Life Cycle (SDLC)
  • Software Testing Life Cycle (STLC)
  • Defect/Bug Life Cycle
  • Data Ware House (ETL) Test or Work Flow Process
  • ETL Testing Work Flow Process
  • ETL Testing Introduction
  • What is use of testing?
  • Responsibilities of an ETL Tester
  • Risks and Challenges of ETL Testing
  • Levels of Testing

 

Chapter – 2 : Data Warehouse (ETL) Test Preparation

  • ETL Testing Methodologies and Test Techniques
  • ETL Test approach
  • ETL Testing Work Flow Process
  • How to Prepare ETL Test Plan
  • How to design Test cases in ETL Testing.
  • DW (ETL) Test Environment Setup

Chapter – 3 : Documentation

  • BR/SR document
  • Testcase, Test Scenarios Preparation
  • Test Plan, Test Strategy preparation
  • Test Bed preparation
  • Test Summary, Status, Exit Report
  • Test data Creation

 

Chapter – 4 : Data Warehouse (ETL) Test Execution, Results and Report

  • How to perform DW (ETL) Testing.
  • Testing the Requirements and Functional Design
  • Different phases in DW (ETL) Testing
  • Data validation in Source and Target
  • How to apply Transformation rules in ETL Test execution.
  • How to detect the bugs through database queries

Chapter – 5 : Web Testing

  • Different types of testing
  • What is Web Testing ?
  • Different types of Web Testing
  • ETL Testing Entry Exit Criteria

 

Chapter – 6 : Quality Standard

  • What is Quality/Test Standards
  • Why Quality Standards Require
  • Quality Standards – ISO, CMM

 

Chapter – 7 : Estimation and Matrices

  • What is Test Estimation
  • Common Estimation Techniques
  • What is Matrices
  • Why Test Matrix is used
  • Different types of Test Matrices
  • Requirement Traceability Matrix (RTM)

 

Chapter – 8 : Agile Model

  • Different Software Development Models
  • Introduction to Agile Model
  • Advantages and Disadvantages
  • Sprint
  • Scrum
  • Agile vs Traditional

 

 

Module – VI (Informatica Power Center Tool)

 

  • How developers work on Power Center
  • Different components of Power Center
  • Tasks developed in different components 
  • Mapping, Session, worklet, Workflow, Mapplet
  • Tracing Level

 

Module – VII (Quality Center – QC)


Chapter 1: Introducing Quality Center
The Quality Center Testing Process
Starting Quality Center
The Quality Center Window

Chapter 2: Specifying Releases, Cycles and Requirements
Defining Releases and Cycles
Viewing Releases and Cycles
Defining Requirements
Viewing Requirements
Modifying Requirements
Converting Requirements

Chapter 3: Planning Tests
Developing a Test Plan Tree
Designing Test Steps
Copying Test Steps
Creating and Viewing Requirements Coverage

Chapter 5: Running Tests
Defining Test Sets
Adding Tests to a Test Set
Running Tests Manually
Viewing and Analyzing Test Results

Chapter 6: Adding and Tracking Defects
How to Track Defects
Adding New Defects
Updating Defects
Linking Defects to Tests
Creating Favorite Views