WhatsApp Contact +971 54 326 9878
Phone Icon +971 4 385 4500
CounselTrain
Call Email Facebook Instagram Linkedin
Featured Image

Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training

  • 4.8(5,927 Rating)

Duration

3 days

Upcoming Batch

11 May 2026

Batch Options

4 hours & 8 hours

Language

English / Arabic
Overview Schedule Dates Course Content FAQs

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 Audiance

  • 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.
This course includes:
  • Soft copy of Courseware
  • Certificate of Course Completion
  • Experienced and Professional Trainer
  • Lab and Exercises During Training
  • Sample Questions for Exam Prepration
  • Mock Test on the Last Day of Training
  • Exam Registration Guidance
  • 5-Star Training Environmment
Request More Information
Name

Schedule Dates

11 May 2026 - 13 May 2026
Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training
17 August 2026 - 19 August 2026
Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training
23 November 2026 - 25 November 2026
Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training
01 March 2027 - 03 March 2027
Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training

Course Content

  • Course Objectives

  • Using local variables: self and forward references

  • 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)

  • Using a Joiner with the sorted input property

  • Using dynamic caching
  • Pipeline lookups
  • Lab: Self-join, Dynamic Lookup and Denormalizing

  • Using the Sequence generator transformation
  • Using a trigger, GUID or update overrides

  • Calling stored procedures
  • Transaction Control transformation and commit points
  • Transaction scope

  • Advanced Parameter usage

  • 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

  • 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)

  • 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

  • Overview
  • XML definitions
  • Using XML sources and targets
  • Using the XML editor
  • Midstream XML transformations
  • Lab: Using XML

  • Infacmd
  • pmcmd
  • pmrep

FAQs

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.

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.

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.

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.

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.

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.

No related courses found.