Informatica ETL Training

Training Mode - Class Room / On Line.

  1. Class Room / On Line Session.
  2. Class Room : Small Batch Size.
  3. Online : Individual.
  4. Practical Project Based.
  5. Experienced Trainer.
  6. 80 hrs Video Tutorials.
  7. 24 hrs On Line Support.
  8. Links to Download Examples.
  9. Assignments Links.
  10. Placement Support.
  11. Flexible Timings.
  12. National Skill Development Corporation (NSDC) Certificate.

About Course :

Under Flagship of Pradhanmantri Kaushal Vikas Yoyna (PMKYV) to make Aatm Nirbhar Bharat by providing Job Skills We have launched Basic to Advance Level Complete Stack Informatica Powercenter course designed by Experienced ETL Developers for Candidates who want to make career in Dataware Housing, Business Data Analysing and Business Data Development. Training is 100% Practical Project based in which we start from basic Elementary and gradually move to Advance level covering complete Powercenter ETL Development with Unix Commands and PL/SQL. All our Trainers are B. Tech / MCA with 5+ years of expert knowledge.

What you will Learn :

Informatica Development

Introduction to Data warehousing

  1. Overview of a DWH
  2. Need of a data warehouse
  3. Data warehouse layer architecture
  4. OLTP/Transactional system and OLAP
  5. Meta Data, Granularity, Data Mart
  6. Design approach Top down/Bottom up
  7. Designing a warehouse using Star/Snowflake schemas
  8. Dimension
  9. Fact
  10. CDC approach

Introduction to Informatica/ETL tools

  1. The role of ETL tools in data warehousing
  2. An introduction to Informatica
  3. Informatica Architecture
  4. Components/Process flow

Informatica Designer

  1. Basic Concepts
  2. Using the designer
  3. Working with the Sources-Source Analyzer
  4. Working with Relational/Flat file targets- Warehouse Designer
  5. Defining Keys in Informatica
  6. Working with Transformations –Transformation Developer
  7. Working with Mapplets- Mapplet designer
  8. Creating mappings –Mapping Designer
  9. Understanding Pipelines in mappings
  10. Setting Target Load order
  11. Configuring Constraint Based loading
  12. Introduction to Mapping Parameters/Variables
  13. Implementing Type1, Type2, and Type3 Mappings

Working with Transformations

  1. Active/Passive Transformations
  2. Connected/Unconnected Transformation
  3. Importance of Source Qualifier
  4. Filter, Router
  5. Expression
  6. Sorter, Aggregator
  7. Rank
  8. Joiner
  9. Lookup
  10. SQL
  11. Stored Procedure
  12. Sequence generator
  13. Union
  14. Update Strategy
  15. Xml transformation

Creating Workflows

  1. Understanding the server Architecture
  2. Working with Workflows
  3. Working with Tasks Assignment,Command,Decision,Control,Event raise,
  4. Event Wait,Timer,Email,Session Task
  5. Working with Work lets
  6. Working with Sessions
  7. Understanding Commit Points
  8. Recovering Data
  9. Monitoring Work flows
  10. Using Multiple Servers
  11. Log files
  12. Row Error Logging
  13. Session parameters
  14. Parameter files
  15. Using Incremental Aggregation

Basic oracle and unix only for interview point of view

Mini project

Interview question and scenario

Company Details.

Company is Registered under Ministry of Corporate Affairs , Govt. of India.

Find Company Details at Official Website of : Ministry of Corporate Affairs
Company Name : R. M. Infotech Private Limited
LLPIN/CIN/1A Ref No : U72200DL2005PTC138996
Registration Date : 22/07/2005

Find TAN / PAN Number at Official Website of : Income Tax Department.
Category : Company
State : Delhi
Search by Name : R. M. Infotech Private Limited
TAN number : DELR13732F
PAN Number : AAIFR5022M


332 A (Basement Floor), Street No - 6, Mohan Park
West Guru Angad Nagar
Laxmi Nagar, New Delhi - 110092.
Tel : 011-22541165, 011-22457654.
Email: roli.hr@rminfotechsolutions.com , paragguide@yahoo.co.in
Note : We do not have any other branch.


Google Map - Locate Us