Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Informatica ETL

57 Reviews

Course type: Online Instructor led Course

Platform: Gotomeeting

Course ID: 28880

Course type: Online Instructor led Course

Platform: Gotomeeting

Students Interested 2 (Seats Left 0)

57 Reviews

Date and Time

Not decided yet.

Vinay Reddy picture
Vinay Reddy

Informatica ETL Online Trainer

6 Years of Experience

About Vinay Reddy

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.
P

Purnima

Attended Informatica ETL

Vinay is well experienced and has great teaching skills. The whole training was well planned and organized. He makes sure that all the topics are Understood. His material was too good. Thank You so much Vinay.

S

Syam Prasad Kalam

Attended Informatica ETL

A big thanks to Vinay, for all the knowledge sharing and Support. Vinay has a very good systematic way of delivering Training. He is explained concepts in detail and straight to the point. He is very punctual and committed. The knowledge he provided through training sessions and material provided in the time helped me to learn informatica easily. He is providing good guidance even after the training completion. Looking forward to take training in some other technologies from vinay.

S

Samad

Attended Informatica ETL

Very easy and helpful. I was trained in Powercenter. Looking forward to learn other modules from Vinay.

S

Sudheer

Attended Informatica ETL

Vinay is excellent in providing the Informatica training. His training is very clear, explained concepts in a simple manner and very understandable. Every material is provided in time and his training is so systematic from basics to advanced ETL. He has provided examples for practice. He is very punctual and so committed towards his duty. This is my opportunity to say sincere thanks to Vinay.

K

Kiran Nadukula

Attended Informatica ETL

One of my friends recommended me to take on Informatica Training from UrbanPro. I would say this is one of the best online training available in the market. Vinay has in depth knowledge about the tool and this enables him to teach with real time examples which in turn make the user comprehend concepts in full detail in the first go itself. If you are planing to gain expertise in Informatica, I would strongly recommend you to roster for UrbanPro. I have had a wonderful experience learning Informatica from Vinay and thank him for making this learning effortless.

R

Raghu

Attended Informatica ETL

Excellent course delivery by Vinay. He is so clear about what to be delivered and never wasted a single minute. He explained all the concepts very well in a shorter duration of time. Documentation provided by him is fantastic. I would suggest him for my friends.

S

Sindhu

Attended Informatica ETL

Course is really helpful to know basics on Informatica. Training is simple and clear and can be understood very easily. Trainer has good knowledge on Informatica. He will provide all the needed documents and recording of all the sessions.

S

Syed jamaluddin qadri

Attended Informatica ETL

I would like to thank Mr.Vinay for his training on informatica power center. He is a very good trainer supportive in explaining concept in detail.

A

Abhishek

Attended Informatica ETL

Very good trainer. Crystal clear explanation and answers your queries in efficient way. All the concepts are explained very well in the theory sessions and are followed by good practical sessions.

P

Prashanth

Attended Informatica ETL

First I’d like to thank UrbanPro for helping me in finding Vinay. The knowledge he has with this technology is brilliant. I’d say he is a data dictionary for this tool containing all the related docs, test exercises, and interview based questions. He is also good at explaining things, time management and was able to complete the course within the stipulated time. Overall it was nice learning Informatica from him and thank you so much.

P

Pravallika Chalasani

Attended Informatica ETL

I really enjoyed the training. The explanation was extraordinary with all the examples for each and every concept. Especially the documents provided were easy to understand. "Vinay you build great confidence in people. Thanks a lot for your support."

S

Swetha

Attended Informatica ETL

"Extremely satisfied with the overall training from Vinay, as my requirement for training deadline was very short. we worked on the training timings and able to finish with all complete installation of the software, module ppt's along with clear explanation screenshots which made my learning faster. Recorded sessions made my work much easier, so that I have a chance of learning again, when needed. Thanks, Vinay."

M

Mukesh Kumar

Attended Informatica ETL

"I just completed my ETL training with Vinay and would definitely recommend him as he explains the concepts very clear and understandable form. The material he provides is also very good and precise with all the data flow diagrams. Very very flexible with the timings and very punctual. Makes sure all the concepts are understood, clears all the doubts. Once the sessions are done, he helps with preparing the resume, conducts mock interviews . Highly recommend him for ETL training.

P

Prem

Attended Informatica ETL

Informatica ETL training provided by Mr .Vinay Reddy is the best training ever.The way he delivers is good and easy understandable. Anyone who is from non-technical background also understands the subject well. He has very good knowledge on informatica, explained each and every topic very clearly, provided examples for practice. The materials shared are very helpful. His dedication and passion towards his work is awesome and he is very punctual. I would strongly recommend him to all who is interested in learning Informatica.

A

Adhika Reddy

Attended Informatica ETL

"His training is very clear, explained concepts in a simple manner and very understandable. Data flow diagrams helps to understand transformations very clearly. He changes way of training according to student standards. Every material is provided in time and his training is so systematic and in fair order starting from basics to advanced ETL. Provided examples for practice. He is so punctual and so committed towards his duty support even after training is appreciated. Highly recommended, thanks for everything Mr.Vinay ".

S

Suresh Bantu

Attended Informatica ETL

"First of all, I am very thankful to Vinay for this training. He has very good knowledge on informatica,explained each and every topic very clearly, provided examples for practice.He makes sure that you understand the concept. His materials are really easy to understand , he is very flexible and able to reschedule the classes. I would strongly recommend him to all who is interested in informatica."

M

Meera

Attended Informatica ETL

I just completed my ETL training with Vinay and would definitely recommend him as he explains the concepts very clear and understandable form. The material he provides is also very good and precise with all the data flow diagrams. Very very flexible with the timings and very punctual. Makes sure all the concepts are understood, clears all the doubts. Once the sessions are done, he helps with preparing the resume , conducts mock interviews . Highly recommend him for ETL training.

V

Venkatesh raavi

Attended Informatica ETL

It was nice taking course with him, he was so patient in telling doubts. I would recommend to all.

P

Phani Kumar

Attended Informatica ETL

It was good training with realtime examples and data flow diagrams. In his trainning learnt lot of concepts and functions in DWH too. He is having excellent knowledge on tool and presenting the same to the trainee is also superb. I Prefer vinay as first and best option for my colleagues or friends who wants to get in Informatica.

A

Acute Basnet

Attended Informatica ETL

I am working professional in IT and I took Informatica ETL class with him during the month of Apr -May 2017. His teaching style was very nice, he has very good concept of ETL and Informatical tool and I learned all the concepts which I was looking from this training. I would recommend interested people to take his training.

P

Pooja Mingada

Attended Informatica ETL

I have completed my Informatica ETL training from Vinay Reddy. His training is very clear,explained concepts in a simple manner and very understandable. Data flow diagrams helps to understand transformations very clearly. Every material is provided in time and his training is so systematic and in fair order starting from basics to advanced ETL. Provided examples for practice. He is so punctual and so committed towards his duty.

P

Pavani M

Attended Informatica ETL

I took informatica etl training from Vinay sir, his teaching is very good and explains each topic in an understandable way. I suggest him as the best informatica etl trainer.

K

Kundana

Attended Informatica ETL

He covered all the topics in informatica and trained very well. All the transformations and advanced topics and many Q&A s are being given. Performance tuning was also taught which will not be told any of them.

M

Mohanteja

Attended Informatica ETL

I have reached Vinay for training on Informatica. Its not just getting trained, its experiencing the experience from the expert. He is very good to make the things understandable and dedication and commitment in giving the best. Excellent Trainer. Thanks Vinay.

M

Mahitha

Attended Informatica ETL

It was great experience training with vinay. I have taken online informatica etl training.He explained each and every concept very clearly and also shared the documents and recorded classes after the class for reference. I liked the systematic approach and very detail representation with examples and data flow diagrams on each transformation during the training, that helped me understand. I would definitely like to suggest vinay to my friends who are willing to join the informatica course. And vinay was also very flexible to fit the classes according to my schedule. He is an excellent trainer and has vast knowledge in informatica.

N

Navaneeswar

Attended Informatica ETL

I got informatica training from him, he is very good trainer. He explained each transformation with good example and he sent each and every topic in PDF files. I would strongly recommend him to all who is interested in informatica.

K

Kavyareddy

Attended Informatica ETL

excellent trainer. explained from very basics to the advanced part with very good examples. explained each mapping and transformation practically. explained each and every doute with immediate response to the mails. I gained a good practical knowledge in informatica in his sessions. I would strongly recommended vinay reddy for informatica ETL training.

A

Aditya Koyyalamudi

Attended Informatica ETL

All the topics were clearly explained. For the beginners, this course is enough to learn Informatica. Mr.Vinay is flexible with the timings too. I would really recommend for anyone who is looking for Informatica training

A

Atul Bawankar

Attended Informatica ETL

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

A

Ashok

Attended Informatica ETL

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.

S

Srinivas

Attended Informatica ETL

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

K

Keerthiknath reddy

Attended Informatica ETL

"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. "

D

Dinesh

Attended Informatica ETL

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.

S

Somu

Attended Informatica ETL

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.

S

Sruesh Sirasani

Attended Informatica ETL

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.

N

Nithin

Attended Informatica ETL

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.

M

Madhumita Mahanta

Attended Informatica ETL

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.

A

Arun

Attended Informatica ETL

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.

S

Shoaib Syed.

Attended Informatica ETL

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.

P

Priyanka

Attended Informatica ETL

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

A

Aqueel Syed

Attended Informatica ETL

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

H

Haritha Vemuru

Attended Informatica ETL

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.

R

Raja

Attended Informatica ETL

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.

R

Reddy Akhil

Attended Informatica ETL

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.

V

Vijay Kanth

Attended Informatica ETL

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.

E

Et Asinus Tuus

Attended Informatica ETL

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.

R

Ruchir

Attended Informatica ETL

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.

Raghu Ram

Attended Informatica ETL

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.

B

Bharath Kumar

Attended Informatica ETL

"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".

A

Amir Singh

Attended Informatica ETL

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.

C

Chaitanya

Attended Informatica ETL

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.

K

Karthik

Attended Informatica ETL

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

K

Krish

Attended Informatica ETL

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.

T

Teja

Attended Informatica ETL

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

S

Srivalli D

Attended Informatica ETL

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.

H

Harini

Attended Informatica ETL

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.

S

Swetha

Attended Informatica ETL

"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."

View more Reviews

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 (57) See all Reviews

P

Purnima

Attended Informatica ETL

Vinay is well experienced and has great teaching skills. The whole training was well planned and organized....

S

Syam Prasad Kalam

Attended Informatica ETL

A big thanks to Vinay, for all the knowledge sharing and Support. Vinay has a very good systematic way...

S

Samad

Attended Informatica ETL

Very easy and helpful. I was trained in Powercenter. Looking forward to learn other modules from Vinay.

S

Sudheer

Attended Informatica ETL

Vinay is excellent in providing the Informatica training. His training is very clear, explained concepts...

K

Kiran Nadukula

Attended Informatica ETL

One of my friends recommended me to take on Informatica Training from UrbanPro. I would say this is one...

R

Raghu

Attended Informatica ETL

Excellent course delivery by Vinay. He is so clear about what to be delivered and never wasted a single...

Discussions

Students Interested 2 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Informatica ETL coaching Post your requirement now
Enquire

Enquire

Submit your enquiry for Informatica ETL

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

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