£99 inc VAT
Or £33.00/mo. for 3 months... Read more
Study method
Online, self-paced
47 Hours
No formal qualification
Additional info
  • Tutor is available to students

1 student purchased this course

Add to basket or enquire


7 high-quality and relevant video-based Courses with 47+ hours of well designed, well-crafted study materials on Informatica, DAC, Teradata, ETL Tools, Power Center Designer, Filter Transformation, Router Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Lookup Transformation, Normalization, System Architecture, BYNET, RAID Technology, Fallbacks clusters. Learn by doing. Verifiable Certificate of Completion for Courses. Full Lifetime Access.

An Informatica is a tool which supports all the steps of Extraction, Transformation and Load process. It is also being used as an Integration tool. Informatica tool is easy to use. It has got a simple visual interface as like forms in visual basic. You just need to drag and drop a different object which is known as transformation and design process flow for Data extraction transformation and load. These process flow diagrams are called as mappings. Informatica server takes care of fetching data from a source, transforming it and loading it to the target systems or databases.

Informatica can communicate with all major data sources such as mainframe/ RDBMS/ Flat Files/ XML/ VSM/ SAP etc, can move or transform data between them. It can move large(huge) amount of volume of data in a very effective way. It can also do big updates in small chunks to avoid long locking and filling the transactional log. It can effectively join data from two different data sources even an XML file can be joined with a relational table. Informatica has got the ability to integrate heterogeneous data sources and converting raw data into useful information.

Informatica enables organizations to gain a competitive benefit in today’s global information economy by empowering companies with relevant and trustworthy data for their top business imperatives. In short, Informatica is world’s leading ETL tools and its rapidly acquiring market as an Enterprise Integration Platform.


Informatica Software Architecture:

Informatica Software Architecture illustrated Informatica ETL product which is known as Informatica Power Center. It consists of 3 main components that are:

1. Informatica PowerCenter Client Tools:

Following are the development tools installed at developer end. These Informatica ETL tools enable a developer to

– Define transformation process which is known as mapping.

– Define run-time properties for a mapping which is known as sessions.

– Monitor execution of sessions

– Manage repository, useful for administrators

– Report Metadata

2. Informatica PowerCenter Repository:

– Repository is known as the heart of Informatica tool. It is a kind of data inventory where all the data related to mappings, sources, targets etc is kept.

– Repository is the place where all the metadata for an application is stored.

– Without repository, Informatica client and server is same as a PC without memory or hard disk, which has ability to process data but has no data to process. This is treated as backend of Informatica.

3. Informatica PowerCenter Server:

– Server is one of the places where all the executions take place.

– Server makes physical connections to targets, fetches data, applies the transformations and loads the data in the target system.

Why is Informatica Training required?

Data is and has been from the beginning created, stored and retrieved by incompatible systems. Between 30% and 35% of all of the data in the industry is still on mainframes, in languages and data structures that are archaic and generally unavailable. The wave of specialty applications such as HR, sales, accounting, manufacturing has all contributed their share to the chaos.

The latest development-growth in outsourcing, in all kinds including business processes, IT management and geographic will add even more complexity to the mix. So how do we integrate data from the disparate proprietary systems and applications, the billions of lines of code, combined with the additional complexity of outsourcing etc… So now for all these, an answer is Informatica.

For all above reasons, knowledge of Informatics required. Informatica PowerCenter, an ETL tools of an Informatica works on basis of transformations which transform data in multiple ways. And also there is a reason for the necessity of an Informatica training. In a typical Data Warehousing environment, we use ETL tools like Informatica, SAS etc for extraction and cleansing and then using some Teradata utility. While the data load from ETL tools like Informatica, it is quite slow in execution as compared to Teradata utilities.

The use of Informatica is just as we need to extract and cleanse data first before loading. So if we use Informatica tool for extraction and then use Teradata utilities for loading which may be the fastest solution.

Informatica Training Goal and Objective

The primary goal of this course is to prepare students for a successful professional career in the Informatica.

To get a good knowledge of Informatica tool.

This course contains over 17 lectures and 2 hours of content.

Learn the basic concepts, skills, and knowledge of Informatica

Tremendous insight into the data integration platform

Distributing the publication abroad on a contract of subscription and orders.

students will be exposed to Informatica Velocity, troubleshooting techniques and the use of technical support options

Who works in other technology but interested to learn Informatica tool, for them online learning platform is best because it saves time and other efforts.

Developers who are new to Informatica require to implement data integration projects, exposing core features of PowerCenter, through lecture and hands-on exercises

After completing the course, a participant can fluently work on Informatica tool.

In simple words, the main objective is to make you awesome in Informatica technology.

Target Audience for Informatica Training

Database developers who are interested to learn Informatica


New developers who are interested to learn Informatica technology.

Informatica or ETL tools beginners who want to learn more about the framework and best practices.

All programmers or any IT Professionals

Students who want to learn Informatica tool or technology from scratch

All developers

Computer Science Graduates

Any experienced developer who has worked on Informatica technology.

This online training course has been prepared for the beginners to help them to understand the basic to advanced concepts of Informatica tool.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.


Currently there are no reviews for this course. Be the first to leave a review.


What does study method mean?

Study method describes the format in which the course will be delivered. At courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.


Mobile Navigation