Informatica Training And Certification

Informatica Training & Certification

OL Tech Edu Informatica Training will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. Throughout our Informatica Training Course, you will be working on real-life industry-based use cases.

Sports, Citrix, UST Global, Mindtree, TCS, Wipro, Infosys & other MNC's use Azure across industries.

Microsoft Aims for $20 Billion Cloud Sales Run Rate in 2018 - Satya Nadella, CEO.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Informatica Training Certification UpComing Batches

Nov-22 - Jan-03

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-15 - Dec-27

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-04 - Jan-15

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

Informatica Training and Certification

SELF PACED

OL Tech Edu's Informatica Training will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. Throughout our Informatica Training Course, you will be working on real-life industry-based use cases.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Informatica Training Will Help

Learning Objectives: In this module of Informatica Training, we will talk about the different Informatica Products available along with understanding the overview of Informatica PowerCenter Product, Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows, and Workflow Monitor. We will also discuss the installation of Informatica in this module. 

Topics:
  • Informatica & Informatica Product Suite.
  • Informatica PowerCenter as ETL Tool.
  • Informatica PowerCenter Architecture.
  • Component-based Development Techniques.

Hands-On/Demo:
  • Installation of the Product in Windows and using Oracle as Database.
  • Creation of the Services and Connecting the client to the server.

Learning Objectives: In this module of Informatica Certification Training, we will discuss different Data Integration Concepts. You will be introduced to the concepts - Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing. 

Topics:
  • Data Integration Concepts.
  • Data Profile and Data Quality Management.
  • ETL and ETL Architecture.
  • Brief on Data Warehousing.

Hands-On/Demo:
  • Look through the Properties of the Services Required.
  • Shutdown and Start-up of the Services from the Administration Console.
  • Creation and Execution of a Simple pass-through Mapping.

Learning Objectives: In this module of Informatica Certification Training, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping and transformations. 

Topics:
  • Visualize PowerCenter Client Tools.
  • Data Flow.
  • Create & Execute Mapping.
  • Transformations & their Usage

Hands-On/Demo:
  • Use multiple transformations inside the mapping to resolve different use cases.
  • Look at the properties of the transformations to customize them.

Learning Objectives: In this module of Informatica Certification Training, you will learn about development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and workflow. 

Topics:
  • PowerCenter Workflow Manager.
  • Flow within a Workflow.
  • Reusability & Scheduling in Workflow Manager.
  • Components of Workflow Monitor.
  • Workflow Task and Job Handling.

Hands-On/Demo:
  • Create Tasks, Workflow.
  • Configure Workflow Properties.
  • Schedule a Workflow.


Learning Objectives: Through this module of Informatica Certification Training, you will learn about Advanced Transformation techniques which will equip you to deal with advanced concepts of PowerCenter transformations like Java, XML etc. We will also discuss various Error Handling, Transaction Processing & Reusability features available in Informatica. 

Topics:
  • Advanced Transformations (Java, SQL, Normalizer).
  • XML File Processing & Transaction Processing.
  • Error Handling Features.
  • Cleaning the Data (Advanced Functions, Regular Expressions).
  • Reusability Features.

Hands-On/Demo:
  • Use of Advanced Transformations like XML Processing, Union etc.
  • Use of Inbuilt and Custom Functions to fulfill the data Transformation needs.
  • Reusable Transformations, Sessions, Mapplets, etc.


Learning Objectives: In this module of Informatica Training, we will discuss advanced ETL scenarios using Informatica. You will be introduced to the concepts - Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change Data Capture) etc. We will also discuss creating Data Warehouses related processes like SCD, Fact and Dimension Loading. 

Topics:
  • Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
  • Advanced Techniques - Flat File, XML File.
  • Loading Dimensional Tables (SCD-1, SCD-2, SCD-3).

Hands-On/Demo:
  • Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
  • Advanced Techniques - Flat File, XML File.
  • Loading Dimensional Tables (SCD-1, SCD-2, SCD-3).


Learning Objectives: In this module of Informatica Training, you will understand the features provided by Informatica to debug, troubleshoot & handle error to understand the inner workings and responsibilities of the operational role. Various PowerCenter recovery options and for tasks and workflows will be discussed along with the recommended best practices to the operations process. 

Topics:
  • PowerCenter Error.
  • Basic Troubleshooting Methodology.
  • Debugger.
  • Workflow and Session Logs to Diagnose Errors.
  • Connection Errors & Network Errors.
  • Recovery Scenarios & Mechanisms.
  • Configure Workflow & Sessions for Recovery.
  • High Availability.
  • PowerCenter Environment.

Hands-On/Demo:
  • Perform Troubleshooting of Informatica Errors.
  • Use of Debugger to debus a Mapping.
  • Perform Workflow, Session Recovery and Related Configuration needed for that.


Learning Objectives: This module of Informatica Certification Training, highlights the performance aspects of Informatica PowerCenter components and the efficient use of them. We will also discuss about the best practices suggested by Informatica for optimum performance of your ETL process. 

Topics:
  • Performance Tuning Methodology.
  • Mapping Design Tips & Tricks.
  • Caching & Memory Optimization.
  • Partition & Pushdown Optimization.
  • Design Principles & Best Practices.

Hands-On/Demo:
  • Identify the Bottlenecks.
  • Different Configurations needed to Resolve the Bottlenecks.
  • Learn Tips and Tricks to Code Efficient Mappings.
  • Cache and DTM Buffer Memory Configuration.


Learning Objectives: This module of Informatica Training will introduce you to the usage and components of PowerCenter repository manager. You will also learn to migrate and manage the repository effectively. 

 Topics:
  • Repository Manager Tool (Functionalities, Create and Delete, Migrate Components).
  • PowerCenter Repository Maintenance.

Hands-On/Demo:
  • Get Acquainted with the Repository Manager Tool and its Functionalities.
  • Creation and Editing of a Folder.
  • Copy Informatica Objects.
  • Historical view of Session and Workflow Statistics.


Learning Objectives: This module of Informatica Certification Training, will give you an overview of the PowerCenter administration console, recognize and explain integration and repository service properties. We will also discuss about the command line utilities and use them to manage the domain and repository, start and control workflows. 

Topics:
  • Features of PowerCenter 10.
  • Overview of the PowerCenter Administration Console.
  • Integration and Repository Service Properties.
  • Services in the Administration Console (Services, Handle Locks).
  • Users and Groups.

Hands-On/Demo:
  • Learn Details of Different Components of Informatica Administration tool.
  • Create User, Group, Assign Privileges to the Users and Groups.
  • Create Roles.
  • Looking at the Service Logs, Taking Export of the Service Logs.
  • Service Maintenance from Administration Console.


Learning Objectives: This module of Informatica Certification Course deals with command line part of Informatica PowerCenter. You will learn to automate the tasks from the command line as well. 

Topics:
  • Infacmd, Infasetup, Pmcmd, Pmrep.
  • Automate Tasks via Command-line Programs.

Hands-On/Demo:
  • Use Infacmd, infasetup, pmcmd, pmrep to automate tasks via command-line programs.


Learning Objectives: This module of Informatica Certification Training will give you the detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular. 

Topics:
  • Informatica 10 Architecture.
  • Application Services.
  • Buffer Memory.
  • Connectivity Among the Tolls.
  • Connection Pooling.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Projects

Which projects are included in OLTechEdu Informatica Training Course?

Project 1. Build Decision Support System for A BankDomain:- Banking-Problem statement:- A Bank s management committee wants to understand their business needs, customer’s requirement in detail and more accurate manner.

What are the system requirements for this Informatica Training?

Hardware Requirement(s):- Memory – Minimum 16 GB RAM, processor – Intel Core i5 CPU @2.00 GHz or above, Storage – 250 GB HDD/SDD or above, Software Requirement(s):- Operating System – Windows 7 or above, Ubuntu 14 or above, Latest Version of Oracle Virtual Box Installed, Windows PowerShell 4.0 or above (Install Azure Module), Microsoft Azure SDK for .NET v2.9 (prefer latest).

How will I execute projects in this Informatica Training Course?

We will help you install the software on your system. The installation manual for installation into Windows system will be provided with step by step execution along with screenshots.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

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

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers