Enroll Now!!! and get 10% special Discount on all courses. Limited Time only!!!

Informatica Training & Certification ( L035 )

4.5 + (25,859) Students Ratings

Informatica certification course from IQ Training is designed by industry experts as per the Industry requirement and demands. This course will help you gain in-depth knowledge on Master Data Integration concepts such as ETL, advanced Informatica transformations, Data Mining using Informatica PowerCenter, etc. You will get an opportunity to work on real-time use cases which helps you to easily clear the Informatica certification exam.

Course Price :

₹20,695
₹22,994
10%
off
Available

Live Instructor

Self Paced

Think Bigger Advantage

Live Online Classes

All our Classes are Live Instrucotor led online sessions. You can attend at the comfort of your place and Login to our Classes.

LMS (Learning Management System)

LMS will help you to organize your all training material, session videos and review at later date. You can access LMS anytime and review your completed classes. If you miss any class, then you can review the missed class in LMS.

Flexible Schedule

For some reasons, you can not attend the Classes, we can enroll you in the next possible classes. we assure flexibility in class schdules.

Lifetime Access to Learning Platform

You will get Lifetime free access to LMS(Learning Mangement System) You can access all Videos, class room assignments, quizzes, Projects for Life time. You will also get free video sessions for Life time.

Highest Completion Rate

We have the highest course completion rate in the Industry. If you miss a class, you can opt for the missed class in different batch. We assure you the best training possible for you to succeed.

Certificate of Completion

We provide you the Industry recognized Certification of Course completion This certificate will sometimes helps you to get reimbursement of training expenses by your company.

Training Scheule
Batch Start Date Days of Training Weekday/ Weekend Timings
27-Mar-2020 Available SAT & SUN (6 WEEKS) Weekend Batch 09:30 PM - 12:30 AM (EST)
 
 
 
 
 

Course Curriculum

Learning Objectives: In this module, we will explore different Informatica products that are available. This module also covers an overview of Informatica PowerCenter Product, Architecture of Informatica, its terminology, Tools, Mappings, Transformations, Sessions, Workflows and also understand the installation process of Informatica. 

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
  • Using Oracle as Database
  • Creation of the services and connecting the client to the server

Learning Objectives: This module covers different concepts of Data Integration. You will also discuss the concepts of Data Profiling, Data Quality Management, ETL and architecture of ETL, and fundamentals of 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
  • Understand shutdown and start-up services from the Administration Console
  • Creation and execution of a simple pass-through mapping.

Learning Objectives: In this Informatica PowerCenter Transformation module, you will understand 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 the mapping
  • Transformations & their usage

 

Hands-On/Demo:

  • Inside mapping, Use multiple transformations to resolve different use cases
  • Look at the properties of the transformations to customize 

Learning Objectives: In this module, you will understand the development units of Informatica PowerCenter. You will also understand how Informatica PowerCenter is used to create different tasks and workflows. 

 

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: This module explains Advanced Transformation techniques which allows you to explore advanced concepts of PowerCenter transformations like Java, XML, etc. You will also understand Various features of Informatica like Error Handling, Transaction Processing & Reusability 

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
  • Use of inbuilt and custom functions for fulfilling the needs of data transformation.
  • Reusable transformations, Sessions, Mapplets, etc.

Learning Objectives: This module helps you to discuss advanced ETL scenarios using Informatica. You will get to know the concepts like Error Handling, PushDown Optimization, Partitioning, Incremental Aggregation, Target Load Order Group, and many other concepts. We will also discuss Data Warehousing related processes. 

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: This module explains the features which are provided by Informatica to debug, troubleshoot and handle errors for a better understanding of the inner workings and responsibilities of an operational role. You will also discuss Various PowerCenter recovery options for tasks and workflows with recommended best practices to the operation 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 debug a mapping
  • Perform workflow, session recovery and related configuration.

Learning Objectives: This module highlights the performance aspects and efficient use of Informatica PowerCenter components.

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 helps you to get an introduction to the Components and the uses of the PowerCenter repository manager. You will also understand how to migrate and manage the repository effectively. 

 

 Topics:

  • Repository Manager tool 
  • PowerCenter Repository Maintenance

 Hands-On/Demo:

  • Get familiar 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:  Here you will get an overview of the PowerCenter administration console, recognize and explain integration and repository service properties. You will also learn the command-line utilities and understand how to 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:

  • Find the details of various different components of Informatica Administration tool
  • How to create user, group, assign privileges to the users and groups
  • How to create Roles 
  • Know how to export service logs
  • Service maintenance from Administration console

Learning Objectives: This module covers the concept of the command line Utilities which is a  part of Informatica PowerCenter. You will also learn how to automate the tasks from the command line.

Topics:

  • Infacmd, infasetup, pmcmd, pmrep
  • Automate tasks via command-line programs

 Hands-On/Demo:

  • Use Infacmd, infasetup, pmcmd, pmrep to automate tasks through command-line Programs

Learning Objectives: This module deals with the architectural aspects of Informatica PowerCenter. 

Topics:

  • Informatica 10 Architecture
  • Application services
  • Buffer memory
  • Connectivity among the tolls
  • Connection Pooling
Like the course? Enroll Now

Structure your learning and get a certificate to prove it.

Course Details

Upon completion of this Informatica Training Course, you will be able to 

  • In-depth Knowledge of Informatica PowerCenter
  • Understand the Architecture and Environment of Informatica PowerCenter.
  • Comprehensive knowledge of tools like Informatica Administrator Suite, Designer, and Workflow and Repository Manager.
  • Understand how to load Dimension Tables, use Advanced Transformation, recognize and repair Connection & Network Errors
  • Understand how to configure Workflows and Sessions
  • Understand how to Create Users, Group and also to design Error Handling strategies
  • Knowledge on command-line tools of Informatica PowerCenter
  • The exposure to many real-time industry-based Business Intelligence Projects and use cases.
  • Rigorous involvement of an SME throughout the Training.

In ETL and Data Integration market, Informatica is considered as the most popular tool. This Informatica Certification Course will help you in enhancing your career growth and It is best suited for:

  1. Data Integration developers
  2. Informatica PowerCenter Administrators 
  3. BI/ETL/DW Professionals
  4. Administrators who can manage either PowerCenter or Data Quality
  5. Individual Contributors in Enterprise Business Intelligence field
  6. Database developers and developer Managers who are new to Informatica.
  7. Informatica Administrators who can maintain Data Quality.

There are no pre-requisites for this course. However, Knowledge of SQL will be beneficial but it’s not mandatory.

Informatica Training & Certification Ceritficate

Informatica Training & Certification Reviews

25,859

Total number of reviews

4.5

Aggregate review score

80%

Course completion rate

Informatica Training & Certification Features

Live Online Classes

All our Classes are Live Instructor led online sessions. You can attend at the comfort of your place and Login to our Classes.

LMS (Learning Management System)

LMS will help you to organize your all training material, session videos and review at later date. You can access LMS anytime and review your completed classes. If you miss any class, then you can review the missed class in LMS.

Flexible Schedule

For some reasons, you can not attend the Classes, we can enroll you in the next possible classes. we assure flexibility in class schedules.

Lifetime Access to Learning Platform

You will get Lifetime free access to LMS(Learning Mangement System) You can access all Videos, class room assignments, quizzes, Projects for Life time. You will also get free video sessions for Life time.

Highest Course Completion Rate

We have the highest course completion rate in the Industry. If you miss a class, you can opt for the missed class in different batch. We assure you the best training possible for you to succeed.

Certificate of completion

We provide you the Industry recognized Certification of Course completion This certificate will sometimes helps you to get reimbursement of training expenses by your company.

Like the course? Enroll Now

Structure your learning and get a certificate to prove it.

Informatica Training & Certification FAQs

You will never miss a class at IQ Online Training! You can choose either of the two options:

  1. View the recorded session of the class available in your LMS or
  2. You can attend the missed session in any other live batch.

After the enrolment, the LMS access will be instantly provided to you able to access for lifetime which includes complete set of previous class recordings/PPTs/PDFs/assignments. You can start learning right away.

Your access to the Support Team is for lifetime. Our team will help you in resolving queries, during and after the course.

Yes, once enrollment has done for course. Access to the course material will be available for lifetime.

You can Call our support numbers listed in site OR Email us at info@iqtrainings.com.

You can view in-depth class sample recordings before the enrollment. Experience the complete learning instead of a demo session with our expertise.

All the instructors are Industry experts with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are well trained for providing an awesome learning experience to the participants.

Recommended Courses

Lorem Ipsum is simply dummy text of the printing and typesetting industry.

DATA WAREHOUSING AND BI CERTIFICATION TRAINING

Duration: 30 Hours

₹ 
20,694
 ₹ 18,625
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend
04-Apr-2020 11:00 AM - 02:00 PM (EST) Yes

TALEND FOR DATA INTEGRATION AND BIG DATA

Duration: 30 Hours

₹ 
20,464
 ₹ 18,418
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend

DATA WAREHOUSING CERTIFICATION TRAINING

Duration:

₹ 
8,624
 ₹ 7,762
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend

MASTERING DATA WAREHOUSING AND BUSINESS INTELLIGENCE

Duration:

₹ 
11,499
 ₹ 10,349
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend

ABINITIO TRAINING

Duration:

₹ 
0
 ₹ 0
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend

COGNOS TRAINING

Duration:

₹ 
0
 ₹ 0
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend

DATASTAGE TRAINING

Duration:

₹ 
0
 ₹ 0
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend

BUSINESS ANALYST TRAINING

Duration:

₹ 
0
 ₹ 0
 (10% OFF)
Reviews

4.5

Course Schedule

Start Date Timings Weekend
Drop us a Query

+91 97846 54326

Available 24x7 for your queries