Informatica Course Online

Welcome to All OPT/ CPT/ H1B/ H4/F1/GreenCard Citizens for bright Career PRO CAREER OFFERS REGULAR, WEEKEND AND FASTTRACK TRAININGS

PRO CAREER Information Technology Provides Modern Online IT Training/E-Learning Solutions on Program Applications of SAP (All Modules), JAVA, BA, Oracle Applications,Data Warehouse (DWH),Testing Tools QA QTP,SAS,Dot.Net Online Training etc., to all Working/Non Managing Candidates With Far away Technology throughout USA, UAE, Indiana, UK, Canada, Saudi Arabia, New Zealand, India and Many Other Countries by a Real Time Professionals.

PRO CAREER has the capabilities and expertise to manage online IT training programs that subsequently leads to certification and placement support.

Our online instructor-led training programs cater to individual students, corporate and project personnel aiming to enhance and upgrade IT skills, as per project expectations.

Why PRO CAREER?

PRO CAREER definitely offers the advantages of affordability, expertise and cloud technology in running the IT courses Online. Notable are our other differentiators.

• Interactive learning at learner's convenience
• Industry savvy trainers
• Custom & real-time curriculum
• 24/7 server access (cloud applications)
• Competitive pricing
• Quality course materials
• Placement support after training
• Technical screening
• Preparation for placements (resume, interviews)
• Student-trainer rapport on Google+
• Certifications & on-the-job training

Remote on job support for our junior consultants to ensure their success and enhance their learning to be successful in project.

More Courses, More flexibility, Scheduled More Often

Note: PRO CAREER Also OFFERS REGULAR, WEEKEND AND FASTTRACK TRAINING

The team at PRO CAREER includes career professionals with more than five decades of combined experience in IT training, consulting and management. As a team, we all have one objective in mind, to provide our customers world-class and high quality IT training programs.

By way of continuous improvements to business methods and process, we aim to generate phenomenal value for their customers and achieve better resource (material & men) management. Each member of our team has made remarkable contribution to the promotion of IT education and IT training framework.

The following are some of the notable differentiators presented by our team.

• Entrepreneurial flair and strong passion for enhancing the IT skills set of people
• Delivering training success, and impacting measurable business outcome
• Five decades of combined experience in IT education, training and consulting
• Develop and offer custom IT training programs as per the requirements of the client companies
• Training with set objectives and ends in mind: All our IT trainings should result in higher client satisfaction,higher sales and turnover, and assured flow of new and repeat customers for businesses/employers.
• Each member of our team brings to the company, robust project management skills, project implementation and rapid global delivery.

At PRO CAREER, we are unanimous on bridging quality training with the needs of corporate for trained and skilled personnel.

Informatica Power Center 9.x Administration Online Training

Course Content:

Informatica Powercenter 9.X Online Training Course Content

1. Informatica Powercenter Training 9.X Overview:

• Identify different Informatica Products
• Describe PowerCenter as a tool to perform Extract transform & load
• Interpret PowerCenter Architecture
• Its different components & their functionalities
• Explaining the advantages of component based development techniques in PowerCenter

2. Etl Fundamentals:

• ETL & ETL Architecture
• Flat file & relational Sources using the Source Analyzer
• Flat file & relational Targets using the Target Developer
• Mappings using the Mapping Designer
• Workflows using the Workflow Designer
• Monitor the workflow using the Workflow Monitor
• Preview Target Data using the PowerCenter Designer

3. Informatica Powercenter Training Designer:

• Describe & Visualize PowerCenter Designer
• Explain how to create the mapping in Designer
• Explain different Transformations & their usage

4. Informatica Powercenter Workflow Manager & Monitor:

• Understanding PowerCenter Workflow Manager
• Describe Flow within a Workflow
• Describe Re-usability & Scheduling in the Workflow Manager
• Understanding components of Workflow Monitor
• Understanding Workflow Task & job handling

5. Advanced Transformation Techniques:

• Understanding the advanced features & functions of Transformations
• Learn about the Java Transformation
• XML File handling, Learn to use Normalizer Transformation
• Learn some advanced concepts of the ETL
• Learn about reusable objects in the Informatica

6. Parameters & Variables:

• Understanding different Parameters & Variables used in PowerCenter
• Describing Mapping Parameter & Variables
• Learn to use the Session Parameters
• Learn to use the Workflow Variables

7. Debugging Troubleshooting Error Handling & Recovery:

• Describing the basic Informatica PowerCenter training Error
• Follow a basic troubleshooting methodology
• Using the debugger
• Use Workflow & Session logs to the diagnose errors
• Recognize & repair, Connection Errors & Network errors
• Design Error Handling Strategies for intended purpose
• Understanding the recovery scenarios & mechanisms
• Properly Configure Workflow & sessions for recovery
• Understand the purpose of the High Availability
• Monitoring the PowerCenter Environment

8. Caches:

• Understanding the session cache
• Describe when & why cache is created
• Implementing session cache
• Learn to calculate cache requirement

9. Performance Tuning & Optimization:

• Control how PowerCenter uses memory
• Control how PowerCenter uses CPUs
• Understanding the performance counters
• Isolate source, target & engine bottlenecks
• Tune different types of bottlenecks
• Configure Workflow & Session on Grid

10. Powercenter Repository Manager:

• Recognize & explain the functionalities of the Repository Manager tool
• Describing how to create & delete folders using the Repository Manager tool
• Illustrate how to migrate components using Repository Manager Tool

11. Informatica Administration Console & Security:

• Put in your own words an overview of PowerCenter Administration Console
• Recognize & explain the integration & repository service properties
• Identifying how to handle services in the Administration Console
• Explaining how to handle locks through the Administration Console
• Illustrate how to create users & groups

12. Informatica 9.X – Technical Architecture:

• Understand Informatica 9.X Architecture
• Describe the Application services related to PowerCenter & their related processes
• Understanding the buffer memory
• Describe Connectivity among the tolls
• Describe Connection pooling used in PowerCenter

13. Informatica Installation & Configuration:

• Step by step installations process
• Configuration of the different Informatica PowerCenter training PC components & their set up
• Backup & recovery, Operational procedures

14. Command Line Utilities:

• Informatica frequently used commands
• pmrep
• pmcmd
• infacmd
• infasetup

15. Etl Scenarios Using Informatica:

• SCD, XML Processing
• Flat file handling
• Different Transformations
• For loop implementations in the PC
• Partitioning
• Pushdown optimization
• Constraint based loading
• Incremental Aggregations

16. Best Practices & Velocity Methodologies:

• ETL best practices using the Informatica PowerCenter training
• Development Techniques
• Error Handling & Data Migration
• Performance Tuning