Informatica Online Training

All the searches for Online Training Courses on Informatica end with Online IT Guru’s Online Training Courses on Informatica. [expand title=”Read More…” trigpos=”below”]Online IT Guru is one of the leading institutes for Informatica Online Training. Online IT Guru has been an baton leader Informatica Online Training from last 7 years. Study Informatica Online Training from Online IT Guru. We have a 100% placement record on Informatica Online Training

All about Informatica
Informatica focuses on product creation which help with data integration, ETL, information lifestyle management, cloud data integration, B2B data exchange, event processing, data masking, data virtualization, master data management and ultra-messaging.

Informatica’s toolset help users maintain and establish huge data warehouses. Tools of Informatica have ability to share services and resources with various machines. Informatica PowerCenter is the most famous product of all the Informatica products. It has 3 major components.

Informatica PowerCenter Server’s executions happens in the server. The main task of Informatica PowerCenter Server’s is to make physical connections with sources and targets. It also fetches data and applies transformations.

Informatica PowerCenter’s client tools installed at the developers’ end, help them to map and monitor execution of different sessions. They also help in managing a repository and Meta data.

Informatica PowerCenter Repository is backend based tool. The repository stores all the Meta data for the application in the back end.

Why Informatica Tools?
The tools of Informatica are known for their Data Integration, Security, User-friendly Visual Interface, Compatibility, Universal connectivity, Scalability, Rapid profiling and prototyping and few other impressive features.

With all the above mentioned features combined with its user adaptability quotient, Informatica tools are easily the most sought after tools in the domain of Data warehousing.

Most of the tools used in the firms and companies dealing with Data Warehousing are either one of Informatica or similar to it. It has become a prerequisite for hiring candidates in companies that work in data warehousing.

Students can enrol into Online training courses on Informatica if they wish to pursue a career in Data warehousing. Online IT guru offers various online courses on Informatica tools. The syllabus is designed in a way that the students receive all the preparation needed before entering into the corporate world.

To know more about Online Training Courses on Informatica or any other online training course offered by Online IT Guru, keep browsing.


Course Information

Informatica is a software development company that focuses on creating products that help in data integration, information lifecycle management, ETL, B2B data exchange, cloud data integration, data masking, event processing, data virtualization, ultra-messaging and master data management.

In simpler terms Informatica’s toolset help users establish and maintain large data warehouses.

Informatica’s tools have the ability to share resources and services with several machines. The most famous product of Informatica is Informatica PowerCenter. It consists of 3 major components. These components being,

• Informatica PowerCentre Client Tools are installed at the developer’s end of the software. These tools help the developer to map, monitor execution of various sessions, manage a repository and report Meta data.
• Informatica PowerCenter Repository works in the backend of the Informatica Tools. This is where all the Metadata for the applications related to the PowerCenter are stored.
• Informatica PowerCenter Server: All the executions take place in the server. It is the server’s job to make physical connections between the sources and targets, fetch data and apply transformations specified in the earlier mentioned map(s).

Features of Informatica:
• Data Integration: the accuracy of data in the transformation and profiling is necessary.
• Security: With the help of security options and user authentication, the data involved remains private and secure.
• Visual Interface: A simple user interface is always appreciated.
• Compatibility of the tool helps users maintain records and move large chunks of data efficiently.

Who Should Take This Course?

Scope of Informatica is already vast in many industries. Informatica is constantly attempting to improve this item and as I would like to think. Candidates who will work in the business stage can go to this. Informatica is generally used in extraction transformation stacking (ETL) tool as a part of building enterprise data warehouses. The accompanying experts can go for this course:

  • Programming Developers
  • BI/ETL/DW Professionals
  • Willing to work in Enterprise Business Intelligence
  • Architects

What Are The Prerequisites?

Basic Knowledge on UNIX, ETL is required. SQL is benefited but not mandatory. Other than no particular essential are not required. The Trainer will help you on the nuts and bolts and basic those are required.

Hands-On Experience

Our guide will support on Real-time Projects with 24*7 team. A lead can play out a traditional of care on the course. This is reasonable to understudies and appearance trainer at the working assignments and Real-time Projects.

Course Features

Online Course Duration Course Duration : 30 Hrs

Highly interactive, reliable and quality learning sessions of the course are conducted by Online IT Guru. For a better learning experience, the courses are divided into distinctive phases and sessions.

Realtime Project Work Hands on Experience

Every module shall be followed by a practical experience of lab exercises. At the end of the course, the students will have to build a project on the concepts that were taught to them during the course duration.

Access Duration Life time Access Duration: Lifetime

Students will have a life time access to the course materials provided by Online IT Guru. Students also have an opportunity to decide the duration of the course as per their schedule and convenience.

24x7 Support 24 X 7 Support

Concerned faculty can be contacted by the students if they are looking for help and assistance with respect to the course and its material. Students can approach their respective faculty to clear their quires either by email, phone or through live chat.

Online Course Certification Get Certified

At the end of the course, students will have to fare well in quizzes and testes conducted by the institute and the faculty in order to receive the required certification. To clear the Certification test with flying colours, students will be given model questions and certification dumps that would make them confident about attempting the test to get their Certification.

Placement Assistance Job Assistance

Online IT Guru will help students find job opportunities with the newly acquired skill set. Online IT Guru has a varied bunch of Clientele around the globe, over 30+ companies in USA and India that have experience in working with different technologies. We would pass your resumes to them after the completion of the course and ensure that the students achieve 100% placements. During the testing and interview process for them, the required assistance shall be provided by Online IT Guru.

Core topics of Informatica Online Course

Introduction to Data Warehousing

  • What is Data Warehousing?
  • Who needs Data Warehouse?
  • Why Data Warehouse is required?
  • What is difference between Database & Data Warehouse?
  • Types of systems


  1. OLAP
  • Maintenance of Data Warehouse
  • Data Warehousing Life Cycle

Data Warehouse Architecture

  • Source
  • Integration Layer
  • Staging Area
  • Targets
  • ODS

Different types of Data Warehouse Approaches

  1. Top-Down Approach
  2. Bottom-Down Approach
  3. Difference between Top-Down & Bottom-Down Approach
  4. Definition of  Data Mart
  5. Different types of Data marts
  6. Difference between Data mart & Data warehouse

Data Modelling

  • What is Data Modelling?
  • Different types of Data Model ling
  • What is Dimension?
  1. E-R Modelling
  2. Dimensional Modelling
  • Different types of Dimensional Modelling
  1. Star Schema
  2. Snow flake schema
  3. Galaxy schema
  • What is Fact?
  • What is Granularity?
  • Types of fact?
  1. Additive fact
  2. Semi additive fact
  3. Non additive fact
  4. Fact less Fact Table
  • Types of Dimensions?
  1. Confirmed Dimension
  2. Junk Dimension
  3. Dirty Dimension
  4. Degenerative Dimension

Introduction To  Informatica

  • Introduction to Informatica
  • Architecture of Informatica
  • Informatica Client tools
  1. Informatica power centre Repository
  2. Informatica power centre Designer
  3. Informatica power centre WORKFLOW DESIGNER
  4. Informatica power centre WORKFLOW MONITOR
  • ODBC Connections of Informatica

Power centre Designer Tools

  1. Source Analyser
  2. Target Designer
  3. Transformation Developer
  4. Mapping Designer
  5. Mapplet Designer

Types of Transformations

  1. Source Qualifier Transformation
  2. Filter Transformation
  3. Joiner Transformation
  4. Expression Transformation
  5. Sorter Transformation
  6. Aggregator Transformation
  7. Rank Transformation
  8. Union Transformation
  9. Router Transformation
  10. Sequence Generator
  11. Lookup Transformation
  12. Update strategy Transformation
  13. Normaliser Transformation
  1. Stored Procedure Transformation
  2. Transaction Control Transformation

Implementation of Slowly Changing Dimensions (SCD)

  1. Implementing SCD TYPE-1
  2. Implementing SCD Type-2
  3. Implementing SCD Type-3

Informatica Workflow Manager

  1. Task
  2. Workflow
  3. Worklet
  4. Workflow Task
  • Scheduling  Workflows
  • Batch Processing

Informatica Advanced Topics

  • Implementing Mapplet
  • User-Defined Functions
  • Debugging
  • Mapping Parameters
  • Mapping Variables
  • Cache
  • Target Load Plan
  • Implementing Worklet
  • Session Properties
  •  Test Cases
  • Running the workflow By using PMCMD  & PMREP
  • Conversion of  STRINGS  to Date Data type
  • Link-Conditions



  1. The course material and coaches are simply and amazing.

    The Onlineitguru Informatica web based preparing is an extraordinary approach to finding out great way in business intelligence. The course material and coaches are simply and amazing. I highly recommend it to everybody. Trust me you are gonna love it!

    Online Training Reviews

    Vijaya A

  2. I did Informatica certification course from here.

    Now I am a specialist in this Informatica business apparatus. I took this instructional class and I am certainly elated! I did Informatica certification course from here. Best organization everlastingly and after achievement my Informatica course they helped me out for college from an institute.

    Online Training Reviews

    Bhavya Shyam

  3. Trainer was extremely COMMITTED, Knowledgeable and all the more imperatively PATIENT.

    This quality was great. A trainer was extremely COMMITTED, Knowledgeable and all the more imperatively PATIENT. I preferred the way points were flowed and perform that is wonderful! Much thanks for such a positive interest. I very prescribe to Supporting team and Onlineitguru.

    Online Training Reviews

    Abhi Nav

  4. The practices given are extremely useful

    When I began I had no information of translate and now I feel exceptionally certain about the area. The practices given are extremely useful and great care is appeared and support that you the subject and idea are well understood. I exceedingly prescribe for anybody wanting to seek after in Informatica Course.

    Online Training Reviews

    Sivanand ADARI

Contact Us
+1 732 703 9066
+91 888 544 8788
Offer : Get Any BI Self-Paced Videos Free With This Course!
  • Lifetime access with high-quality content and class recordings
  • 40 hours of course presentations by hands-on experts
  • 30 hours of lab time
  • 24x7 online support
Live Online Training

Mon -Fri (5 Weeks)
For Business
    Corporate Training
  • Practical knowledge with key modules (Self-paced and Instructor command options)
  • Training schedule has been preparation with regularly updated contents
  • Project quality with Learning Management System (LMS)
  • 24x7 assistance and support
Project Support
  • Daily 2 hours session
  • 6 Days support per week

100% Secure Payments. All major credit & debit cards accepted.