Informatica PowerCenter is an enterprise extract, transform, and load (ETL) tool used in building enterprise data warehouses. Data warehousing. Data replication and synchronization.

ETL, Data masking, Data Quality, Data Replica, Data Virtualization, Master Data management, etc.

Capability to connect & fetch data from different heterogeneous source and processing of data.

Key Features

SHIVA TECHNO Informatica Training provides a strong foundation on all the core concepts of Informatica PowerCenter to create, execute, administer, and schedule ETL processes and understand how these are used in data warehouse and data mining operations. This course will make you proficient in working with administrator console, repository manager, workflow manager, advanced transformations, etc., through hands-on practices and real-time examples. By the end of the training, you’ll equip all the skills required to clear the Informatica Certification Exam.

  • 24 Hrs. Instructor Led Training
  • Certification & Job Assistance
  • Customized Schedule
  • Pay in 2 Installments
  • Good Theory Material
  • We Provide Class Videos
  • Real -Time Project

Course Curriculum

Chapter 1: Data Warehouse Concepts.
Chapter 2: ETL Concepts.
Chapter 3: Introduction to Informatica.
Chapter 4: Introduction to PowerCenter
Chapter 5:PowerCenter Architecture
Chapter 6: Steps to develop ETL Process using relational source and target
Chapter 7: Steps to develop ETL Process using file source and target
Chapter 8:Introduction to PowerCenter Transformations
Chapter 9: Filter Transformation
Chapter 10: Router Transformation
Chapter 11: Expression Transformation
Chapter 12: Session Cache
Chapter 13: Sorter Transformation
Chapter 14: Aggregator Transformation
Chapter 15: Rank Transformation
Chapter 16: Joiner Transformation
Chapter 17: Source Qualifier Transformation
Chapter 18: Lookup Transformation
Chapter 19: Lookup Caches
Chapter 20: Update Strategy Transformation
Chapter 21: Sequence Generator Transformation
Chapter 22: Dimensional Modeling
Chapter 23: Slowly Changing Dimensions
Chapter 24: Slowly Changing Dimension Type-1
Chapter 25: Slowly Changing Dimension Type-2.
Chapter 26: Slowly Changing Dimension Type-3.
Chapter 27: Slowly Changing Dimension Type-6
Chapter 28: Normalizer Transformation
Chapter 29: Transaction Control Transformation
Chapter 30: Stored Procedure Transformation
Chapter 31: Working with Flat Files part-2
Chapter 32: Working with XML files
Chapter 33: Union Transformation
Chapter 34: Mapplets
Chapter 35:Mapping Parameters and Variables
Chapter 36: Session Partitioning
Chapter 37: Pushdown Optimization
Chapter 38: Session Parameters and Variables
Chapter 39: Session Recovery
Chapter 40: Tasks
Chapter 41: Bulk vs. Normal Load
Chapter 42: Worklets.
Chapter 43: PMCMD and PMREP
Chapter 44: User-Defined Functions
Chapter 45: Debugger
Chapter 46: Reusable Transformations
Chapter 47: Objects Sharing
Chapter 48: Workflow Scheduling
Chapter 49: ETL Testing
Chapter 50: Target Load Order
Chapter 51: Constraint Based Loading.
Chapter 52: Informatica Scenarios.
Chapter 53: A case study on Dimensional Modelling
Chapter 54: SQL Basics.

Our Trainers.

Our Trainers fully trained on how to handle students by provide complete freedom to get out the students innovative and probelem solving skills to understand the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects. And even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.


  • Every Trainer experience between 5 to 15 Yearsof Experience.
  • Trained more than 500+students every year.
  • Strong Theoretical & Practical Knowledge.
  • Certified Professionals with High Quality in training delivery.
  • Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  • Most of our trainer working in multnational companies.


Well, I took Informatic Power Center Online training course from SHIVA TECHNO and now I am an expert in this ETL and business intelligence. I highly recommend Informatica course to everyone from Shiva Techno.


Sujith Roy

Software Employee

Thank You, SHIVA TECNO, for the wonderful informatica training. I am completely satisfied with the training and was able to grab my dream job. Trainer is proficient in subject.

Souravi Jan



What skills will you learn in our Informatica Training?
  • Learn Informatica Architecture and Role of tools.
  • Understand Power Center and Power Malt.
  • Master Designer tools and interfaces.
  • Create and Define Targets.
  • Know Mapping and Transforming Techniques.
  • Master workflow Manager.
  • Learn about various types of tasks like command Task, Email Task, etc.
Who can take this online Informatica Training?

Anyone who represents job roles like Data integration developers, Database Developers, Informatica administrators, Business intelligence professionals can attend this course. Individuals who have the interest to pursue a career in the Data integration field can also participate in this course.

What are the Prerequisites for Informatica Course?

Previous knowledge on ETL, Database, DMDW (Data warehouse and Data mining) concepts is beneficial for this course.

Do I get any discount on the course?

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

Do SHIVA TECHNO accepts the course fees in installments?

Yes, we accept payments in two installments.

We're Here To Help you!


106/2A/2RT, 2nd Floor – 201 A, Above Sindhu Cargo Carriers,         S.R. Nagar, Hyderabad – 38, India.


M-F: 8am – 10pm
S-S: Closed

Contact Us

Call Us:  +91 9849683033

Mail Us: