loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Informatica ETL

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Vinay

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Informatica ETL

Informatica ETL

Online Instructor led Course

Platform: Gotomeeting

29 Reviews
2 Interested

About the Course


Training is designed in such a way so the trainee gets good command on fundamental and advanced concepts of Informatica PowerCenter which includes real time scenarios,assignments, online tests,best practices ,user friendly complete documentation completely in practical oriented.

Duration:: 25 Hours

Session Timings::
* Weekday Batches: (Mon - Fri)
Any one hour in the below mentioned timings as per the slot availability
Morning Hours: 04:00 AM - 08:00 AM IST
Evening Hours: 06:00 PM - 11:00 PM IST

Topics Covered

Level-1
Data Warehousing Basic Concepts
What is Data Warehouse
What is Data warehousing?
Characteristics of Data warehouse
Principles of Data warehouse.
Benefits of DWH.
What is Data scrubbing, Data Transformation etc
What is online transactional systems (OLTP)
Difference between OLTP and DWH.
Approaches of Data warehousing.
DWH Lifecycle
Data Warehouse Modeling
Staging Area
Dimension table
Fact Table
Schemas
Star schema
Snowflake schema
Slowly changing Dimension Concepts
SCD-1
SCD-2
SCD-3
Data Mart
Top down Approach
Top UP Approach

Level-2
Introduction
Sources
Targets
PowerCenter Repository
PowerCenter Client Components
Power Center Server Components
PowerCenter Designer
Repository Manager
Workflow Manager
Workflow Monitor
PowerCenter Repository Service
PowerCenter Integration Service
Getting Started
Using the PowerCenter Client /Workflow/Monitor/Repository
Informatica architecture component wise
Use of ODBC/Relational Connection
Software Installation and Administrator
Connecting to the Repository
Creating a Folder
Changing Password
Creating Source Definitions
Creating Target Definitions and Target Tables
Creating Target Definitions
Creating a Mapping
Creating Transformations
Creating Sessions and Workflows
Configuring Relational Connection in the Workflow Manager
Creating a Workflow
Running and Monitoring Workflows
Fetching Session Log
Getting Run Properties
Working With Files (Source/Target)
Working with Fixed width files
Working with Delimited files
Working with XML Files

Level-3
Definition of Transformation
Types of Transformation
Active/Passive Transformation
Reusable and Non-Reusable Transformation
Filter Transformation
Router Transformation
Expression Transformation
Rank Transformation
Sorter Transformation
Aggregator Transformation
Sequence Generator Transformation
Joiner Transformation
Union Transformation
Update Strategy Transformation
Lookup Transformation
Stored Procedure Transformation
Normalizer Transformation
Source Qualifier Transformation
Transaction Control Transformation
XML Source Qualifier Transformation
JAVA Transformation
Unconnected Stored Procedure Transformation
Unconnected Lookup Transformation

Level-4
Working with Parameters/Variables
Scheduling
Debugging
Session Properties
Error Handling
Analyzing Workflow and Session Logs
Performance Tuning
Unit Testing
Export/Import (Backup/Restore)
User Defined Function
Worklet
Reusable and Non Reusable Sessions
Implementing SCD1, SCD2, SCD3
Task
Reusable and Non Reusable Task
Session Task
Command Task
Email Task
Decision Task
Assignment Task
Timer Task
Event Wait Task
Event Raise Task
Control Task
Link Task
Partitioning
Push Down Optimization (PDO)
Target Load Plan
Constraint Based Load Ordering
ETL Life Cycle

Who should attend

Any one

Pre-requisites

- I will also cover all the Pre-requisites, i.e, SQL & Unix
- Good internet connectivity

What you need to bring

Regular practice is expected

Key Takeaways

- Conceptes of DWH
- Strong ETL knowledge
- Able to create complex mappings
- Good knowledge of Transformations
- Advanced ETL concepts
Reviews

Atul Bawankar

"The class in a very professional manner. His examples were very relevant and I feel that I gained a lot from the training. "

attended Informatica ETL


Ashok

"Excellent Trainer and extremely satisfied the way Mr.Vinay trained and it was very detailed and professional which he covered every topic of Informatica with good examples. I especially liked the systematic approach and very detail representation with examples and data flow diagrams on each transformation during the training, which was in a proper flow that helped me understand the Informatica. I would definitely like to suggest to my friends who are willing to join the informatica course. "

attended Informatica ETL


Srinivas

"Overall experience with the trainer( Mr.Vinay) was great. Explained every topic in detail with real time scenario, highly recommended "

attended Informatica ETL


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Atul Bawankar

"The class in a very professional manner. His examples were very relevant and I feel that I gained a lot from the training. "

attended Informatica ETL


Ashok

"Excellent Trainer and extremely satisfied the way Mr.Vinay trained and it was very detailed and professional which he covered every topic of Informatica with good examples. I especially liked the systematic approach and very detail representation with examples and data flow diagrams on each transformation during the training, which was in a proper flow that helped me understand the Informatica. I would definitely like to suggest to my friends who are willing to join the informatica course. "

attended Informatica ETL


Srinivas

"Overall experience with the trainer( Mr.Vinay) was great. Explained every topic in detail with real time scenario, highly recommended "

attended Informatica ETL


Keerthiknath reddy

""Vinay is very good at explaining and had detailed subject knowledge. He was always able to fit lessons around my schedule and he makes sure that I was able to do all my lab exercises. " "

attended Informatica ETL


Dinesh

"he is very punctual and commitment towards the training and very patience while answering the questions. Very helpful and informative. Vinay has explained the subject in the simplest way possible. Relevant content presentation. Doubts clarification is good. Provided examples for practice. "

attended Informatica ETL


Somu

"The course was completed on time with covering all topics. Vinay has good knowledge in Informatica and was able to pass that knowledge to us with real-time examples and explanation. It's really been a great learning experience. "

attended Informatica ETL


Sruesh Sirasani

"I just completed Informatica ETL training from Vinay. Mr. Vinay was awesome trainer and has vast knowledge in Informatica. Along with Informatica he also gives the training on basic Oracle SQL which is required. And also he is very punctual and commitment towards the training and very patience while answering the questions. It's very valuable training if anyone interested. Special thanks to Vinay for a wonderful training and support after the training sessions. "

attended Informatica ETL


Nithin

"I started the course with some knowledge on informatica, after I started course work with him I gained lot of knowledge and one best part about his course is he had a great material that will take you to next level in learning. "

attended Informatica ETL


Madhumita Mahanta

"He is very good at explaining and had detailed subject knowledge. He was always able to fit lessons around my schedule and he makes sure that I was able to do all my lab exercises. "

attended Informatica ETL


Arun

"The Training provided by Vinay is evident, i could understand the concepts and the scenarios very clearly, and the kind of support provided by Vinay is note worthy. The materials and recording of the online sessions provided to the user is really very helpful for beginners also. ETL training by Vinay is definitely going to help us. "

attended Informatica ETL


Shoaib Syed.

"Mr. Vinay Reddy is an exceptional trainer. He has immense knowledge and great command of the subject. He make the concepts very easy and simple by using easy to understand examples. He is readily accessible, very flexible in scheduling and upon all very patient, accommodating and understanding, in explaining and answering queries, as this is a new field for me. I would very strongly recommend him. "

attended Informatica ETL


Priyanka

"The Coaching provided by Mr.Vinay was excellent and he shared his good knowledge and command in iformatica ETL. I suggest Mr.Vinay as Informatica Trainer for your better results "

attended Informatica ETL


Aqueel Syed

"Mr.Vinay is by far the best informatica trainer i have come across.The Coaching provided by Mr.Vinay was excellent and he shared his good knowledge and command in Informatica ETL. His way of providing training exercises helped me in gaining expertization in informatica in a short period of time. His patience in clearing my doubts is appreciable. I suggest Mr.Vinay as Informatica ETL Trainer for our better results "

attended Informatica ETL


Haritha Vemuru

"Great Instructor who makes the concepts very accessible through good examples! Training from Vinay really helped as this was new to me and he taught with great patience and answered all queries.His materials are really easy to understand , he is very flexible and able to reschedule the classes. I would strongly recommend him. "

attended Informatica ETL


Raja

"Great! Very helpful and informative. Vinay has explained the subject in the simplest way possible. Relevant content presentation. Doubts clarification is good. Provided examples for practice. "

attended Informatica ETL


Reddy Akhil

"Vinay has broad knowledge on ETL concepts and thorough understanding of Informatica features which is vital for newbie as well as intermediate developer to work on. He has pure professionalism and passion towards training students which is core of success mantra for any student. I highly recommend His course for any student who is looking for best of best in Informatica. "

attended Informatica ETL


Vijay Kanth

"If you want to have a real time training on Informatica then best choice is Mr. Vinay. He can explain you the topic as many times till you understand. You will not get this such kind of training's any where else. I am feeling much confident after attending this training. "

attended Informatica ETL


Lalith V

"Good presentation and good grasp of content from the Instructor. Given the time constraints, he did a good job. Would definitely recommend to friends /family. "

attended Informatica ETL


Ruchir

"Training went pretty good, vinay was good at practical teaching than theoritical. Everybody wants the same pratically rather than theory. So I will suggest vinay for this part. "

attended Informatica ETL


Raghu Ram

"The Coaching provided by Mr.Vinay was excellent and he shared his good knowledge and command in Iformatica ETL. His way of providing training exercises helped me in gaining expertization in informatica in a short period of time. His patience in clearing my doubts is appreciable. I suggest Mr.Vinay as Informatica ETL Trainer for our better results. "

attended Informatica ETL


Bharath Kumar

""Vinay sir has good subject knowledge and he also make sure that the students are good at basics . which is a unique thing i found". "

attended Informatica ETL


Amir Singh

"Had a good experience . Concepts explained very well. He has a good knowledge of Informatica. Would recommend everyone who are willing to learn Informatica from scratch. "

attended Informatica ETL


Chaitanya

"Vinay sir is a wonderful trainer. He explains everything from the basics and is just a call away to explain all the queries we come across . He creates that interest in you about the course by his excellent presentation skills He will also share real time scenarios with examples which will be helpful in the long run. Thank you sir. "

attended Informatica ETL


Karthik

"It was great interacting with Vinay in learning Informatica. All the topics have been taught very well with perfect examples. "

attended Informatica ETL


Krish

"I would strongly recommend Vinay as trainer I like the way he teaches. He explained each and every topic in very easy and understandable way.His materials were really good enough to practice on our own at any point of time.In each session, he use to spend some time for all of our doubts which was really appreciable.And the support he extends even after completion of the course is awesome.He was very punctual in taking the sessions. "

attended Informatica ETL


Teja

"He is well experienced and know how to teach the people who are from completely different platform also nice experience because of him got an very good idea about tool thank you "

attended Informatica ETL


Srivalli D

"This is the best training I have been through. He is very good at presenting the course in a most understandable way. He stick to the timings and his dedication are impressive. "

attended Informatica ETL


Harini

"Vinay teaches very well, easily understandable. He covers even very basic concepts.He clears all the doubts.He is very interactive and good presenter.His training was very useful in handling real time projects.He is very expertise in ETL concepts. "

attended Informatica ETL


Swetha

""Incredible teaching, sessions was very interactive. Vinay Reddy has abundant knowledge on Informatica. Classes are very interactive, really helpful in clarifying the doubts and uploading the respective class videos and sharing documents. I strongly recommend him. He is an expert in teaching concepts on Informatica from scratch to latest technologies. I am grateful to attend his classes." "

attended Informatica ETL


Date and Time

Not decided yet.

About the Trainer

Vinay Reddy picture

Vinay Reddy

Informatica ETL Online Trainer


Working as Sr.Software Engineer, have good experience working with Informatica, ETL Testing and other ETL Tools. Total IT experience is 10 years. Started teaching past 6 years and continuing with full time/part time till now in various verticals. Conducted training for around 300+students offline,online and corporate training. Strong at ETL tools having in-depth knowledge and hands-on experience of real time projects. Certified as a Developer Specialist in Data Integration by Informatica Corp.
Seats Left-

Students Interested 2

Course Id: 28880