Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

ETL TESTING Course Details
 

Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Dec 21st @9:00PM

Faculty: Mr. Ravinder (7+ Yrs of Exp,..)

Duration: 60 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91- 9246212143, 80 96 96 96 96

 Syllabus:

ETL TESTING

High Level Course Content

  • Structured Query Language (SQL)
  • UNIX and Shell Scripting Basics
  • Manual Testing (Software Testing)
  • Data WareHousing Concepts
  • ETL Tool (Informatica)
  • JIRA (Defect Logging and Effot Logging)
  • One Project with Detailed Explanation

Structured Query Language

  • History of File System
  • DB, DBMS, RDBMS
  • RDBMS List
  • Oracle Datatypes
  • SQL Commands (DDL, DML, TCL, DCL, DRL)
  • Operators:
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Set Operators
  • Special Operators

Structured Query Language

  • Functions:
  • Single Row Functions
  • Multi Row Functions
  • Conversion Functions
  • General Functions
  • NVL Functions
  • Joins:
  • Oracle 8i Joins
  • Oracle 9i Joins
  • Inner Join
  • Left outer Join
  • Right outer Join
  • Full outer Join
  • Cross Join
  • Self Join

Structured Query Language

  • SELECT QUERY FLOW
  • SQL Constraints
  • DATA MODEL
  • Entity Relationship Model
  • What is Schema ? Schema Types
  • Fact Tables and Dimension Tables
  • Analytical Functions
  • Views and Types
  • Indexes In SQL
  • Decode and Case Functions
  • Date format functions
  • SubQuery
  • Presudo Columns

Unix Syllabus

  • What is OS? Types of OS?
  • Why UNIX/Linux?
  • Unix Commands Basics
  • Unix Shell scripting Basics and bit advanced

Data WareHousing Concepts

  • What is Datawarehouse?
  • Need of Data warehouse?
  • Introduction to OLTP,ETL,OLAP Systems
  • Differences between OLTP vs OLAP
  • Data warehouse Architecture
  • Data Marts
  • ODS (Operational Data Store)
  • Dimensional Modeling
  • Difference between Relation and Dimensional modeling
  • Star Schema and Snowflake Schema
  • What is Fact Table
  • What is the dimension Table
  • Normalization and Demoralization

Informatica Power Center Components:

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power center Admin Console
  • Informatica Concepts:
  • Informatica Architecture
  • Transformations
  • SCDs
  • Sources:
  • Working with Database
  • Working with Flat files
  • Targets:
  • Working with Database

ETL Testing Concepts

  • Manual Testing Concepts
  • SDLC
  • STLC (Complete Flow Explanation with Documentation)
  • ETL Testing Types:
  • Data Completeness
  • Data transformation
  • Data Quality
  • Integration testing
  • Initial Load/Full load and Incremental Load

Additional Content…..

  • Agile Methodology
  • Project Architecture
  • Data flow
  • Test Planning Document
  • Test Scenarios Document
  • Test Cases Document
  • ETL Testing Interview Questions with Explanation Document