Course description

  • What’s the focus of this course?

    This informatica training by Simplilearn equips you with all skills required to step into the field of ETL and data warehousing using the most in-demand tool Informatica Powercenter. This course builds your competency in developing beginner to advanced level of PowerCenter objects and to expertise in the practical use of the Designer, Workflow Manager and Workflow Monitor tools. This training will provide you hands on experience in transformations, workflow building and running and how to be a successful member of a data integration development team. After completing this course you will be able to successfully clear the PowerCenter Data Integration Developer, Specialist Certification from Informatica

  • What are the course objectives?

    After completing this course you will be able to:

    • Understand Basic Mapping Design including the use of Informatica Powercenter Designer, Workflow manager and workflow monitor tool
    • Master source qualifier, expression, aggregator, lookup, filter, joiner and other kinds of transformations
    • Learn Optimal Mapping Design including SQL overrides, stored procedure, xml, http, java and transaction management transformations
    • Explain Parameters files and Variable assignment
    • Work with transformation functions and expression syntax
    • Master troubleshooting with powercenter workflow monitor and log management
    • Workflows and Worklets
    • Expertise in domain and node architecture, powercenter commands and Administration

  • Who should take this course?

    This course is perfect for taking your initial steps into the field of ETL and data warehousing. This training is designed for:

    • ETL and data-warehousing professionals
    • SQL and database Developers
    • Business Intelligence Professionals
    • Mainframe Professionals
    • Project Managers
    • Professionals planning to appear for the Powercenter Developer Certification

  • What are the prerequisites for this course?

    There are no prerequisites for this training but some good to know topics are SQL, databases and some scripting language

  • How will I execute the hands-on practicals?

    The hands-on will be executed using the Informatica cloud trial version. Use this link to access

Course preview

    • Lesson 1 - Basic Mapping Design
      • 1 Use of the PowerCenter Designer Tool
      • 2 Use of the PowerCenter Workflow Manager Tool
      • 3 User of the PowerCenter Workflow Monitor Tool
      • 4 Source Qualifier Transformation
      • 5 Expression Transformation
      • 6 Aggregator Transformation
      • 7 Lookup Transformation
      • 8 Filter Transformation
      • 9 Joiner Transformation
      • 10 Union Transformation
      • 11 Update Strategy Transformation
      • 12 Mapplets
      • 13 User Defined Functions
      • 14 Active versus Passive transformations
    • Lesson 2 - Optimal Mapping Design
      • 1 SQL Overrides
      • 2 Stored Procedure Transformation
      • 3 Unconnected Lookup Transformation
      • 4 XML Transformation
      • 5 HTTP Transformation
      • 6 Transaction Management with Active Transformations
      • 7 Java Transformation
      • 8 Normalizer Transformation
      • 9 SQL Transformation
    • Lesson 3 - Parameters and Variables
      • 1 Variable Assignment
      • 2 Parameter Files
    • Lesson 4 - Expression syntax
      • 1 Transformation Functions
    • Lesson 5 - Troubleshooting
      • 1 Practical Experience
      • 2 PowerCenter Workflow Monitor
      • 3 Log Management
    • Lesson 6 - Workflows and Worklets
      • 1 Workflows
      • 2 Worklets
      • 3 Workflow Tasks
    • Lesson 7 - Architecture
      • 1 Domain and Node Architecture
      • 2 Informatica PowerCenter Commands
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • Exam & Certification

    The following criteria must be met for successful completion of the course and certificate unlock:

    • Successfully completing one of the simulation exams with at least 75%
    • Successful completion and evaluation of any one of the given projects.


  • Who delivers the training?

    All our trainers are certified and are highly qualified, with multiple years of experience in working in ETL, data-warehousing and Informatica.

  • Is this live training, or will I watch pre-recorded videos?

    All the classes are live. They are interactive sessions that enable you to ask questions and participate in discussions during the class time. We do, however, provide recordings of each session you attend for your future reference.

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.

  • Are there any group discounts for classroom training programs?

    Yes, we have group discount options for our training programs. Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will give you more details.

  • What payment options are available?

    Payments can be made using any of the following options. You will be emailed a receipt after the payment is made.

    • Visa Credit or Debit card
    • MasterCard
    • American Express
    • Diner’s Club
    • PayPal

  • I’d like to learn more about this training program. Who should I contact?

    Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will give you more details.

  • What is Global Teaching Assistance?

    • Our teaching assistants are here to help you get certified in your first attempt.
    • They are a dedicated team of subject matter experts to help you at every step and enrich your learning experience from class onboarding to project mentoring and job assistance.
    • They engage with the students proactively to ensure the course path is followed.
    • Teaching assistance is available during business hours.

  • What is covered under the 24/7 Support promise?

    • We offer 24/7 support through email, chat, and calls.  
    • We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.