Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training
Course Overview
The Advanced Boot Camp for Developers – Informatica PowerCenter 9.5.1 is an intensive, hands-on programme designed for experienced ETL developers and data integration professionals who want to deepen their expertise in enterprise-level data warehousing and integration solutions using Informatica PowerCenter.
This advanced training focuses on performance optimisation, complex transformations, workflow automation, error handling, and real-world ETL architecture design. Participants will work with production-style scenarios, enabling them to design, build, optimise, and troubleshoot high-performance data integration solutions across heterogeneous systems.
The course goes beyond basic mappings and introduces advanced PowerCenter components, including reusable transformations, advanced lookup strategies, session tuning, pushdown optimisation, and metadata-driven ETL frameworks. Special emphasis is placed on scalability, reliability, and best practices required in large enterprise data environments.
By the end of this boot camp, learners will have the confidence to design robust ETL pipelines, optimise existing workflows, and handle complex data integration challenges commonly faced in banking, healthcare, telecom, retail, and enterprise analytics projects.
By completing this advanced boot camp, participants will be able to:
- Design and implement complex ETL architectures using Informatica PowerCenter 9.5.1
- Optimise mappings and sessions for high-volume data processing
- Implement advanced transformations and reusable objects
- Apply performance tuning techniques for sources, targets, and workflows
- Handle error logging, recovery, and restartability in production environments
- Use pushdown optimisation and partitioning effectively
- Develop scalable and maintainable ETL solutions aligned with enterprise standards
- Troubleshoot performance bottlenecks and data issues efficiently
Target Audience
- Participants should have hands-on experience with Informatica PowerCenter, including basic mappings, workflows, sessions, and common transformations. This is not a beginner-level course. Prior exposure to SQL, relational databases, and data warehousing concepts is strongly recommended to fully benefit from the advanced topics covered.
Course Content
13 modules · 52 topics01Course Introduction1 topic
- Course Objectives
02Mapping Techniques – local variables1 topic
- Using local variables: self and forward references
03Mapping Techniques – Pivoting data4 topics
- Using the Normalizer transformation (level of occurs, generated keys, examples)
- Normalizing flat file outputs
- Denormalizing with unconnected Lookups
- Denormalizing with the Aggregator (conditional clause and local variables)
04Mapping techniques - self-joins1 topic
- Using a Joiner with the sorted input property
05Mapping Techniques – Lookup Transformation3 topics
- Using dynamic caching
- Pipeline lookups
- Lab: Self-join, Dynamic Lookup and Denormalizing
06Mapping Techniques – Surrogate Keys2 topics
- Using the Sequence generator transformation
- Using a trigger, GUID or update overrides
07Mapping Techniques – other3 topics
- Calling stored procedures
- Transaction Control transformation and commit points
- Transaction scope
08Advanced Parameter usage1 topic
- Advanced Parameter usage
09Mapping Templates6 topics
- Slowly changing dimension updates (type 1, 2, 3 and mixed)
- Lab: dimensional updates
- Data validation and error trapping
- Comparing the contents of two tables and extracting differences
- Building parameter files
- Lab: parameter files
10Performance Tuning15 topics
- Understanding PowerCenter’s architecture
- Getting baseline numbers
- Using performance counters
- Identifying bottlenecks
- Tuning the target and source components
- Tuning blocking transformations
- Tuning Lookup transformations
- Lab: tuning the mapping
- Tuning the session, caches and memory
- Using session partitioning
- Tuning the workflow
- Running multiple instances of the same workflow
- Running a session or a workflow on a grid
- Lab: session partitioning
- Using PushDown optimization (optional)
11Mapping Templates6 topics
- Slowly changing dimension updates (type 1, 2, 3 and mixed)
- Lab: dimensional updates
- Data validation and error trapping
- Comparing the contents of two tables and extracting differences
- Building parameter files
- Lab: parameter files
12Using XML6 topics
- Overview
- XML definitions
- Using XML sources and targets
- Using the XML editor
- Midstream XML transformations
- Lab: Using XML
13Review of command line utilities3 topics
- Infacmd
- pmcmd
- pmrep
Schedule Dates
4 upcoming batches| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 23 November 2026 - 25 November 2026 | 3 Days | 4 hours & 8 hours | English / Arabic | |
| 01 March 2027 - 03 March 2027 | 3 Days | 4 hours & 8 hours | English / Arabic | |
| 07 June 2027 - 09 June 2027 | 3 Days | 4 hours & 8 hours | English / Arabic | |
| 13 September 2027 - 15 September 2027 | 3 Days | 4 hours & 8 hours | English / Arabic |
Can’t find a suitable date? Request a schedule that fits your team.
Request More InformationFAQs
Who should enrol in this Advanced Informatica PowerCenter training?
This course is specifically designed for experienced ETL developers, data engineers, BI professionals, and technical consultants who already have working knowledge of Informatica PowerCenter. It is ideal for professionals involved in enterprise data warehousing, analytics, or large-scale data integration projects who want to enhance performance, scalability, and architectural skills rather than learning basic concepts.
What advanced topics are covered in this boot camp?
The training covers advanced topics such as complex transformations, reusable mapplets, advanced lookup optimisation, dynamic partitioning, pushdown optimisation, session and workflow tuning, error handling strategies, recovery mechanisms, metadata-driven ETL design, and performance troubleshooting. Real-world use cases are integrated throughout the course.
Does the course include real-world and production-level scenarios?
Yes. The boot camp is structured around real-world enterprise scenarios. Learners will work on production-style ETL challenges, including high-volume data loads, incremental processing, performance bottlenecks, and error recovery situations commonly encountered in live environments.
Will I learn best practices for enterprise ETL architecture?
Absolutely. The course emphasises industry best practices for designing scalable, maintainable, and reusable ETL architectures. Topics include naming conventions, modular design, reusable components, metadata management, and strategies for building future-proof data integration solutions.
How will this course help in real job roles and career growth?
Completing this advanced boot camp strengthens your ability to handle complex ETL projects, optimise existing systems, and contribute at a senior developer or lead level. The skills gained are highly valued in roles such as Senior ETL Developer, Data Engineer, BI Consultant, and Data Integration Architect.
What makes this boot camp different from standard Informatica training?
Unlike standard courses that focus on basic features, this boot camp is intensive, advanced, and practical. It concentrates on real-world challenges, performance optimisation, and enterprise architecture, enabling participants to move beyond implementation and start thinking like ETL architects and senior developers.
Flexible Training Options to Meet Your Needs
Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.
Select the method that best suits your needs.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
Learn moreHighlights
Classroom Training
Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai.
Learn moreHighlights
Onsite Training
Learn a customised curriculum in your workplace to ensure the most impact and team participation.
Learn moreHighlights
Overseas Training
Participate in our international training sessions and improve your abilities with world-class instructors.
Learn moreHighlights