Informatica Admin Online Training

All Levels
40h

About Course

This Informatica Admin Online Training is an industry-designed course for mastering the Informatica tool and Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter:

  1. Informatica is the best ETL tool in the market.
  2. It can extract data from multiple heterogeneous sources, transforming them as per business requirement and loading to target tables. In addition, Data migration and loading projects are created using Informatica as a tool.
  3. . Here at Nisa Online Training, you will learn how to configure, install, and administer the PowerCenter.
  4. As part of the training, you will also test and monitor data processing using an automated, scalable and auditable approach.

As a result, you will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.

Post Image of Informatica Admin Online Training Course
Informatica Admin Online Training – Learn Online

 

Why should you learn Informatica?

Informatica is the market leader in the ETL segment. It can work on a wide variety of data sets, varying standards and multiple applications and systems. Thus, organisations worldwide rapidly adopt it, providing substantial job opportunities for professionals with the right skills.

 

What will you learn in this Informatica Admin Online Training Course?

  1. Informatica architecture and Informatica PowerCenter
  2. Installation and configuration of Informatica
  3. Managing and monitoring Informatica workflow
  4. PowerCenter handling Jobs and Tasks
  5. Informatica workflow variables and session parameters

 

Why should you choose Nisa For Informatica Admin Online Training?

Nisa Trainings is the best online training platform where we conduct one-on-one interactive live sessions with a 1:1 student-teacher ratio. You can gain hands-on experience by working on near-real-time projects under the guidance of our experienced faculty. We support you even after the completion of the course and are happy to clarify your doubts anytime. Our teaching style at Nisa Trainings is entirely hands-on. You’ll have access to our desktop screen and will be actively conducting hands-on labs on your desktop.

 

Job Assistance

If you are working on Informatica and facing any problem while working on it, then Nisa Trainings is simply a Call/Text/Email away to assist you. We offer Online Job Support for professionals to help them and to solve their problems in real-time.

 

The Process we follow for our Online Job Support Service:
  • We receive your enquiry about Online Job Support.
  • We will arrange a telephone call with our consultant to grasp your complete requirement and the tools you’re using.
  • If our consultant is 100% confident in taking up your requirement and when you are also comfortable with our consultant, then only we will agree to provide service. And then you have to make the payment to get the service from us.
  • We will fix the timing for Online Job Support as mutually agreed by you and our consultant.

 

Course Information

 

Informatica Training

 

Duration: 40 Hours

Timings: Weekdays  (1-2 Hours per day) [OR]  Weekends (2-3 Hours per day)

Training Method: Instructor Led Online One-on-One Live Interactive Sessions.

What Will I Learn?

  • Working with Informatica Admin Console
  • Informatica performance tuning
  • Managing Informatica Repository
  • ETL functionalities and scenarios
  • Informatica SQL and XML transformation
  • Preparing for Informatica certification

Topics for this course

97 Lessons40h

Data warehouse basics

OLTP System
Datawarehouse
Different Defeinitions of datawarehouse
Difference between OPERATIONAL DS AND DWH
Data Extraction
DataTransformation
Types of ETL
Data Merging
Data Loading
Types of Data loading
Data Aggregation
Datawarehouse Approaches
Top down approach and Bottom up approach
DW Life cycle
DW-database design
Types of Dimensions
Types of fact table
Star schema and Snow flake schema
Dimensional modelling
Facts and dimensions
Granuality
Types of Olap

Informatica Power Center 9.1

Repository Administration

Using the designer

Transformation Creation

Using the workflow manager

Workflow Tasks

Performance tuning in ETL

Student Ratings & Reviews

Requirements

  • You don’t need any specific skills to learn Informatica. However, a basic knowledge of SQL can be an added advantage.

Target Audience

  • Business Intelligence, ETL, SQL and Database Professionals, Project Managers and graduates looking to make a career in BI

Explore More From Data Warehousing Courses

Open chat
1
Hello 👋🏻

You are just a text away to get the more information...