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

42 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

Suresh Bantu

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

attended Informatica ETL


Meera

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

attended Informatica ETL


Venkatesh raavi

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

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:

Suresh Bantu

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

attended Informatica ETL


Meera

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

attended Informatica ETL


Venkatesh raavi

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

attended Informatica ETL


Phani Kumar

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

attended Informatica ETL


Acute Basnet

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

attended Informatica ETL


Pooja Mingada

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

attended Informatica ETL


Pavani M

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

attended Informatica ETL


Kundana

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

attended Informatica ETL


Mohanteja

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

attended Informatica ETL


Mahitha

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

attended Informatica ETL


Navaneeswar

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

attended Informatica ETL


Kavyareddy

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

attended Informatica ETL


Aditya Koyyalamudi

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

attended Informatica ETL


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