Informatica Tutorial: Beginner to Expert Level

Become an expert in world's top Data Integration tool.

Created by: Sid Inf
Data/ETL Architect

What Will I Learn?

• Understand Data Warehouse Concepts and ETL Concepts
• Describe Informatica PowerCenter architecture & its different components
• Use PowerCenter 10x/9.x components to build Mappings, Tasks, Workflows
• Describe the basic and advanced features functionalities of PowerCenter 10.0/9.6 transformations
• Understand Workflow Task and job handling
• Describe Mapping Parameter and Variables
• Perform debugging, troubleshooting, error handling and recovery
• Learn different types of cache available and how to calculate cache requirement and implement session cache
• Execute performance tuning and Optimization
• Identify and explain the functionalities of the Repository Manager tool
• Identify how to handle services in the Administration Console
• Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
• Gain insight on ETL best practices using Informatica
• Understand all the basic interview questions for all the transformations and real time scenarios

Requirements

• Knowledge of basic SQL
• Basic Unix Commands

Target audience

• Software Developers
• Analytics Professionals
• BI/ETL/DW Professionals
• Mainframe Developers and Architects
• Individual Contributors in the field of Enterprise Business Intelligence