Course Overview

Tekslate - The leading online IT training institute with experienced instructors and is well equipped with advanced labs. We provide best Informatica training that will help you master Data Integration concepts including Data Mining and ETL using Informatica PowerCenter. You will be working on real-life industry-based use-cases throughout the course.

Highlights

25 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

4.6

4.5

4.6

4.7

Informatica Course Curriculum

Introduction to Informatica

Basic Definitions
Informatica Products
Informatica Architecture
Tools and their roles
Folders -subFolders
Power Center I Power Malt
Introduction to designer

Informatica Designer -Introduction

Designer interfaces
Designer tools
Defining Sources
Database as a source
Rat Flies sources
Defining Targets
Importing from database
Creating a new target
Creating target database objects
Mapping Introduction
Informatica Designer

Source Qualifier

Ports
Mapping -Table to Table
Mapping flat File to Table
Connected/Unconnected Transformations
Active and Passive Transformation
Source Qualifier Transformation
SQL Override-Source Qualifier Transformation

Mapping Source Qualifier as Filter

Source qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored procedure Transformation (Connected & Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I, Type-II, Type-III
Mappings
Workflow Introduction

Informatica - workflow Manager Task

Workflow tools
Connections
Defining tasks
Command Task
Email Task
Session Task
Link Conditions
Event Wait & Event Raise

Hands-on Projects

Complete
Informatica Projects

Practical oriented projects and use-cases will help you experience how the skills learned will solve real-time problems.

At least two projects.

Assisted lab setup to practice skills.

Informatica Modes of Training

Self Paced Learning

30 Hrs of Pre-recorded videos
e-learning content

Life-time LMS Access

100% Practical Approach

Labs and Practicals included

Watch & Learn at your own pace

Online Classroom

30 Hrs of Instructor-Led Live Training

Doubts solving with Trainers

Upcoming Batches

05 Aug - 05 Sep

01:30 AM IST

Weekdend

08 Aug - 08 Sep

01:30 AM IST

Weekday

12 Aug - 12 Sep

02:30 AM IST

Weekend

15 Aug - 15 Sep

02:30 AM IST

Weekday

Years EdTech experience

Freelance expert trainers

Career boosting courses

For Corporates

A customized learning experience for the global corporate workforce. A tailored approach to deliver a trending skillset.

Choose the learning mode that suits you:

Live online training
Self-paced training
On-premises offline training

Course customization to meet project needs.

Best in class trainers for latest and niche courses.

Informatica Training Objectives

What are the Informatica Training course objectives?

Upon the course completion, the students can:

Tekslate Informatica training is designed by experts to make you a Certified Informatica Administrator and Informatica Developer. This Informatica Certification course offers:

Introduction of Informatica basics.
Learn about the data warehousing concepts
How the Dimension tables used and OLAP
Learn PowerCenter components
Informatica Architecture
Learn about source qualifiers
Look Caching and techniques
Worklets tasks
Advanced concepts on Informatica V10.

Why should you learn Informatica?

Informatica is the leading and unique data integration platform with an unbiased and universal view. It is the powerful data transformation tool and is the on-demand application to transfer data from one format to another. Due to its increasing demand, the job opportunities for Informatica professionals are increasing around the globe. On average, the certified Informatica administrators earn $159,518 per annum.

Who should attend Informatica training?

ETL & SQL Developers and Business Intelligence Professionals
Database & Mainframe Professionals, Project Managers

What are the prerequisites for learning Informatica training?

There are no specific prerequisites for learning Informatica. Having basic SQL knowledge is an added advantage.

What projects are included in this Informatica training course?

We will provide two real-time projects under the guidance of a professional trainer, who will explain to you how to acquire in-depth knowledge on all the concepts involved in these projects.

Informatica Training Reviews

Recently, I completed the Informatica Integration training from Tekslate. They provide flexible course timing and responds to issues as soon as possible. I would highly recommend Tekslate for my friends.

Priyadarshini

Look who
has us open

Earn a TekSlate Informatica Certification

Upon completion of the training you’ll be provided a course completion certificate which adds weightage to your resume and increases your chances of getting hired.

Benefits:

Certification Assistance

Certification Sample Questions

Informatica Course FAQ's

Who are the trainers?

Our trainers are well experienced professionals and certified in working with front-end development technologies.

What if I miss a class?

We will record all the Live sessions you go through, and we will send the recording of the class you missed.

How will I execute the practical?

For practical execution, our trainer will provide server access to the student.

Is this live training or pre-recorded videos training?

All our training classes are live. This is to solve all the student queries directly with the trainer.

What is the difference between live online and pre-recorded videos training?

Live online training means, our trainer will be in online with you to solve your issues.
Pre-recorded training means, there will be no trainer available to solve your issues.

Informatica Training