Informatica Power Center Administration
What you'll learn
- This course covers Informatica Administration, everything from installation, to repository maintenance, scheduling, grid management, to version control. This class also shares repository migration techniques, import/export at the metadata level, and external version control systems. The focus of this class is to instruct the student on how to administer the Informatica Environment. It will cover basic concepts to intermediate concepts on administration of the environment.
Requirements
- Basics of RDBMS
- DWH Concepts
- ETL Methodologies
Description
****Update****
New section added with the latest features of Informatica version 10x, changes to the Administration Console and the upgrade planner options.
****Update****
After completing this program you should be able to:
- Perform day to day activities of an Informatica Administrator
- Prepare your ground for Informatica Administration certification
- Install the Informatica 9x/10x architecture platform, configure add and manage Informatica PowerCenter & Data Quality.
- Define and set up platform best practices for users, privileges, roles, and permissions.
- Assign users to groups, privileges to roles and roles to groups. Assign permissions and manage the domain.
- Manage repositories and repository folders. Backup and migrate the Informatica domain database.
- Use the command line to manage the domain and repository, start and control workflows
- Upgrade license, versions
- Understand different processes of deploying the code from one environment to another environment.
Who this course is for:
- Business Intelligence Professionals or ETL Developers Professionals aspire to become Business Intelligence Professionals Project Managers, Database Professionals, Mainframe Professionals, SQL Developers
Instructor
Business Intelligence Consultant and Trainer with 14+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.
Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.