Nagachandra photo

Nagachandra

Experienced Informatica Trainer.

Banashankari 3rd Stage, Bangalore, India- 560085.

UrbanPro students 5 Students (5 from UrbanPro)

Phone Verified Email Verified
Are you Looking to Learn?

Details verified of Nagachandra

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Oracle Training

Oracle Products taught

Oracle PL/SQL, Oracle Database

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Oracle Training

4

Informatica Training

Modules

Developer

Teaches

Informatica powercenter (ETL), Informatica Realtime

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Informatica Training

7

ETL Training

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in ETL Training

7

Teaching Experience in detail in ETL Training

DATA WAREHOUSING & INFORMATICA COURSE DETAILS 40 + hrs Teaching 20 + hrs Lab 15-20 hrs Real-time Project Data Warehousing Concepts • Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing) • Slowly Changing Dimensions (SCD1, SCD2, SCD3) • Metadata • Dimensional Table • Types Of Dim Tables • Fact Table • Types of Fact Tables • OLTP (OnLine Transaction Processing) • OLAP (Online Analysis And Processing) • OLTP Vs OLAP • Advantages of OLAP • Different Methodologies of DWH PowerCenter Components and User Interface • Informatica PowerCenter Architecture • Informatica PowerCenter Client Tools • Start Using of the Designer, Workflow Manager and Workflow Monitor Source Qualifier • Source Qualifier Transformation • SQL override in source qualifier transformation • Source qualifier transformation joins concept • Source qualifier transformation on Relational Databases • Source qualifier transformation on File systems • Source qualifier transformation filter concepts • Difference Between SQL Override, Other Options • Source Qualifier Transformation Performance Tunning • Pre SQL and Post in Source Qualifier Transformation Expression, Filter, File Lists and Workflow Scheduler • Expression Editor • Filter Transformation • File Lists • Workflow Scheduler • Lab – Load the Customer Staging Table and Real time issues Joins, Features and Techniques • Joiner Transformation • Shortcuts • Lab A – Load Sales Transaction Staging Table • Lab B – Features and Techniques I and Real time issues Lookups and Reusable Transformations • Lookup Transformation • Reusable Transformations • Lab A – Load Employee Staging Table • Lab B – Load Date Staging Table and Real time issues Debugger • Debugging Mappings • Lab – Using the Debugger Sequence Generator • Sequence Generator Transformation • Lab – Load Date Dimension Table and Real time issues Lookup Caching, More Features and Techniques • Lookup Caching • Lab A – Load Promotions Dimension Table • Lab B – Features and Techniques II • Review and more Lab Activities and Real time issues Router, update Strategy and Overrides • Router Transformation • Update Strategy Transformation • Expression Default Values • Source Qualifier Override • Target Override • Session Task Mapping Overrides • Lab – Load Employee Dimension Table and Real time issues Dynamic Lookup and Error Logging • Dynamic Lookup • Error Logging • Lab – Load Customer Dimension Table Unconnected Lookup, Parameters and Variables • Unconnected Lookup Transformation • System Variables • Mapping Parameters and Variables • Lab – Load Sales Fact Table Sorter, Aggregator and Self-Join • Sorter Transformation • Aggregator Transformation • Active and Passive Transformations • Data Concatenation • Self-Join • Lab – Reload the Employee Staging Table and Real time issues SCD type1 – Hands-On LAB SCD type2 – Hands-On LAB SCD type3 – Hands-On LAB Mapplets • Lab – Load Product Daily Aggregate Table • Review and more Lab Activities and Real time issues Workflow Variables and Tasks • Link Conditions • Workflow Variables • Assignment Task • Decision Task • Email Task • Lab – Load Product Weekly Aggregate Table More Tasks and Re-usability • Event Raise Task • Event Wait Task • Command Task • Reusable Tasks • Reusable Session Task • Reusable Session Configuration Worklets and More Tasks • Worklets • Timer Task • Control Task

ETL Testing Training

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in ETL Testing Training

7

Teaching Experience in detail in ETL Testing Training

DATA WAREHOUSING & INFORMATICA COURSE DETAILS 40 + hrs Teaching 20 + hrs Lab 15-20 hrs Real-time Project Data Warehousing Concepts • Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing) • Slowly Changing Dimensions (SCD1, SCD2, SCD3) • Metadata • Dimensional Table • Types Of Dim Tables • Fact Table • Types of Fact Tables • OLTP (OnLine Transaction Processing) • OLAP (Online Analysis And Processing) • OLTP Vs OLAP • Advantages of OLAP • Different Methodologies of DWH PowerCenter Components and User Interface • Informatica PowerCenter Architecture • Informatica PowerCenter Client Tools

PL/SQL Classes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in PL/SQL Classes

7

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

4.6 from 5 reviews

4.6/55
A

- by Avanthika

attended ETL Testing

posted on 03 Nov, 2016

"I always thought ETL testing was something really difficult to learn and understand. But Nagachandra made it so simple, the way he explained pictorially with enormous examples, made me understand even complex topics easily. I appreciate your effort to put across your syllabus in such understandable way. "

K

- by Krishna

attended Informatica

posted on 02 Nov, 2016

"Called as NC, I consider not only a pro in informatica but also the best in terms of after coaching guidance. Not only did he make the learning experience so easy and seamless, but also took an extra mile to guide us in preparing our resume, naukri portal tricks, and placement guidance. Will look forward for more such outstanding experiences with you sir. "

K

- by Kapil

attended Informatica

posted on 20 Oct, 2016

"Thanks to Nagachandra sir for providing an excellent training in a well structured manner in a very short span. "

P

- by Psy

attended Informatica

posted on 19 Oct, 2016

"Nagachandra turns out to be a good coach and mentor. He is well versed with the concepts of ETL and Informatica. His zeal to explore the tech world and continuous learning is what makes him a dynamic trainer. "

K

- by Kapil

attended Informatica

posted on 18 Oct, 2016

"Nc sir took the class in very interactive manner. He is the best support for me everyday he assign some task,that task helped me a lot to understand the concept "

Have you attended the class of Nagachandra? Write a Review

"How do I learn informatica from scratch???" in   IT Courses/Informatica

You need to be good at sql. Then go ahead and get some basic knowledge about informatica by googling. By at the end of the day, you need a tutoryo give it a headstart

0
|
0

"My name is Ajith Kumar, Am B.tech(2014) passed out and presently working as a US IT Recruiter and thought to change my career into software (development / admin/ testing ) am seeking for some suggestion which technology I need to learn ? Any job after training ? Or where I can get job within 3 months after finishing my training programme- your advises are highly appreciated." in   IT Courses/Informatica, IT Courses/Oracle Training

I would suggest you get into testing to get into Software Testing. This is the easiest way to get into software. You can then later move on to become developer depending upon your performance. In testing get into, Manual or Automation testing. I do teach ETL testing . Also if you are very much leaned towards getting into Software industry only as a developer, then I would suggest start with Informatica .Reasons: Doesn't need any scripting or coding. Minimum basics of SQL is needed. No coding No syntax All the development is done via UI so its as easy as just clicking. This is highly paid and high in demand tool which will never lose its importance over the years. Hope you will be able to decide after this.

3
|
0

Nagachandra describes himself as Experienced Informatica Trainer.. He conducts classes in ETL, ETL Testing and Informatica. Nagachandra is located in Banashankari 3rd Stage, Bangalore. Nagachandra takes at students Home, Regular Classes- at his Home and Online Classes- via online medium. He has 7 years of teaching experience . Nagachandra has completed Bachelor of Engineering (B.E.) from BMS College of Engineering, Basavanagudi, Bangalore in 2009. He is well versed in English, Kannada, Hindi, Telugu and Marathi. Nagachandra has got 5 reviews till now with 100% positive feedback.

Share this Profile

Similar Profiles

Manjunath Kc photo

Manjunath Kc

Manjunath Kc photo Rajajinagar, Bangalore

I have 6 years of experience in the field of ETL Testing, Data Warehouse Testing, Database Testing, Informatica and Manual...


SarLakG Technologies photo

SarLakG Technologies

SarLakG Technologies photo Vijayanagar, Bangalore

- Awarded as Best Training Institute in Bangalore in 2014. - Industry level training for freshers and experienced. -...


Abhishek Soni photo

Abhishek Soni

Abhishek Soni photo Airoli Railway Station, Mumbai

5+ Years of extensive experience in Business Intelligence platforms like ETL, Informatica Power Center, IDQ, MDM, DAC, AutoSys,...


Featured
Chintal Reddy photo

Chintal Reddy

Chintal Reddy photo Yemalur, Bangalore

7+years of experience in Information Technology with a strong background in Data Warehousing and ETL process using Informatica...


Arrigo Etl photo

Arrigo Etl

Arrigo Etl photo BTM Layout, Bangalore

Specialised in Informatica Development, ETL testing Course Content for ETL Testing : DWH Concepts, Oracle, Unix, Manual...


Prasad B photo

Prasad B

Prasad B photo J P Nagar, Bangalore

I am Prasad working in OBIEE, and OBI Apps, Informatica, Datawarehouse and BI technology. I have total 9+ years of experience...


ANIL JOSHI photo

ANIL JOSHI

ANIL JOSHI photo BTM Layout 2nd Stage, Bangalore

I have 10+ years of experience as a yoga teacher. I am certified yoga trainer. My specialty is to cure various diseases....


Ritesh Kumar photo

Ritesh Kumar

Ritesh Kumar photo Wagholi, Pune


Vinu D. photo

Vinu D.

Vinu D. photo Hebbal, Bangalore


Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more