+1 (201) 720-5410 (USA)

My Cart



1 Review(s)

Training Mode: Class Room / Live Online

myTectra the Market Leader in Informatica Training in Bangalore

myTectra offers Informatica Training in Bangalore using Class Room. myTectra offers Live Online Informatica Training Globally.

Training Objectives
After the completion of the Informatica Training at myTectra, you will be able to :
1. Understand and identify different Informatica Products
2. Describe Informatica PowerCenter architecture & its different components
3. Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
4. Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
5. Understand Workflow Task and job handling
6. Describe Mapping Parameter and Variables
7. Perform debugging, troubleshooting, error handling and recovery
8. Learn to calculate cache requirement and implement session cache
9. Execute performance tuning and Optimization
10. Recognize and explain the functionalities of the Repository Manager tool.
11. Identify how to handle services in the Administration Console
12. Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
13. Gain insight on ETL best practices using Informatica
Who should go for this Informatica Training?
The following professionals can go for this Informatica Training by myTectra :
1. Software Developers
2. Analytics Professionals
3. BI/ETL/DW Professionals
4. Mainframe developers and Architects
5. Individual Contributors in the field of Enterprise Business Intelligence
What are the pre-requisites for Informatica Training?
The pre-requisites for this Informatica Training at myTectra include basic knowledge of SQL.
Project Work Towards the end of this training, you will be working on a live project to perform data analytics.
Project #1 : Creation of Sales Data Warehouse
Industry : Retail
Data : NorthWind/AdventureWorks dataset.
Problem Statement : Creation of ETL jobs to build Sales Data Mart using Informatica.
Project #2 : Transaction Analysis for Retail
Industry : Retail
Data : Sales data from Real time retail project. ( Data will be masked)
Problem Statement : Analyzing Retail Transaction Information using Informatica.
Why learn Informatica? Informatica provides the market's leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today's market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.

1. Informatica PowerCenter 9.X - An Overview
Learning Objectives - In this, you will understand overview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor.
Topics - Identify different Informatica Products, Describe PowerCenter as a tool to perform Extract transform and load, Interpret PowerCenter Architecture, its different components and their functionalities, Explain the advantages of component based development techniques in PowerCenter.
2. ETL Fundamentals
Learning Objectives - In this module, you will learn about the ETL and the need behind it. You will also learn how to use Informatica PowerCenter tools to create simple ETL jobs.
Topics - ETL and ETL Architecture, Flat file and relational Sources using the Source Analyzer, Flat file and relational Targets using the Target Developer, Mappings using the Mapping Designer, Workflows using the Workflow Designer, Monitor the workflow using the Workflow Monitor, Preview Target Data using the PowerCenter Designer.
3. Informatica PowerCenter Designer
Learning Objectives - In this module, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping.
Topics - Describe & Visualize PowerCenter Designer, Explain how to create mapping in Designer, Explain different Transformations & their usage.
4. Informatica PowerCenter Workflow Manager & Monitor
Learning Objectives - In this module, you will learn about two more development units of Informatica PowerCenter namely Workflow manager & monitor and how are they used to create different tasks and workflow.
Topics - Understand PowerCenter Workflow Manager, Describe Flow within a Workflow, Describe Re-usability & Scheduling in Workflow Manager, Understand components of Workflow Monitor, Understand Workflow Task and job handling.
5. Advanced Transformation Techniques
Learning Objectives - In this module, you will understand Advanced Transformation techniques that will equip you to deal with advanced concepts of PowerCenter transformations like, Java, XML etc as well as the re-usability features of PowerCenter.
Topics - Understand the advanced features & functions of Transformations, Learn about Java Transformation, XML File handling, Learn to use Normalizer Transformation, Learn some advanced concepts of ETL, Learn about reusable objects in Informatica.
6. Parameters & Variables
Learning Objectives - In this module,you will learn that parameters and variables are a way to achieve re-usability from PowerCenter. This module will deal with the scope and use of Parameters & Variables.
Topics - Understand different Parameters and Variables used in PowerCenter, Describe Mapping Parameter & Variables, Learn to use Session Parameters, Learn to use Workflow Variables.
7. Debugging Troubleshooting Error Handling & Recovery
Learning Objectives - In this module, you will understand the operational part of the PowerCenter. This module will help you understand the features provided by Informatica to debug, troubleshoot & handle errors. The concepts of recovery will also be discussed.
Topics - Describe basic PowerCenter Error, Follow a basic troubleshooting methodology, Using the debugger, Use Workflow and Session logs to diagnose errors, Recognize & repair, Connection Errors & Network errors, Design Error Handling Strategies for intended purpose, Understand the recovery scenarios & mechanisms, Properly Configure Workflow & sessions for recovery, Understand the purpose of High Availability, Monitoring the PowerCenter Environment.
8. Caches
Learning Objectives - Caches play important part of any application. This module will help you understand the implementation of Cache by Informatica and how can they be used to accomplish performance efficient ETL jobs. The pros & cons will be covered.
Topics - Understand the session cache, Describe when and why cache is created, Implement session cache, Learn to calculate cache requirement.
9. Performance Tuning & Optimization
Learning Objectives - The most important concept for any application. Superior performance wins the race everywhere.This module will enlighten the performance aspects of Informatica PowerCenter components and the efficient usage of them.
Topics - Control how PowerCenter uses memory, Control how PowerCenter uses CPUs, Understand the performance counters, Isolate source, target and engine bottlenecks, Tune different types of bottlenecks, Configure Workflow and Session on Grid.
10. PowerCenter Repository Manager
Learning Objectives - More of a Administrators job. This module will tell you about the usage and components of PowerCenter Repository Manager.
Topics - Recognize and explain the functionalities of the Repository Manager tool, Describe how to create and delete folders using the Repository Manager tool, Illustrate how to migrate components using Repository Manager tool.
11. Informatica Administration Console & Security
Learning Objectives - At the completion of this module, you should be able to: Put in your own words an overview of the PowerCenter Administration Console, Recognize and explain integration and repository service properties. Identify how to handle services In the Administration Console, Explain how to handle locks through the Administration Console, and Illustrate how to create users and groups.
Topics - Put in your own words an overview of the PowerCenter Administration Console, Recognize and explain the integration and repository service properties, Identify how to handle services in the Administration Console, Explain how to handle locks through the Administration Console, Illustrate how to create users and groups.
12. Informatica 9.X - Technical Architecture
Learning Objectives - The technical architecture module has been carefully knitted to give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.
Topics - Understand Informatica 9.X Architecture, Describe the Application services related to PowerCenter and their related processes, Understand buffer memory, Describe Connectivity among the tolls, Describe Connection pooling used in PowerCenter.
13. Informatica Installation & Configuration
Learning Objectives - The installation and configuration process along with regular Administration and Operational jobs. The module is most suited for the persons interested into the architectural components of Informatica.
Topics - Step by step installation process, Configuration of different Informatica PC components and their set up, Backup and recovery, Operational procedures.
14. Command line utilities
Learning Objectives - This module will deal with Command line part of Informatica PC. The usage of most frequently used command line tools and their benefits will be discussed
Topics - Informatica frequently used commands, pmrep, pmcmd, infacmd, infasetup.
15. ETL Scenarios using Informatica
Learning Objectives - This module will deal with different day to day ETL scenarios and their implementation in Informatica PC.
Topics - SCD, XML Processing, Flat file handling, Different Transformations, For loop implementations in PC, Partitioning, Pushdown optimization, Constraint based loading, Incremental Aggregation.
16. Best Practices & Velocity Methodologies
Learning Objectives - The excerpt from best practices from Informatica Velocity methodologies will help you understand the efficient way of using different Informatica PC components effectively and efficiently.
Topics - ETL best practices using Informatica, Development Techniques, Error Handling, Data Migration, Performance Tuning.

To Learn Informatica Training in Bangalore using Class Room and Live Online Informatica Training Globally ENROLL TODAY at myTectra.

Customer Reviews

1 Item(s)

per page
Excellent Review by Veena
"It was very detailed training with good live examples.This teaching is more helpful for me to decide my future in right way."

1 Item(s)

per page

Only registered users can write reviews. Please, log in or register

myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


myTectra flexible batch schedules enables you to start your class at your convenient date and time.

1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time

Do you have any questions ? please call us on +919019191856 or email to [email protected]