514 312 2383 | info@montrealcollege.ca |
French
|
|
| S.No | Job Title | National Average Salaires |
|---|---|---|
| 1 | Architects | $ 72,000 - $ 120,000 |
| 2 | Business Analysts | $ 50,000 - $ 100,000 |
| 3 | Business Intelligence Analyst | $ 65,000 - $ 93,500 |
| 4 | Data Analyst / Report Writers | $ 60,000 - $ 85,250 |
| 5 | Package Software Specialist - ERP | $ 79,000 - $ 120,000 |
| 6 | Web 2.0 Developers | $ 55,750 - $ 81,000 |
| 7 | Systems / Network Administrator | $ 64,000 - $ 75,000 |
| 8 | Systems and Application Integrators | $ 40,000 - $ 100,000 + |
This instructor-led course exposes the core features of Informatica PowerCenter 8 through lectures, hands-on exercises and workshops. In addition to gaining tremendous insight into the data integration platform, students will be exposed to Informatica Velocity Best Practices.
Working professionals who wish to gain expertise in PowerCenter Development.
After the completion of this course, you will be able to:
• Data Integration Concepts
• PowerCenter Components and User Interface
• Source Qualifier
• Expression, Filter, File Lists and Workflow Scheduler
• Joins, Features and Techniques I
• Lookups and Reusable Transformations
• Debugger
• Sequence Generator
• Lookup Caching, More Features and Techniques
• Sorter, Aggregator and Self-Join
• Router, Update Strategy and Overrides
• Dynamic Lookup and Error Logging
• Unconnected Lookup, Parameters and Variables
• Mapplets
• Mapping Design
• Workflow Variables and Tasks
• More Tasks and Reusability
• Worklets and More Tasks
• Workflow Design
Certificate of participation
This instructor-led course complements and extends the PowerCenter 8 Level I Developer course. The course is
intended for developers with more than six months of PowerCenter 8 experience. Topics covered include: Advanced Mapping Techniques; Advanced Workflow Techniques; Transaction Control; Workflow Recovery; Error Handling; Performance Tuning; Repository Reporting; Memory Allocation; and Pipeline Partitioning.
This course is designed for PowerCenter developers who have taken the PowerCenter Level I Developer course (or equivalent) and have at least six months' experience working with PowerCenter.
After the completion of this course, you will be able to:
• Describe the PowerCenter 8 architecture
• Given a mapping specification, build a corresponding mapping, using the techniques including: variables and parameter
• files; dynamic caching; data-driven and incremental aggregation; de normalization; user-defined and custom functions
• Control workflow behavior with restart junctions, control tables, workflow variables, and dynamic scheduling
• Configure workflows for recovery
• Use transaction control to manage writing to targets
• Configure PowerCenter’s handling of data errors
• Manage objects in one or more repositories
• Configure workflows for recovery
• Use transaction control to manage writing to targets
• Configure PowerCenter’s handling of data errors
• Manage objects in one or more repositories
• Optimize PowerCenter’s memory usage
• Using a standardized methodology, optimize the performance of PowerCenter in your environment
• Use partitions and stages to improve performance
Certificate of participation
This instructor-led course is designed for participants to learn the fundamentals of administering PowerCenter Servers and content.
Working professionals who wish to gain expertise in PowerCenter installation, administration and deployment.
After the completion of this course, you will be able to:
1. Platform components and Service Architecture
2. Nomenclature
3. Repository Service
4. Installation
5. Security
6. Object sharing
7. Repository organization and migration
8. Database connections
9. Workflow Manager Configuration
10. Workflow properties
11. Running and monitoring workflows
12. Workflow and task errors
Certificate of participation
Our Instructor led classrooms are dedicated to give each student individual attention Learn More
Join Our Training Program and Claim 36% Educational Tax Incentive.
Learn More
Easy To Reach - Montreal Downtown Location.
Learn More
Come and Join 2 months before training start date and save10% off from regular Price. Learn More