Informatica powercenter 10 developer and admin

Informatica powercenter 10 developer and admin

This course is applicable to software version 10.1. Enhance your developer skills with advanced techniques and functions for PowerCenter. This course focuses on additional transformations and transaction controls, as well as, teaches performance tuning and troubleshooting for an optimized PowerCenter environment.


Why Informatica?

Informatica provides the market’s leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today’s market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.


After successfully completing this course, students should be able to:

Understand the Informatica PowerCenter architecture

Determine the structure and use of PowerCenter Parameter Files

Implement user-defined and advanced functions

Normalize and Denormalize data using PowerCenter

Use the Lookup transformation in Dynamic mode

Call a SQL stored procedure from a PowerCenter mapping

Create and configure a SQL transformation and its two modes of use

Design error handling strategies appropriate for the intended purpose of a workflow

Make use of the PowerCenter source-based, target-based, and user-based transaction control

Utilize constraint-based loading in databases with referential integrity constraints

Use the Transaction Control transformation for data-driven RDBMS transaction control

Determine the proper use of built-in and optional, mapping-design recovery capabilities

Build batch files that use PMCMD and PMREP command line programs

Apply PowerCenter Performance Tuning Methodology

Describe the effect of mapping design on performance and apply these design principles to a mapping

Calculate how much memory a session uses and tune session-level memory

Apply partitions, distribute the data and optimize the CPU memory usage

Why should you get Informatica PowerCenter certification?

Forrester claims Informatica PowerCenter to be the most preferred ETL technology which clearly proves its importance across the industries. More and more companies are inclining towards effective ETL tools to help synchronize the enterprise-wide data. Informatica is known for its effective data integration and data quality features that let enterprises deal with multiple processes simultaneously. Clearly getting Informatica PowerCenter certified will be the wisest decision if you are planning to take your career to this direction. Intellipaat offers Online Informatica training course that is aligned to the skill-set required to clear these certifications.

Which Informatica certification do I take?

Informatica certification is a two levelled structure :

  • Specialist – To achieve Specialist recognition, a candidate must pass a written exam, proctored in person or via webcam. The Specialist exam validates that the individual understands the product and can apply the skills and capabilities required to contribute to a project as a full team member.
  • Expert – To reach the Expert level an Informatica Certified Specialist must pass Informatica Velocity Best Practices and Implementation Methodologies Certification. This certification validates that you are able to lead a project implementation team following our best practices.


Who should go for this certification?

The following professionals can go for this Certification:

  • Software Developers.
  • BI/ETL/DW Professionals.
  • Mainframe Developer.
  • Individual Contributors in the field of Enterprise Business Intelligence.