About the Course
Data warehouses are widely used within the largest and most complex businesses in the world. Use with in moderately large organisations, even those with more than 1,000 employees remains surprisingly low at the moment. We are confident that use of this technology will grow dramatically in the next few years.

ETL is one of the main processes in data warehousing. ETL means extract transform and Load data into data warehouse.Informatica is ETL tool. It is very flexible and cheaper as compared to other ETL tool.

Today Following IT companies are using Informatica as ETL tool

1) IBM

2) Accenture

3) Amdocs

4) CTS

5) HSBC

And Many more

Introduction to Informatica

Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information

Informatica is not only ETL tool but also Data integrator.Informatica is one of the Best tool in current industry provides versatile solutions to any kind of data.In Radical we provide scenario based training with real time examples, project explanation, project related queries.
Any one who is having basic knowledge of SQL queries can start learning Informatica tool.
As it is a GUI based tool, coding knowledge wouldn’t be necessary.At least 1-3 yrs of experience is good enough to get interview calls.