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
Specification: Informatica Certification Training Course
|
