Course Syllabus
Introduction to Informatica and Basics
Understanding Informatica: Advantages over other coding technologies.
An overview of ETL.
Exploring Informatica's architecture and its main components: Server, Client, and Server Components.
Step-by-step guide to Informatica installation.
Familiarising with basic Unix commands and shell scripting.
Introduction to Data Warehousing: Data Mart, Data Modelling, Star Schema vs. SnowFlake Schema, and Fact Tables.
Classification of Dimensions and their Types.
Introduction to Informatica Administration
Overview of Informatica PowerCenter architecture
Roles and responsibilities of an Informatica Administrator
Understanding the Informatica domain and node architecture
Installing and Configuring Informatica
Pre-installation requirements and system considerations
Step-by-step installation of Informatica PowerCenter
Configuration of repository services, integration services, and other components
Post-installation tasks and validation checks
Informatica Domain Management
Understanding Informatica domain architecture
Managing domain configuration settings
Adding and configuring nodes in the domain
Understanding high availability and failover configurations
Repository Administration
Overview of Informatica repository and repository service
Managing repository content and metadata
Backup and recovery of repository databases
Managing repository users, groups, and permissions
Integration Service Administration
Introduction to Informatica integration service
Configuring integration service properties
Understanding session management and session logs
Managing connections and resources
Security and User Management
Configuring security settings in Informatica
Authentication methods: native, LDAP, and others
Managing users, groups, and roles
Implementing security best practices
Performance Tuning and Optimization
Monitoring system performance and resource utilization
Identifying bottlenecks and performance issues
Performance tuning techniques for repositories and integration services
Capacity planning and scalability considerations
Backup and Recovery Strategies
Developing backup and recovery strategies for Informatica components
Configuring repository and integration service backups
Performing backup and recovery operations
Testing backup and recovery procedures
Advanced Topics
High availability and disaster recovery configurations
Upgrading Informatica PowerCenter to newer versions
Integration with external authentication providers
Implementing custom scripts and automation
Troubleshooting and Debugging
Identifying common issues and errors in Informatica
Using log files and diagnostic tools for troubleshooting
Debugging session failures and errors
Resolving performance-related issues
Best Practices and Governance
Implementing best practices for Informatica administration
Establishing governance policies and standards
Compliance considerations and regulatory requirements
