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