We Offer Training

• Ascential DataStage.
• Business Objects - Data Integrator.

• Business Objects – Reporting.
• MicroStrategy.

• SAP Business Warehousing.

QA Automated tools:

• Win Runner, Load Runner
• Test Director
• Full Quick Test Professional (QTP)
• Rational Test Manager

Others:

• Software QA processes
• QA Life cycle
• Creating Test Cases, Plans and Scripts
• Testing ( Manual, Automated, Unit,
• Integration, Regression, Black Box etc)
• QA Methodologies - Waterfall, Agile and V-MODEL
• SQA Standards
• QA/QC Difference,
• Verification/Validation

• Oracle
• Teradata

• UNIX
• Mainframes
• Software Development Life Cycle
• Requirements Gathering Process
• Documentation and Standards used in Projects
• Data Modeling
• Other Tools used in Project Development Environment
• Miscellaneous

Datawarehousing basics

Types of Systems

• OLTP
• OLAP (ODS, DW, DM)

Introduction to Data modeling for Data warehouse.

ER – Modeling

Dim – Modeling

Conceptual Data Model

Logical Data Model

Physical Data Model

STAR schema

Snowflake schema

Database concepts

RDBMS

• Database objects
• Normalization forms
• Constraints
• SQL
• DDL
• DML
• DCL
• Other Functions
• PLSQL
• PLSQL Block
• Data types
• Procedures
• Functions
• Packages

ETL – Tool (Ascential DataStage)

Introduction to ETL procedures.

Datastage Architecture for Parallel

• Parallelism
• Data Partitioning
• DS-Server / Parallel tool
• Designer
• Manager
• Director
• Administrator
• Server Stages
• Parallel Stages
• Sequencer Stages
• Shared Containers

DS Routines & Functions

• DS-Jobs – development
• DS Jobs in Real Time Environment
• Basic / DSjob – Commands
• DS-Universe
• Development Standards
• Best Practice's

Project Work

• Identifying Dimensions, Facts from source data.
• Creating Dimension datamodel.
• Creating Database for datawarehouse.
• Developing ETL jobs using Datastage.
• Loading Datawarehouse from different sources.