Raj Informatica Training

Informatica PowerCenter Training

Ratings (4.8)
4.6/5

The key feature of this course is to talking about well maintained and structured software development and service companies, one name that stands out is Informatica. You’ll learn and understand about the basic concepts of data warehouse, how to use the Informatica PowerCenter ETL tool in real time project scenarios, understand real time client-server architecture, clear understanding of Informatica PowerCenter architecture and it’s components, understand Informatica ETL developer roles and responsibilities, Interview questions & answers and many other daily course materials.

Have Queries? Ask our Experts

+91 8105296858

Available 24x7 For Your Queries.

Why this training is different than others?

Informatica 10.2 Hands on Explanation and Practice

Practice and Realtime Explanation

  • Day to Day Explanation on Real-time Mappings/workflows
  • Flexible timing, we have two live sessions per day, you can chose any of the timings as per your preference.
  • Interactive 2 hours live sessions with doubt solving sessions after session.
  • For each topic, mapping document (Business Requirement) will be created and Informatica mapping will create on live session based on the mapping document.
  • Interview questions on each topic will be covered on daily basis and provided to the candidate. CLICK HERE to checkout our stack of interview questions.
  • 40+ Realtime Mappings will cover with Explanation and implementation.
  • Oracle and UNIX Topics covered
  • Realtime Project Document Explanation
  • Resume building on Informatica
  • Informatica Cloud IICS-IDMC Basics
  • Interview questions and Tips

Upcoming Batch Schedule

Raj Informatica provides flexible timings to all our students. Here are the Informatica Training Class Schedules in our branch 8. If this schedule doesn’t match please contact us for better options.

21st Batch Starting 8th December 2023

35 Days Course (2 hours) Online Live Session Course

Morning Batch (Live)

9:30AM to 11:30AM, IST

Fees: ₹15,000

Evening Batch (Live)

7:30PM to 9:30PM, IST

Fees: ₹15,000

Informatica Course Syllabus

Course Duration: 70 Hours to 80 Hours (30 to 35 days)
Software Installation: Oracle Database 11g Express Edition, Informatica 10.2 Server and Client Components, SQL Server
Take Away: PDFs on daily basis will Sample Data Model and sample case study
Class Delivery: Live Online Meeting (Interactive LIVE Web Based)

ETL & Informatica

  • DWH Concepts
  • ETL Overview
  • Informatica Overview
  • Components of Informatica

Repository Manager

  • What is Repository?
  • Configuring the Domains
  • Types of Repositories in Real Time
  • Creation of Folders

Informatica Designer

  • Overview and Usage
  • Tools available in Designer
  • Source Analyzer
  • Creating Sources
  • Generating/Executing SQL
  • Types of Sources
  • Warehouse Designer
  • Creating Targets
  • Types of Targets
  • Transformation Developer
  • Transformation Introduction
  • Creating Transformations
  • Functions/Constants/Dates/Variables
  • Mapping Designer
  • Creating Mappings
  • Mapplet Designer
  • Creating Mapplets

Transformations (Basics)

  • Source Qualifier
  • Expression
  • Filter
  • Router
  • Connected / Un connected and Dynamic Lookup
  • Lookup Caches
  • Rank
  • Sorter
  • Aggregator
  • Joiner
  • Sequence Generator
  • Union Transformation
  • Update Strategy

Transformations (Advanced)

  • Transaction Control
  • Normalizer
  • Reusable Transformations
  • Mapplets

Reusable Objects

  • Reusable Transformations
  • Mapplets
  • Worklets

Advanced Topics

  • SCD Type -1 Mapping using Statis Lookup
  • SCD Type -2 Mappingƒ
  • SCD TYPE -1 Using Dymanic Lookup
  • Fact loading
  • Mapping variables and Parameters.
  • Incremental Loading (Real time Explanation)
  • Versioning (Real time Explanation)
  • Different repositories used in real time. (Detailed explanation about DEV / QA /Prod Repositories)
  • Mini Project – End to End explanation and Practice with Several Sources From Source to Stage, Stage to Dimensions And Dimension to Fact Using Incremental Load , SCD Type-2 and Parameterization
  • Copying Objects
  • Importing and Exporting Objects
  • Performance Tuning
  • Bottlenecks
  • Parameter Files (Real time Explanation)
  • Dynamic Target File Generation
 
 

Workflow Manager

  • Manager Overview
  • Source and Target Connection
  • Flat File
  • ODBC
  • Tasks
  • Types of Tasks
  • Command Task
  • Event Wait
  • Event Raise
  • Timer
  • Assignment
  • Decision
  • Email
  • Control

Sessions and Workflows

  • Creating Sessions
  • Reusable Sessions
  • Creating Workflows

Workflow Monitor

  • Monitor Overview
  • Workflow Monitor Views
  • Running and Monitoring Workflows
  • Scheduling
  • Workflow and Session Logs

Course Instructor

Mr. Nataraj V (Raj)

Mr. Nataraj V (Raj)

I'm a Business Intelligence Consultant with 12+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies.

YouTube Reviews

5/5

Linkedin Reviews

5/5

Google Reviews

5/5

Training Course Reviews

Prince Kumar
@princekr_
Read More
First I was sceptical about his training but when I watched his demo video. It was different from other teaching videos, so I decided to join this informatica course. Raj's teaching method is different from other mentors. He take a mapping document and help us to understand the business logic that resembles real time office projects. His way of teaching will make anyone clear about their doubts. After attending his training and doing hands on in informatica. I have gained confidence to work in ETL projects. Thanks Raj for providing this training that helped me to clear my doubts and getting offer letters.
Meghana R
Meghana R
@meghana-r
Read More
I just want to share my experience about Natraj sir training, it is one of the best training I had ever on informatica. I learned lots of real time concepts from Raj sir training and also they are very useful in my job. The training is based on Realtime scenarios so that you will get familiar with the concepts of informatica and Oracle and Unix. Thank you Raj sir for giving us such a nice training and so much of confidence...
Akash Dhus
Akash Dhus
Read More
It's a fantastic course for a beginner also. I could feel the effort that was put into to make sure people understood. Thank you Raj, when I become one the greatest, I will remember this beginning. A wonderful experience . The lecturers are great with a very nice way on interacting and lots of useful material. Thank you for all your cooperation. Hope to see more of you in future. Thank you once again.
Previous
Next

Your Details As Per Our Records

If your details are incorrect Click Here to update it before batch started.

Your User ID:

Your Username:

Your Full Name:

Your Registered Email:

Your Phone Number:

- Not Updated -

- Not Updated -

- Not Updated -

- Not Updated -

- Not Updated -

Log in/Sign up with Google account for password less login.

Or

Login with your email & password

New user? Fill this form to sign up

INFORMATICA PowerCenter TRAINING

Get Your Dream Software/IT Job In Just 45 Days!

Batch 21

Starting 8th Dec'23

Interested To Join? fill this form👇🏻 we will contact you.

Contact Form

As you already attended our previous batch. We'll redirect you to our WhatsApp for any query.