What will you learn in Informatica Certification Training Course
-
Grasp Informatica PowerCenter architecture and core components (Repository Service, Integration Service, Client Tools)
-
Design and develop ETL mappings using Source Qualifier, Lookup, Aggregator, Router, and other transformations
-
Build reusable mapping parameters, variables, and mapplets for scalable workflows
-
Implement workflow control: sessions, tasks, event-based triggers, and recovery strategies
-
Optimize performance with partitioning, pushdown optimization, and tuning best practices
-
Monitor and administer Informatica domains, repositories, and security
Program Overview
Module 1: Introduction to Informatica & Environment Setup
1 week
-
Topics: PowerCenter components, server vs. client installation, repository architecture
-
Hands-on: Install PowerCenter, configure repository and integration services, and connect via Designer
Module 2: Data Transformation & Mapping Development
1 week
-
Topics: Source definitions, target definitions, and transformation types (active vs. passive)
-
Hands-on: Create a basic mapping with Expression, Filter, and Sequence Generator transformations
Module 3: Lookup, Joiner & Aggregator Transformations
1 week
-
Topics: Static vs. dynamic lookup, sorted vs. unsorted input, join strategies, aggregate logic
-
Hands-on: Build mappings using Lookup to enrich data, Joiner for heterogenous sources, and Aggregator for rollups
Module 4: Workflow Creation & Control Tasks
1 week
-
Topics: Workflow Manager, sessions, command tasks, email tasks, event wait tasks
-
Hands-on: Design workflows with branching logic, parameter files, and event-based triggers
Module 5: Mapplets, Parameters & Variables
1 week
-
Topics: Creating mapplets, using parameters and variables for dynamic behavior
-
Hands-on: Build reusable mapplets and configure workflow parameter files for multiple environments
Module 6: Performance Tuning & Optimization
1 week
-
Topics: Pushdown optimization, partitioning strategies, cache sizing, optimizer hints
-
Hands-on: Analyze session logs to identify bottlenecks and apply tuning techniques
Module 7: Administration & Security
1 week
-
Topics: Domain vs. repository administration, user roles, folder-level security, connections management
-
Hands-on: Create and manage users/groups, assign roles, and secure folders and objects
Module 8: Advanced Topics & Capstone Project
1 week
-
Topics: Real-time data ingestion with PowerExchange, metadata reporting, recovery best practices
-
Hands-on: Design an end-to-end ETL solution with real-time source, transformations, and error handling
Get certificate
Job Outlook
-
Informatica skills are in high demand for Data Integration, ETL Developer, and Data Warehouse Architect roles
-
Widely used in finance, healthcare, telecom, and retail for enterprise-grade data solutions
-
Salaries range from $85,000 to $140,000+ based on experience and region
-
Expertise in Informatica complements careers in BI, analytics, and cloud data engineering
Last verified: March 12, 2026
