• Address: Minneapolis, MN 55425 (map)
• Date Posted: 09/26/09
• Job Type: Full-time

DW, Informatica 8.x, Datastage V8 Training

New training batch starting from 3rd Oct, 17th Oct, 31st Oct

Join Twin Cities Training Group on Linkedin.com to get latest updates on jobs and training. NEW!

Now Available in a new facility with lab, remote access 24/7, day/evening sessions, classroom/live online training available. NEW!



Topics Covered in Data warehouse and Informatica 8.x





Datawarehousing

§ Datawarehouse lifecycle
§ Data Warehouse Architecture, Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design.
§ Extract, transform, and load (ETL)
§ Database Design (OLAP- MOLAP, ROLAP & HOLAP)





Informatica 8.x Tool

§ PowerCenter Architecture
§ Informatica Server, Repository and Client Installation & Configuration
§ Security, Server & Repository Management
§ Production Migration & Performance Tuning
§ Source Qualifier/ File Lists/ Workflow Scheduler/Reusable Transformations/ Debugger
§ Detailed Review of the Expression/ Filter/ Sorter/Aggregator/ Joiner/ Lookup/ Update Strategy/ Router/ Sequence Generator Transformations.
§ Source and Target Overrides/ Parameters and Variables/ Self-Join/ incremental Aggregation/ Dynamic Lookup Cache/ Mapplets/
§ Workflow Configuration and Techniques
§ Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets.
§ Performance tuning.
§ Creating and managing Repository


Topics Covered in Data warehouse and Datastage V8





Datawarehousing

§ Datawarehouse lifecycle
§ Data Warehouse Architecture, Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design.
§ Extract, transform, and load (ETL)
§ Database Design (OLAP- MOLAP, ROLAP & HOLAP)





Datastage V8 Tool

§ Introduction to Datastage – Deployment, Administration console, Designer, Director, Administrator
§ Combine data using lookup, join, and merge stages
§ Create jobs that read from and write to sequential files
§ Make jobs that read from and write to a relational database using the connector stages
§ Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
§ Conduct searches and impact analyses
§ Produce job reports
§ Construct DataStage users
§ Administer the DataStage environment
§ Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets.
§ Performance tuning.
§ Creating and managing Repository
§ Designing the ETL (Extract, Transform & Load) Functions


Call on 651-222-9922 or email seema@itupdates.com to get a detailed course content.



Training Features

Free career counseling based on your education and industry experience.
Instructor led Training.
Lab exercises for each session.
Training available in live online or classroom training.
Day and evening training sessions available. – New!
New facility with labs and remote access 24/7- New!
Instructor support provided after training.
Training material constantly updated to remain competitive
Unlimited Training as many times as you want, till your confident enough to face interviews.
On Job and interview support.
Case Studies of our clients in various popular domain – client specific training
Industry experienced instructors, to give you Real Time solutions.
Full assistance in Placement.
On-going support for at least a year after your training.
Lifetime of notes, tools and other necessary material.
Complete refund of training fee 2 months after the candidates secures a project while working with us.

Total training hrs : 80hrs (40 Hrs of Classroom Training + 40 Hrs Take home assignment & Lab Hrs)

Weekday, weekend and combination of both classes are available.

In class training locations available in Minneapolis and St Paul area.

Contact Details: Email Seema at seema@itupdates.com or call at 651-222-9922 for further info. Please put your contact detail, location and Training Options (Class room or online) in the mail along with best time to call.

Visit www.instituteusa.com for more information

™Make you COMPETITIVE.