Informatica PowerCenter Developer

Beginner to Expert Level

  • Understand Data Warehouse Concepts and ETL Concepts
  • Describe Informatica PowerCenter architecture & its different components
  • Use PowerCenter 10x/9.x components to build Mappings, Tasks, Workflows
  • Describe the basic and advanced features functionalities of PowerCenter 10.0/9.6 transformations
  • Understand Workflow Task and job handling
  • Describe Mapping Parameter and Variables
  • Perform debugging, troubleshooting, error handling and recovery
  • Learn different types of cache available and how to calculate cache requirement and implement session cache
  • Execute performance tuning and Optimization
  • Identify and explain the functionalities of the Repository Manager tool
  • Identify how to handle services in the Administration Console
  • Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
  • Gain insight on ETL best practices using Informatica
  • Understand all the basic interview questions for all the transformations and real time scenarios


Your Instructor


Sid
Sid

Data Management and Business Intelligence Consultant/Trainer with 16+ years of extensive work experience on various client engagements. Delivered many large Data Management projects (Data Integration, Data Quality, Data Governance, Metadata Management, Master Data Management, Data Security, Data Catalog etc) and trained numerous professionals on various tools and technologies. Extensively worked on all facets of Data Managment 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.


Sid is an awesome instructor. He is concise, consistent, articulate when illustrating examples in Informatica. Hands down the best course I have taken!!!

- Trenton Cain

Great presentation, thanks to instructor for making the training near complete Informatica resource. Great resource for someone new to Informatica or someone who already has some knowledge.

- Rasik Sharma

Course Curriculum


  Informatica 10x New Features
Available in days
days after you enroll
  Informatica Version 10 Installation and Configuration
Available in days
days after you enroll
  Different DataTypes in Informatica
Available in days
days after you enroll
  Filter Vs Router
Available in days
days after you enroll
  Connected Vs Unconnected Lookup Transformation
Available in days
days after you enroll
  XML Transformation
Available in days
days after you enroll
  Debugger
Available in days
days after you enroll
  Timer Task
Available in days
days after you enroll
  Control Task
Available in days
days after you enroll
  Command Task
Available in days
days after you enroll
  Decision Task
Available in days
days after you enroll
  Workflow Variables and Assignment Task
Available in days
days after you enroll
  Workflow Monitor & Repository Manager for Log Information
Available in days
days after you enroll
  Developer's activities using Repository Manager
Available in days
days after you enroll
  Purging and Versioning
Available in days
days after you enroll
  Parameter Files
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 5 days or before you start with the section 3 and we will give you a full refund.
How is the online session conducted?
All online sessions are conducted with the help of webex/gotomeeting/teamviewer. Trainer will share his screen with you and everybody (all the participants) in the session would be able to see the screen and hear each other and talk to each other to make it an interactive session.
What about trial classes for online/video based sessions?
Check our free course ‘Mini Course - Master Data Warehouse Concepts from Scratch and become an Expert’ from the home page. You can also view free session enabled for each course separately.
Do you teach on some/any real time scenarios / live projects?
Yes, all the courses and the trainings we take are real time project implementations. Everything will be practical and on sample/simulated real time project implementation.
Which is better - videos or online classes?
Well, videos are better and elaborate. You can watch them any number of times. No limitations. And, all the videos are lifetime access with no charges to the future updates.
What all will you cover in the course?
Please look at the course content for more information.
Will this help me in clear interview?
Yes all the videos can help you clear interview but you will have to relate understand the whole tool/concepts related to the course. Nothing will happen overnight and you will have to practice a lot and ask a lot of questions. We are here to help you with any questions you have at any point of time.
Will it be an interactive session?
Yes, you will be able to hear trainer and communicate as well for online sessions. If you are taking the video based courses, there are options to see the questions asked by you and also by other participants. This will not only help you to get the questions clarified but also you will know the different perspectives of the subject based on the questions asked.
What material will I get apart from classes?
We will support you with your questions, doubts and help you with all the presentations, documents and best practices with sample code to learn the content with more clarity.
What if I miss a class during online sessions?
Please do not miss a class. In case you miss it, you can refer to videos and complete the topics.
What is the payment procedure/mode?
Click on the Enroll now button and proceed with the steps mentioned.
What is the refund policy?
If you do not like videos, full amount will be refunded provided you report within 2 days of getting the access and making the payment.
Will you be helping me in my project once i get into a job?
We offer, various support plans based on the need. Please write to us at [email protected] or [email protected] for further information on this. Please note, taking the course will not make us liable to support you for any job or job related activities.
What if you add more videos?
Once you enroll to a course (post the payments are made), all the videos are life time free and all future video updates are free of charge. We will send out an announcement regarding the new topics added on a regular basis.

Get started now!