ETL (Extract, Transform and Load) is a process used in data warehousing which is responsible to pull data out of source systems & place it into a data warehouse. ETL involves the following tasks in process:

  • Extracting the data
  • Transforming the data
  • Loading the data

There are many ETL tools available in market. The main advantage of using ETL tools is that they are optimized for the ETL process as they provide connectors to data sources like databases, files, xml, mainframe systems etc.

Informatica is a powerful ETL tool which supports all type of extraction, transformation and load (ETL) activity. Informatica has a simple visual interface, so that user can use any type of source for extracting data and load the data in desired format like database files etc.

Why ETL – Informatica Training? A leading tool Informatica works on base of transformations in multiple ways i.e. Source qualifier, expression, sorter and aggregator, transaction control, lookups, update strategy expressions, java transformation etc. ETL – Informatica training provides you basic skills and knowledge require for implementing data integration projects, exposing core features, through lecture and hands-on exercises & also you will learn data migration projects by learning the core features of Informatica.

Why Training Institute Pune? Our ETL / Informatica Training course in Pune will let you learn the complete Data Warehousing Concepts in easier way. Here at Training Institute Pune, we will help you to be a expert in this tool with interactive sessions. The training sessions will be covered by expertise trainer working with live ETL projects thus provide you basic and advance level knowledge of ETL tool used in today’s business.


  • IT professionals
  • Manual & Automation Tester’s
  • Basic knowledge of SQL
  • Database Developers/Administrators


  • 100% Job Assistance
  • A technology oriented professional trainer having 5+ years of experience in Data Warehousing.
  • Learn from the basics to advance level of ETL & Informatica tools.
  • Personal attention given to each & every participant during the training program
  • Live Projects to get hand-on knowledge.
  • Batches with limited seats
  • Weekend batches as per your suitability.
  • Two training centers for your convenience: Kothrud and Wakad
    • If you are located in Kothrud or nearby areas like Karve Nagar, Warje-Malwadi, Bhusari Colony, Shivaji Nagar etc. then our branch in located a short distance away from you i.e. Vanaz Corner, Kothrud.
    • If you are located in Pimpri Chinchwad or nearby areas like Pimple Saudagar, Wakad, Chinchwad, Balewadi, Sangvi, Dapodi etc. then you can visit our branch in Wakad near Kalewadi Phata.


Overview of Informatica Course is as listed below. Contact for at our office phone number or Mail- ID for detailed syllabus and any query.

Informatica Course Content:
Informatica Power Center Contents

  • Introduction & History of Informatica.
  • Advantages of Informatica compare to traditional coding.
  • Extraction, Transformation and loading process.
  • Informatica Power Center Architecture.

Informatica Components

  • Server
  • Client

Server Components

  • Integration Service.
  • Repository Service.
  • Reader & Writer DTM.

Client Components

  • PC Designer.
  • PC Workflow Manager.
  • PC Monitor.
  • PC Repository Manager.


  • Router
  • Joiner
  • Expression Transformation.
  • Rank Transformation.
  • Sorter Transformation.
  • Aggregator Transformation.
  • Lookup Transformation.
  • Union T/F.
  • Normalizer transformation.
  • Update strategy.
  • Sequence Generator transformation.
  • Transaction control.
  • SQL Transformation.
  • Non reusable transformations.
  • Reusable transformations.

Power center workflow manager

  • Workflow Tools.
  • Workflow Structure and configuration.
  • Workflow Tasks.
  • Workflow Design and properties.
Performance Tuning
  • Overview of System Environment.
  • Identifying Bottlenecks .
  • Source Level
  • Target Level
  • Mapping Level
  • Data Base level
Advanced topics
  • Normal Load & Bulk Load.
  • Incremental Load.
  • CBL Loading.
  • Target Load Ordering.
  • Dynamic Lookups.
  • SCD types, 1,2,3.
  • Mapplets & Worklets.
  • Limitations of Mapplets.
  • Pushdown Optimization.
  • Unit Testing.
  • Export and import of objects
  • Debugger
  • Versioning
  • Parameters & variables
  • Enable Test load
  • Commit Types
  • Over View PMCMD & PMREP Commands
  • Pre SQL’s and Post SQL’s
  • Target Over ride
PC workflow tasks
  • Session
  • Email Task
  • Command task
  • Control Task
  • Timer Task
  • Worklet
  • Decision Task
  • Event Wait
  • Event Raise
  • Assignment task
  • Link Conditions
Concurrent and sequential Workflows
  • Concurrent Workflows.
  • Sequential Workflows.
  • Stopping, Starting and suspending tasks and workflows
  • Scheduling of workflows.
Data Warehouse Concepts
  • Basics of DWH.
  • Data Mart.
  • Data Modeling.
  • Star Schema.
  • Snow Flake Schema.
  • Types of Facts and Fact Tables.
  • Types of Dimensions.
Additional Contents
  • Informatica cd.
  • Informatica Installation.
  • Unix Commands.
  • Unix Shell scripting.
  • Interview questions.
  • Resume writing tips.
  • All advanced topics.
  • Informatica certification Assistance.
  • Informatica blogs.
  • Informatica scenarios.


"Professional and well qualified trainer is giving ETL Informatica training course here. One of best service by them is that ETL Classes are on weekends which best suited me."

“I am pursuing in this institute which was ETL Course of 5 Weekends. The faculty is friendly with teaching and helps me clearing the doubts after the session. I feel glad to join ETL Training here. ”

“Nowadays, strong knowledge for any course is required to get a good career start. So I have enrolled here for ETL course. The course is completed and I am grateful to the tutor.”

“While looking for institutes for Informatica course, I found ‘Training Institute Pune’ and joined for the same. Instructors are encouraging the students a lot. Happy with training facility. ”

“I have joined ETL Informatica Class at Training Institute Pune. While enrolling we expect a knowledgeable faculty to teach us & Yes! Training Institute do provided me with excellent trainer. I am gratified with their coaching. ”


  1. What is ETL & Informatica?

ETL refers to a process in database usage especially in data warehousing. Process is executed as:

  • Extracts data from homogeneous or heterogeneous data sources.
  • Transforms the data for storing it in proper format for querying and analysis purpose
  • Loads it into the final target like databases or data warehouse etc.

Informatica is an ETL tool is market leader in data integration and data quality services. It has capability to manage, integrate & migrate an enterprise data.

  1. Who should go for ETL & Informatica training program?

IT Professional who are working as a manual testers & who want to explore career in ETL Testing can undergo training course.

  1. What is the duration of the courses?

4 weekends| 2-3 Hrs. (Sat-Sun)

  1. Can I get Job assistance after I complete the ETL & Informatica course?

Yes! You will be offered 100% Job Assistance after completion of course.

  1. Why should I choose Training Institute Pune for ETL & Informatica Classes in Pune?
  • Classes are limited to 10 students to provide personalized training instead of huge batch system.
  • Learn latest methodologies
  • Provide hands-on training on live projects.
  • Offer Internship programs mostly beneficial for job seekers.
  • We provide training and consulting services.
  • Weekend batches best suited for students or working professionals
  1. How can I enroll to ETL & Informatica course?

After completing inquiry for ETL & Informatica course you can enroll yourself by registering online OR manually. Our consultant will guide you for enrolling process.

  1. Do you offer flexible timing for working professionals?

Yes! We organize a weekend batches with flexible timing for training sessions as per requirement of candidate.

  1. Do you have any training center other than Kothrud location in Pune?

Yes! We have another Informatica training center located at Wakad near Kalewadi Phata in Pune. You can check out address on our Contact Us Page.