Any questions? Call us +91-9325793756

Destination Center,Second Floor,Magarpatta City,Pune

Informatica Developer

Informatica Developer



Informatica Developer mostly works on requirements, which is to load data from source to respective target systems (Preferably DWH or Data integration). There is always a demand for Good Informatica Developers who understands the Standard Functionality of data and meets the Gaps of Business by adding custom Enhancements.

In your study of Linguistics, you will be introduced to the analysis of the nature and structure of human language (including topics such as how words and sentences are formed.

Course Content of Informatica Developer at Informatica Training Academy

Trainer’s Profile
Introduction to Data warehousing
  • What is Data warehousing?
  • Who needs Data warehouse?
  • Why Data warehouse is required?
  •  Data warehousing Architecture
  •  Source
  • Integration Layer
  •  Staging Area
  • Targets
  •  ODS
  • What is a Dimension?
  • What are Facts?
  • Hierarchies
  • Star Schema
  •  Fact Table
  • Dimensional Tables
  •  Snow flake Schema
  • Fact less Fact Table
  •  Confirmed Dimensions
  • Informatica 9
Introduction to Informatica
  • Overview
  • Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders – Sub Folders
  • Informatica Designer – Introduction
  • Introduction to designer
  • Designer interfaces
  • Designer tools
  • Defining Sources
  • (i) Database as a source (ii) Flat Files sources
  • Defining Targets
  • (i) Importing from database (ii) Creating a new target (iii) Creating target database objects
  • Informatica Designer
  • Mapping Introduction
  • Source Qualifier
  • Ports
  • Mapping – Table to Table
  • Mapping flat file to Table
  • Connected / Unconnected Transformations
  • Active and Passive Transformations
  • Source Qualifier Transformation
  • SQL override in Source Qualifier Transformation
  • Mapping Source Qualifier as Filter
  • Source Qualifier to join data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored Procedure Transformation
  • Connected and unconnected Transformation
  • Union Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II and Type-III mappings
  • Informatica Workflow Manager
  • Workflow Introduction
  • Tasks
  • Workflow Tools
  • Connections
  • Defining Tasks
  • (i) Command Task (ii) Email Task (iii) Session Task (iv) Link Conditions (v) Event Wait & Event Raise
  • Setting properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Informatica Advanced Features
  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint Based Loading
  • Mapping Parameters
  • Mapping Variables
  • Session Parameters
  • Link Conditions
  • Meta Data Backup & Restore
  • Copying Repository

Trainer’s Profile

Trainer is working as a Senior Consultant from Reputed MNC’s with 10+ years of Consulting and Training Experience.

Course Duration

2 Month (Around 40+ Hours) of Class Room Training, Classes will be conducted during morning, evening, or weekends. Duration of the class would be 1 – 4 Hours (depends on Weekdays or Weekend Batch)

Course Fee:

20,000 INR

Trainer’s Contact Details

+91-9325793756 (

Mode of Training

This would be class room Training with Practical hands on system. So what’s we teach as per theory we show every steps and Process on the system. We recommend our student to concentrate much on Practice and get more Hands on.

Informatica Access

Informatica Training Academy will Provide Informatica Software (Valid Learning License) and that will be installed in your personal laptop for the Practice.

Books and Study Material

Informatica Training Academy will provide all Study Material and Books for this course in Soft Copy format

Self-Practice Required

If you are looking to get into Informatica Development role so please dedicated 150-250 Hrs.’ of Self-study and Practice in order to get command on the system and then only you can easily clear Interviews.

Background Need to get into this course

This course suits to the people who are coming from Technical Background (BE, MCA, BCA, MCS etc.). If you have any Prior knowledge of any Database (Oracle/Teradata/sql server etc.), this will help you to understand the course better.

Informatica Training Academy Social Networks:

Informatica training Academy © 2017 All Rights Received.