Durations :-  45 Hrs       Fees :- $ 1000

 

ETL – Informatica Testing Course Contents

 

Data Warehousing Concepts

 

ü  Data warehousing Architecture (Concepts and Design).

ü  Introduction to OLTP, ETL and OLAP Systems.

ü  Dimensional Data Modeling

ü  Data Marts and ODS

ü  Fundamental roles of dimension and fact tables, Hierarchies and Summary/Aggregated Tables.

ü  Star Schema and Snowflake Schema

ü  Introduction to OLAP Technologies (ROLAP, MOLAP, DOLAP and HOLAP)

ü  Software development life cycle (ex: An Agile Methodology)

 

Informatica and DataStage Concepts and Overview 

 

ü  Informatica  and DataStage Architecture

 

ü  PowerCenter Tools

o   Designer

o   Repository Manager 

o   Workflow Manager 

o   Workflow Monitor

ü  Introduction to datastage server components

o   Repository

o   Datastage server

o   Datastage package installer

ü  Introduction to datastage client components

o   Datastage administrator

o   Datastage designer

o   Datastage director

o   Datastage manager (removed in latest version)

 

ü  Transformations

o   Source Qualifier

o   Expression

o   Joiner

o   Lookups

o   Sequence Generator

o   Router

o   Update Strategy

o   Sorter Transformation

o   Aggregator Transformation

ü  Sources and Targets 

o   Working with Relational Targets 

o   Working with Flat file Targets 

ü  Mappings 

ü  Mapplets 

ü  Sessions

 

ETL Testing

 

ü  What is use of ETL testing?

ü  Responsibilities of ETL Tester.

ü  Testing methodologies and Type of Testing

o   White box Testing.

o   Black box Testing.

o   Regression Testing.

o   Integration Testing

o   Performance Testing

o   User Acceptance Testing

o   ETL Testing / Work Flow Process.

ü  Design the Test Plans

ü  Design the Test Cases

ü  Testing through Database Queries

ü  Defect Tracking and Report

ü  Performance Tuning.

 

 

Oracle SQL Concepts:

 

ü  Basic Concepts in SQL (DDL,DML and TCS Statements).

ü  Writing SQL Queries with various functions

ü  Working and various Joins.

ü  Working on Sub Queries.

ü  Performance Tuning Tips & Tricks.

 

OLAP Tool

 

ü  Concepts of OLAP Tools

ü  Business Objects Reporting Tool

 

 

For Inquiries you can walk-in to our Co-operate office (485 US Highway 1 South, Building C, Suite # 105,Iselin,NJ-08830) between 9 am to 6 pm.

Please Email to Training@VForceInfoTech.com OR Call On 732-218-5912 Ext 7008/7010