Get in touch: 080 4711 2411
Request Demo
Get in touch: 0800 800 123

Informatica Training

Informatica Training in Bangalore Offered by myTectra is the most powerful Informatica Training ever offered with Top Quality Trainers, Best Price, Certification, and 24/7 Customer Care. 

Learn Virtually Anywhere. Get Started informatica Online Training Now!

7000+ Learners
Expert Trainers
Verified Certificates
Realtime Projects
Individual Focus
Flexible Schedule
Download Syllabus Request Demo
informatica-training

20% Limited Time Offer

Describe your image

Unlock the benefits

Till Dec 05th, 2025

Unlock the benefits

Learn Virtually Anywhere. Award-Winning Training Company.

High-Quality Training Awaits You

Join over 100000+ learners who have taken up training with myTectra. Get High-Quality Training, Certification, Best Price and 24/7 Customer Care.

Key Program Highlights:

  • Delivering top-notch education to equip you with essential skills.
  • Learn from industry experts with real-world experience.
  • A thorough curriculum covering all necessary topics.
  • Dedicated support to help you secure job placements.
  • High ratings reflecting our commitment to quality.
  • Hands-on experience through real-world projects.
  • Personalized, engaging learning for better outcomes.
award-2015
award-2016
award-2017
award-2018
award-2019
mytectra-south-india-excellence-awards-2025
award-2015
award-2016
award-2017
award-2018
award-2019
mytectra-south-india-excellence-awards-2025
awards-icon
Start Learning with the Best!
Join our award-winning courses today and take your skills to the next level.
Enroll Now!

About Program

Informatica Training will enable the participants to work with Informatica PowerCenter tools. Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations. 

The training will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the end of the 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.

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

Curriculum:

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Command-line utilities:

  • Learning Objectives - This module will deal with the 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.

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.

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.
pdf-icon
Download the brochure
All details included
Download

Join the Course Now!
Path to Success

Learning Path

Master new skills to achieve your career goals.

Demo Session

Participate in a demo session for an overview of the course content. You will meet instructors and fellow learners, ask questions, and understand the teaching approach, helping you gauge the course’s relevance to your goals.

Enrollment

Complete your registration to join the course. You will gain access to the Learning Management System (LMS), where all materials, schedules, and resources are available, ensuring you’re ready to embark on your learning journey smoothly.

Live Classes

Engage in live classes led by experienced instructors covering core topics in depth. Interactive discussions and Q&A sessions encourage active participation, enhancing your understanding and retention of the material taught.

Hands-On Project

Complete a hands-on project that applies your learned skills in practical scenarios. This project simulates real-world challenges, allowing you to build a portfolio piece that showcases your competencies to potential employers.

Certification

After completing the course and project, you will receive a recognized certification that validates your expertise and enhances your professional credentials in your chosen field.

Career Support

Access career support services after certification, including resume workshops, interview preparation, and job placement assistance. These resources equip you with the tools needed to transition successfully into the workforce.

Clients Testimonials

Hear what our students say about myTectra

“I did the Python & Django course in myTectra. myTectra also gave me the opportunity to work on a real-time project which helped me a lot to get my concept throw. myTectra also provided me the placement in the company for the course I did in mytectra.”
prinjal
Prinjal
Python
“I am from Robert Bosch and have taken up Python Flask corporate training from myTectra. I am very much satisfied and happy with this customized training. The tutor was extremely helpful and flexible and provided the best insightful training.”
princy
Princy
Python Flask
“I have done Java Full Stack developer course in myTectra. myTectra has supported me in all possible ways. I have excellent knowledge of the course. mytectra has given all practical knowledge with real-time problems and examples”
sunita
Sunitha
Java Full Stack Developer

Hear from Our Successful Learners!

Discover how myTectra transformed their careers—your success story could be next!

Get Inspired

Course Features

Expert Trainers

Courses are delivered by experienced working professionals and subject matter experts with real-world experience.

Hands-On Training

We provide learners with practical experience through real-world scenarios, projects, and interactive exercises.

Customizable Corporate Training

Tailored training solutions designed to meet the specific needs of organizations and teams.

Certifications & Assistance

Certifications offered by myTectra align with international standards and we also help you to prepare for globally recognized certifications.

Global Recognition

Trusted by individuals and enterprises worldwide, with a track record of successful alumni and partnerships.

24 x 7 Expert Support

We have a 24x7 online support team to resolve all your technical queries, through a ticket-based tracking system, for a lifetime.

Gain prestigious credentials and recognition

mytectra-certificate

 

Global Accreditation
Recognized Credentials
Verify Certificate

Start Learning Today. Access Your Resources for a Lifetime!

Enjoy lifetime access to myTectra’s Learning Management System (LMS), including session recordings, study materials, and resources. This ensures continuous learning and easy reference to course content even after completion.

Lifetime Access
24/7 Assistance
Login LMS

Resume Preparation Made Professional and Impactful

Get expert guidance in crafting a professional and impactful resume. myTectra’s resume-building support helps highlight your strengths, certifications, and skills effectively, increasing your chances of landing your dream job.

Job-Ready Resume
Resume That Stands
Get Resume Help

Prepare for Success with Expert Mock Interviews

Prepare for real-world interviews with personalized mock interview sessions conducted by industry experts. Receive feedback on your performance, learn key interview techniques, and gain the confidence to succeed in job interviews.

Simulate Real Interviews
Boost Your Confidence
Request Mock Interview

FAQs

How do I contact myTectra for Corporate Training?

Would you like to reach us for the training for your team? Please fill the below form. We will get back to as soon as possible.

Will I get placement assistance?

myTectra is providing 100% placement assistance on our key courses. We help you with the career counselling, Exams on Key courses, Mock Interviews and Technical Interviews Tips.

Landing an interview proves that you have the job-specific skills for the position, but how do your interview skills stack up? Also, Soft skills are often the most important factor in showing you're the best candidate for the job.

Hence we are conducting FREE TRAINING on Soft-Skills worth Rs-25, 000 to all myTectra students which will help you to attend the interviews with more confidence. 

What if I miss a class?

You will never miss a lecture at myTectra. You can choose either of the two options:

Classroom Training:

  • If you miss one or few classes we can give a backup class based on trainer and your convenient time. 
  • In case if you miss many classes, we can reschedule your class with upcoming batches or other running batches based on how many courses topics you have completed so far.

Live-Online Training:

  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch.
Can I attend a demo session before enrollment?

Yes. We arrange a free demo for all the courses either in the Classroom or Live-Online demo. Please fill the demo request form below to schedule a free demo.

What if I have more queries?

Just give us a CALL at +918047112411 OR email at support@mytectra.com

What are the payment options?
Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email for both classroom training and Online training.
 
  • Visa Debit/Credit Card
  • American Express and Diners Club Card
  • Master Card
  • PayPal
  • Net Banking/Wire Transfer
  • UPI Payment such as Google Pay, PhonePe, Paytm
  • Cash/Cheque/DD ( Not for Online Training )
Where do the classes take place?

For Individual: 

Classroom Training - Bangalore

Live-Online Training - Globally 

For Corporates: 

Classroom Training - We deliver classroom training for corporate in more than 20 countries. Send us an Enquiry Now!

Online Training - Globally

* All of the classes are conducted live online. They are interactive sessions that enable you to ask questions and participate in discussions during class time. We do, however, provide recordings of each session you attend for your future reference.

Who are the Trainers?

Our Trainer’s are chosen not only for their knowledge and expertise but also for their real-time experience in the respective courses.

Back to top
Ready to Start

Get Certified in Informatica with myTectra’s Expert-Led Training Programs

Get Started

Related Programs

Adobe Customer Journey Analytics
4k+ LearnersLearn more →
Adobe Experience Platform
5k+ LearnersLearn more →
Adobe Experience Manager
10k+ LearnersLearn more →
Adobe Real-Time CDP
1k+ LearnersLearn more →
Adobe Analytics
7k+ LearnersLearn more →
Adobe Campaign Classic
8k+ LearnersLearn more →
Adobe Campaign
7k+ LearnersLearn more →
Adobe Target
2k+ LearnersLearn more →
Adobe Launch
2k+ LearnersLearn more →
Adobe Commerce (Magento)
2k+ LearnersLearn more →
Adobe Marketo Engage
2k+ LearnersLearn more →
Adobe Workfront Training
1k+ LearnersLearn more →
Adobe Audience Manager
1k+ LearnersLearn more →

Career Services

subscribe-mytectra
placement-icons
Placement Assistance
job-portal-icon
Exclusive access to myTectra Job portal
mock-interview-icon
Mock Interview Preparation
linkedin-icon
Resume & LinkedIn Profile Building
soft-skill
Access to Soft Skill Enhancement
career-guidance-icon
One-on-one career guidance

Land Your Dream Job Like Our Alumni

Related Blogs

Explore Insights and Tips for Informatica

Mastering Data Integration: A Guide to Informatica's PowerCenter
Mastering Data Integration: A Guide to Informatica's PowerCenter
Informatica

Mastering Data Integration: A Guide to Informatica's PowerCenter

Aug 5, 2023 3:40:57 PM 3 min read
Informatica: Empowering Businesses with Data Management
Informatica: Empowering Businesses with Data Management
Informatica

Informatica: Empowering Businesses with Data Management

Aug 5, 2023 3:40:41 PM 3 min read
Everything You Need to Know About Informatica Training
Everything You Need to Know About Informatica Training
Informatica

Everything You Need to Know About Informatica Training

Aug 5, 2023 3:40:25 PM 4 min read
Explore More

Find Informatica Course in Other Cities

Informatica Training in Bangalore

Yes, myTectra offers Classroom Training in Bangalore on Informatica and Live-Online Training globally.

Informatica Online Training

Yes, myTectra provides Live Online Training on Informatica for learners across the globe.

Informatica Training in Marathahalli

Yes, myTectra offers Classroom Training in Marathahalli - Bangalore on Informatica and Live-Online Training globally.

Best Informatica Institute in Bangalore

Yes, myTectra provides the best Classroom Training in Bangalore on Informatica and Live-Online Training globally.

Informatica Training in BTM

Yes, myTectra offers Classroom Training in BTM Layout 2nd Stage - Bangalore on Informatica and Live-Online Training globally.

Professional Informatica Training with Certification

Yes, myTectra provides Professional Informatica Training in Bangalore with certification, along with Live-Online Training globally, equipping you with the skills to manage ETL processes and data integration effectively.