Date Days Time
September 26 Sat & Sun
Weekend batch

8:00 PM To 11:00 PM (IST)
October 4 Sat & Sun
Weekend batch

8:00 PM To 11:00 PM (IST)

Program Price

$149/- $258/-

40% off limited period offer.

Program Syllabus

  • • Understanding data warehousing
  • • How to do the extract, transform and load the processes?
  • • Understanding the aggregation of data
  • • Understanding scrubbing and cleansing of data
  • • Discussing the need of Informatica PowerCenter ETL


  • ● Step-by-step installation of Informatica tool
  • ● Installing and Configuring informatica tool
  • ● Installing the operational administration activities and integration services


  • ● What is Active Transformation?
  • ● What is Passive Transformation?
  • ● Comparison between Active and Passive Transformation
  • ● Features in both Active and Passive Transformation


  • ● What is Ranking Transformation?
  • ● What is Union Transformation?
  • ● Comparing both Ranking and Union Transformation
  • ● Understanding the Deployment in them
  • ● Understanding the Deployment in them
  • ● Characteristics of these transformation


  • ● Understanding rank function and dense rank functions
  • ● Use-cases in each of these functions
  • ● Syntax for each of these functions


  • ● What is Router Transformation?
  • ● Working of router transformation works
  • ● Essential Features of Router Transformation


  • ● Understanding Source Qualifier Transformation.
  • ● Overview of Lookup transformation
  • ● Various types of lookup transformations:
  • ● Connected
  • ● Unconnected
  • ● Dynamic and static


  • ● What is Slowly Changing Dimension (SCD)?
  • ● How to do processing in xml?
  • ● Learn how to handle a flat file, list and define various transformations
  • ● Implementing ‘for loop’ in PowerCenter
  • ● Understanding the concepts of pushdown optimization and partitioning
  • ● Understanding constraint-based loading
  • ● Understanding incremental aggregation


  • ● Understanding different types of Designers:
  • ● Mapplet
  • ● Worklet
  • ● Target load plan
  • ● Loading to multiple targets
  • ● Linking property


  • ● What is Performance Tuning in Informatica?
  • ● Understanding the Objectives of performance tuning
  • ● Defining performance tuning
  • ● Learning the sequence for tuning


  • ● What is a Repository Manager?
  • ● What is the need of a Repository Manager?
  • ● How to Manage repository?
  • ● Understanding various aspects in Repository Manager:
  • ● The client tools
  • ● Functionalities of previous versions
  • ● Important tasks in Repository Manager
  • ● Understanding and adopting best practices for managing repository in informatica


  • ● Understanding Informatica Workflow Manager
  • ● Looking into common tasks/functionalities in the workflow manager
  • ● Creating dependencies and the scope for a workflow monitor
  • ● Creating a workflow with dependencies of nodes


  • ● Defining the different variables and parameters in Informatica
  • ● Discussing the parameter files and their scope
  • ● The parameter of mapping, worklet and session parameters
  • ● Workflow and service variables and basic development errors
  • ● Define variables and parameters in functions, use the parameter of mapping, use worklet and session parameters and use workflow and service variables


  • ● Session and workflow log
  • ● Using debuggers
  • ● Error-handling framework in Informatica
  • ● Failover and high availability in Informatica
  • ● Debug development errors
  • ● Read workflow logs and use the error-handling framework
  • ● High Availability and Failover in Informatica
  • ● Configurations and mechanisms in recovery and checking health of PowerCenter environment
  • ● Configure recovery options and check health of PowerCenter environment


  • ● Infacmd
  • ● pmrep
  • ● infasetup
  • ● Processing of a flat file
  • ● Use commands: infacmd, pmrep and infasetup


  • ● Fixed length and delimited, expression transformations: sequence numbers and dynamic targeting using transaction control
  • ● Perform expression transformations: sequence numbers and dynamic targeting using transaction control
  • ● Dynamic target with the use of transaction control and indirect loading
  • ● Use of transaction control with dynamic target and indirect loading


  • ● Importance of Java transformations to extend PowerCenter capabilities, transforming data and active and passive mode
  • ● Use Java transformations to extend PowerCenter capabilities
  • ● Understanding the unconnected stored procedure in Informatica and different scenarios of unconnected stored procedure usage
  • ● Use the unconnected stored procedure in Informatica in different scenarios


  • ● Using SQL transformation (active and passive)
  • ● Use SQL transformation (active and passive)
  • ● Understanding incremental loading and aggregation and comparison between them
  • ● Do incremental loading and aggregation


  • ● Working with database constraints using PowerCenter and understanding constraint-based loading and target load order
  • ● Perform constraint-based loading in each order
  • ● XML Transformation and Active Lookup
  • ● Various types of XML transformation in Informatica and configuring a lookup as active
  • ● Perform XML transformation and configure a lookup as active


  • ● Understanding what data profiling in Informatica is, its significance in validating content and ensuring quality and structure of data as per business requirements
  • ● Create data profiling in Informatica and validate the content
  • ● Understanding workflow as a group of instructions/commands for integration services and learning how to create and delete workflow in Informatica
  • ● Create and delete workflow in Informatica


  • ● Understanding the database connection, creating a new database connection in Informatica and understanding various steps involved
  • ● Create a new database connection in Informatica
  • ● Working with relational database tables in Informatica, mapping for loading data from flat files to relational database files
  • ● Create mapping for loading data from flat files to relational database files


  • ● Understanding how to deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter
  • ● Deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter
  • ● Connection with Sources
  • ● Connecting Informatica PowerCenter with various data sources like social media channels such as Facebook, Twitter, etc.
  • ● Connect Informatica PowerCenter with various data sources like social media channels such as Facebook, Twitter, etc.


  • ● Pushdown optimization for load-balancing on the server for better performance and various types of partitioning for optimizing performance
  • ● Optimize using pushdown technique for load-balancing on the server for better performance and create various types of partitioning for optimizing performance
  • ● Understanding session cache, the importance of cache creation, implementing session cache and calculating cache requirement
  • ● Implement cache creation and work with session cache


  • You work as BI consultant in an Aqua cultural organization that imports and exports fish products. You are responsible for loading the data from databases to Data Warehouse in proper format. Then you must analyze the data in the Data Warehouse to create dimensions and measures to deploy a cube. This cube is then used for creating reports. You have data in flat file and excel. You must cleanse the data and load it to SQL Server. Tasks to be performed are: Create three Data Flow tasks for loading export table to SQL Server Database named AquaCulture, loading import table to SQL Server Database named AquaCulture, load Sales and Discount data to SQL Server Database named AquaCulture. Create a new column to insert month name derived from the TIMEPERIOD column. Sort the data based on year and month fields. Join Geography Description data with the three respective sources to insert the Geography Description field to the target.



Overview

Informatica Certification Training

An industry-oriented course designed by experts. Master Informatica from basics to advance with this course filled with real-world projects, assignments, and hands-on.

Key Features

  • 5+ Projects, hands-on, and case studies

  • 36+ Hours of interactive learning

  • 30+ Hours of exercise and project work

  • Lifetime access to LMS

  • Attend as many batches for lifetime

  • 24/7 Technical Support

  • Resume Building

  • Placement Assistance

  • Dedicated Learner Delight Team

About Course

Informatica Tool, Informatica PowerCenter ETL, Data warehousing, Ranking and Union Transformation, Router Transformation, Slowly Changing Dimension (SCD), Performance Tuning, Error Handling and Recovery, and more.


Freshers, anyone willing to build a career as an Informatica Developer.


No prerequisite. We teach everything from scratch.


According to Gartner, the Business Intelligence and Analytics Market is to grow by $23 billion in the next 2 years. Informatica is the most versatile ETL tool adopted by businesses of all scales. The salary trend for an Informatica PowerCenter Developer in India ranges from 6 lacs per year to 15 lacs per year (source: Glassdoor). In the US it ranges from $45,000 to $183,000 per year.


Hiring Companies

Source : Indeed

Our Learners Work For

Course Completion Certificate

What People Think

Atul Kulkarni

Atul Kulkarni

Vice President at HDFC Bank Ltd

Experience with Eduranz is world class. I took 2 courses Informatica Power Center 9.x and Tableau Certification Training. I feel both the courses had extremely knowledgeable instructors, professional course delivery, recorded classes.

Rajeev Kathuria

Rajeev Kathuria

West Head-Partner Management at Samsung

The instructor was very good and prompt in responding to questions. Excellent virtual class experience. Good Work eduranz!

Ljiljana Spasovic Botha

Ljiljana Spasovic Botha

Business Development Officer at SASLO

Had a great learning session where the concepts are clear to understand and can solve the given assignments easily.

Anil Sadaye

Anil Sadaye

Channel Account Manager-India at Symantec Software

Clean, simple and a fantastic learning resource. The courses are a great resource for personal development and continuous learning.

Ajit Mohile

Ajit Mohile

Director at Cyber Top Consulting

"Eduranz is a wonderful platform to get industry level training in the courses they are offering. Instructors are experienced and the sessions are very interactive even though they are online sessions. "

Train Your Employees

We offer flexible and cost-effective group membership for your business, goverment organization.

Connect Now

FAQ

Eduranz offers a unique online Informatica Certification Training for professionals who are willing to build a career in this rousing domain. There are many reasons to choose Eduranz: Interactive online instructor-led live classes conducted by SMEs
Personal mentors who will keep a stage track of your progress in the course
A Substantial LMS which allows the users to view their recorded sessions from their live classes along with the self-recorded courses
Real-time exercises, assignments, industry-based use cases and real-world projects
24/7 learning support by the Eduranz’s dedicated tech support team
Large community of learners from across the globe
Industrially as well as globally recognized certificate by Eduranz
Personalized job support, resume and interview preparation

You never miss any lecture at Eduranz, because you will be provided with the recorded sessions of the live class on your LMS within 24 hours and despite that, you can also attend any different live session to cover up the missed topic and ask your doubts from the trainer or you can simply reschedule your batch and get yourself a new batch assigned.

Live Virtual Classes or Online Classes. With online class training, you can access courses via video conferencing from your desktop to increase productivity and reduce work time and personal time.

Eduranz offers a 24/7 request solution and you can pick up your tickets at any time from our dedicated support team. You can use email support for all your questions. If your request is not answered via email, we can also arrange one-on-one discussions with the faculty. You will be glad to know that you can switch to Eduranz support after completing the training. We also don’t limit the number of tickets you can collect when solving questions and doubts.

Yes, Eduranz has a dedicated placement assistance team. Our job assistance program will help you reach the job you have been seeking. Under this program, we help you by building your professional resume and then sharing it across our network companies that we have tie ups with.

Eduranz offers the most up-to-date, relevant and valuable projects in the real world as part of the training program. In this way, you can integrate what you have learned in the real industry. Each training is delivered with various projects where you can thoroughly test your skills, learning and practical knowledge so that you are well prepared for the industry. They work on very interesting projects in the fields of high technology, e-commerce, marketing, sales, networking, banking, insurance and more. After successfully completing your project, your skills will be counted as a result of six months of intensive industry experience.

After completing the Eduranz Training Program along with all real projects, tests and assignments and achieving at least 60% points in the qualification exam; you will receive an industrial recognized certificate by Eduranz. This certification is recognized by companies all across the industry, which includes a lot of top MNCs worldwide.

Our job assistance program will help you reach the job you have been seeking. Under this program, we help you by building your professional resume and then sharing it across our network companies that we have tie ups with. You will also be prepared for interviews through mock sessions. However, Eduranz is not a recruitment agency. We do not guarantee you a job. After we share your profiles with the companies, the further process depends upon your performance and their decision.

All of our highly qualified instructors are industry experts with minimum 10-12 yrs. of relevant IT experience. Each of them underwent a rigorous selection process that included screening profiles, teaching assessments, and training demonstrations.



Career Related Program

Artificial Intelligence Masters

Artificial Intelligence Masters

Read more

Artificial Intelligence Masters
Azure Masters Program

Azure Masters Program

Read more

Azure Masters Program
Cloud & Devops Architect

Cloud & Devops Architect

Read more

Cloud & Devops Architect
Data Science Architect

Data Science Architect

Read more

Data Science Architect
AWS Solutions Architect

AWS Solutions Architect

Read more

AWS Solutions Architect
Data Science with R

Data Science with R

Read more

Data Science with R
Azure 300-301

Azure 300-301

Read more

Azure 300-301
Python

Python

Read more