Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price # Enroll Book free demo
Weekend
40 Hrs Weekend Morning-Batch USD 500
INR 20000
Enroll Now Book free demo class
Weekend
40 Hrs Weekend Evening-Batch USD 500
INR 20000
Enroll Now Book free demo class
Weekdays
40 Hrs Weekdays Morning-Batch USD 500
INR 20000
Enroll Now Book free demo class
Weekdays
40 Hrs Weekdays Evening-Batch USD 500
INR 20000
Enroll Now Book free demo class

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

About Course

The targeted audience for this course can be –

Recent graduates looking a career in data analysis and data integration.
Data Analytics Professional
Database Developers
System Admins
Project Managers
Informatica PowerCenter is a collection of workbench tools which helps to create, execute, monitor and schedule ETL processes. This course is designed to provide you the end to end knowledge about core concept required for the administration of Informatica PowerCenter Platform. In this course you will get an exposure to cover all the topics from very basic to advance like understanding architecture, installing, configuring and managing services.
After completing this course, you will be able to:

Understand the architecture of Informatica PowerCenter
Apply SQL transformations to format, join, aggregate and route data
Work with PMCMD and PMREP command-line functionality
Design and build simple mappings and workflows
Handle and Trap errors using PowerCenter mappings
Use PowerCenter logs and debugger to perform troubleshooting
Having a basic understanding about Data analytics concept can be evolved as a prerequisite to join this course.

CURRICULUM

Informatica PowerCenter

  • 1.1 How the different pieces of the architecture fit together
  • 1.2 How the different services relate to one another
  • 1.3 The function of each service
  • 1.4 The different types of nodes & how they function
  • 1.5 Be familiar with the client applications & how they interact with the domain
  • 1.6 Be familiar with the Administrator tool
  • 1.7 Domain alerts & how they’re configured
  • 1.8 Domain migration
  • 1.9 The license service
  • 2.1 Know the function of each service
  • 2.2 Know which services support which client applications
  • 2.3 Know how to configure each service
  • 2.4 Generate a diagnostics file

Module

  • 3.1 Be able to define the terms “user,” “group,” “privilege,” “role,” & “permission”
  • 3.2 Know how to configure users, groups, privileges, roles, & permissions
  • 3.3 Know how users, groups, privileges, roles, & permissions relate to one another
  • 3.4 Know the Security page in the Administrator Tool
  • 3.5 Know how to assign users to groups
  • 3.6 Know how to assign privileges & roles to groups or users
  • 3.7 Know how to set up permissions in the various applications
  • 3.8 Know how to set up permissions in the domain
  • 3.9 Know how Informatica authentication works
  • 3.10 Default administrator accounts
  • 3.11 Know the difference between native & LDAP security
  • 3.12 Know how to configure native & LDAP security
  • 3.13 Know the difference between assigned & inherited privileges
  • 3.14 Know the difference between assigned & inherited permissions
  • 3.15 Know the difference between a system & a custom role
  • 3.16 Privilege groups
  • 3.17 Direct, inherited, & effective domain permissions
  • 3.18 Know how to configure operating system profiles
  • 3.19 Subject area implementation

Module

  • 4.1 Know the different methods of PowerCenter metadata deployment
  • 4.2 Advantages & disadvantages of each deployment method
  • 4.3 Best practices around deployment
  • 5.1 Know the role of the license key file
  • 5.2 Know how to assign services to a license
  • 5.3 Know how to view options for a license
  • 6.1 Know the functionality of each of the client tools
  • 6.2 Know how to set folder permissions in PowerCenter
  • 6.3 PowerCenter shortcuts
  • 6.4 Know how to configure PowerCenter connections
  • 6.5 Types of objects reside in a PowerCenter repository
  • 7.1 Informatica web service architecture
  • 7.2 Know the messaging standard Informatica uses
  • 7.3 Know the role of a WSDL file as it relates to an Informatica web service
  • 7.4 Know how to configure an Informatica real-time web service
  • 8.1 Function of each CLI
  • 8.2 Know which CLIs have an interactive mode
  • 8.3 Know the successful CLI return code
  • 8.4 Know how to capture the CLI return code
  • 9.1 Role of the MX views
  • 9.2 Know the function of “Save MX Data”
  • 9.3 Metadata extensions
  • 9.4 Know how to create & manage non-reusable metadata extensions
  • 9.5 Know how to create & manage reusable metadata extensions
  • 10.1 Know configurations
  • 10.2 Understand connections and actions
  • 11.1 Use of the PowerCenter Designer Tool
  • 11.2 Use of the PowerCenter Workflow Manager Tool
  • 11.3 User of the PowerCenter Workflow Monitor Tool
  • 11.4 Source Qualifier Transformation and SQL Statement Generation
  • 11.5 Expression Transformation
  • 11.6 Aggregator Transformation
  • 11.7 Lookup Transformation
  • 11.8 Filter Transformation
  • 11.9 Joiner Transformation
  • 11.10 Union Transformation
  • 11.11 Update Strategy Transformation
  • 11.12 Mapplet
  • 11.13 User Defined Functions
  • 11.14 Active and Passive Rules
  • 12.1 SQL Overrides
  • 12. 2 Stored Procedure Transformation
  • 12.3 Unconnected Lookup Transformation
  • 12.4 XML Transformation
  • 12.5 HTTP Transformation
  • 12.6 Transaction Management with Active Transformations
  • 12.7 Java Transformation
  • 12.8 Normalizer Transformation
  • 12.9 SQL Transformation
  • 13.1 Variable Assignment
  • 13.2 Parameter Files
  • 14.1 Transformation Functions
  • 15.1 Practical Experience
  • 15.2 PowerCenter Workflow Monitor
  • 15.3 Log Management
  • 16.1 Workflows
  • 16.2 Worklets
  • 16.3 Workflow Tasks
  • 17.1 Domain and Node Architecture
  • 17.2 Informatica PowerCenter Commands

Exam & Certification

Informatica PowerCenter Data Integration: Administrator, Specialist

This exam validates your skills for installation, configuration, architecture, server maintenance, security, deployment, PowerCenter Repository management, web services and command line utilities respective to Informatica PowerCenter tool.

Informatica PowerCenter Data Integration: Developer, Specialist

This exam validates you skills at basic and advanced levels for PowerCenter Designer, Workflow Manager and Workflow Monitor tools.
Informatica PowerCenter Data Integration: Administrator, Specialist

Number of questions: 70 questions
Passing Score: 70%
Exam Duration: 90 minutes
Question Type: Multiple Choice, Multiple Response and True/False
Languages: English
Informatica PowerCenter Data Integration: Developer, Specialist

Number of questions: 70 questions
Passing Score: 70%
Exam Duration: 90 minutes
Question Type: Multiple Choice, Multiple Response and True/False
Languages: English

Select Trainer for Demo


Jyoti Ranjan
Certification:
From
Professional Experience
Training Experience

Qualification
B.E(CS)

Skills
Business Intelligence, Informatica, Oracle, Pentaho,

Profile
I’m Technical Analyst with a lifelong passion fo r developing smart,nimble processes that let Business firms grow fast by providing Analytical insight into Data to make concise decision. I have 4 years of experience in Informatica/Pentaho BI Tools,Oracle,Unix scripting. I’m looking for my next challenge leading a technical driven team. Read More...
RATING & REVIEWS
Shrirang Mukund Garge
Certification: Oracle Certified Associate (OCA) , Certified Scrum Master (CSM) , Hortonworks Certified Developer (HDPCD)
From
Professional Experience
Training Experience

Qualification
MBA

Skills
Big Data, Business Intelligence, Certified Scrum Master (CSM), IBM Cognos, Informatica, Oracle, PL/SQl,

Profile
Hortonworks certified developer. Certified Scrum Master. Oracle Certified Associate. Total 15 years of IT experience. Around 4 years of experience in the areas of Data Warehousing and Data Migration using PL/SQL, BI, Informatica, Cognos. Read More...
RATING & REVIEWS
Ankita Agrawal
I joined Rave as a fresher and I was totally new to the IT industry. The kind of support I got from him was terrific. Anyone can learn from him the art of "Staying Calm and Cool" irrespective of the situation. One very good thing about him is he believes in giving timely Feedback to his juniors which helps his juniors to learn more and more and to improve performance. And yes , he is a dependable person. I am sure he will be a pillar for any organization he joins.
Ravi Mittal
I worked with Shrirang for closed to 5 years. He is someone who you can bank on. Once he gets his arms around a process he follows it to the minutest detail. He was a very calm demeanor. Great person to know and work with.
Cyril Rayan
Shrirang is an excellent program manager and has a strong team to deliver great results. He has great expertise in software projects and can deliver extremely well.
Anand Jain
Shrirang is a person with a broad vision and clear mindset. He always aim to the best possible results by getting his team involved in making decisions and put their best efforts in place. He is confident and a person full of business knowledge as well as capabilities of leading a team and himself.
Pallavi Bakliwal
I had the opportunity of working with Shrirang at Rave for 4 years. He is methodical, organized and very committed towards the job he undertakes. He has always demonstrated a high degree of expertise and his ability to connect with people, inspire and motivate them is incredible. He is always around to help people and he is the best manager one can ever work with.
Pallavi Bakliwal
I had the opportunity of working with Shrirang at Rave for 4 years. He is methodical, organized and very committed towards the job he undertakes. He has always demonstrated a high degree of expertise and his ability to connect with people, inspire and motivate them is incredible. He is always around to help people and he is the best manager one can ever work with.
Ankit Johari
Working with Shrirang was a great phase of my life. He is always supportive and helpful in the difficult times. He is one of the good and skillful manager I have worked in...
Sankalp Shekhar
Shrirang, a great colleague and a peer who you could look up-to for counsel. With his acute understanding in Agile methodology, he has been delight as a Scrum Master to work along. His understanding and standards of work quality, has always been motivating to bring the best out of the resources.
Aliakbar Badshah
I had the pleasure of working with Shrirang at Rave Infosys. I have learn lots of things from start to end of my career in Rave. He is a good project manager, director and also a good person.
Ashok Patidar
I have worked with Shrirang for more than 1 year. It was really a pleasure working under his guidance in Rave Infosys. It’s an honor and privilege for me realizing that I have worked with an exceptional director. No Doubt, he is an outstanding leader, a person and a friend. I highly recommend him to work with.
Sandeep Patle
Still I can remember that 1 year of Span. Working under Mr.Shrirang, was a great Experience for me and my Team. Though we had too much pressure from client but Shrirang handled it quite nicely. He is one of the Best Managers that I ever seen in 5 years of my career. I could remember his words "Family is very important than Office !!!"
Ankita choudhary
I started my career from Rave and I was fortunate to have Shrirang as my manager. He guided and motivated me and all the people working under him and with him whenever required. He is very detail oriented, hardworking and a good team leader. He is a great person and an outstanding director and mentor.
Vaishali Joshi
Certification: Business Intelligence
From
Professional Experience
Training Experience

Qualification
Bsc (Mathematics)

Skills
Business Intelligence, Informatica,

Profile
After having a corporate experience of more then 9 + years working for companies like Siemens & Essar and many more I discovered that job will not take me to the place where I want to be. I followed my passion & instincts to become an entrepreneur where I met a bunch of enthusiastic people and we are together creating a System that allows us the opportunity to Empower and Equip other like-minded-equally-passionate people become Global Entrepreneurs and follow their hearts. I love to meet and exchange notes with people who have a Drive to Excel, who Dare to Dream BIG and whose life’s mission is to make a difference in their own lives and those of people around them! Specialties Leisure & Travel, e-commerce, market entry & development, International expansion Read More...
RATING & REVIEWS
Sanjay Tiwari
Vaishali Joshi has worked with me and she has got tremendous commitment for her work. She has been working as technical expert in i2 area and has got good knowledge and expertise in i2 modules. She has a combines a lot of positive energy with focussed technology expertise to deliver outstanding solutions. Overall a huge asset for the team.
Disclaimer

** The above course information is taken from Informatica LLC.

* Money Back Guarantee till demo and 1st class of the course.

* All trademarks and logos appearing on this website are the property of their respective owners.


Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US