4 yrs of Exp 
6 students 
Banashankari 3rd Stage, Bangalore 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.
Online Classes 
Student's home 
Tutor's home 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.
Share this profile English
Kannada
Hindi
Telugu
Marathi
BMS College of Engineering, Basavanagudi, Bangalore 2009
Bachelor of Engineering (B.E.)
Banashankari 3rd Stage, Bangalore, India - 560085
Education Verified
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Oracle Training
4
Oracle Products taught
Oracle PL/SQL, Oracle Database
1 Student Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Informatica Training
7
Modules
Developer
Teaches
Informatica powercenter (ETL), Informatica Realtime
Teaching Experience in detail in Informatica Training
I am currently working as development manager in a MNC. Having 9.3+ years of experience in IT industry in Analysis, design, development, documentation, Maintenance and support of Application Software. Indomitable experience in teaching 200+ students. Paramount experience in teaching Informatica (8.x/9.x), Datawarehousing and Oracle SQL. Worked closely with Lead Architects, Product Strategists, Product Managers, Scrum Masters and other Development Leads to enhance the overall structure/outcome of the products owned by me and to scale it to its zenith. Strong Data Warehousing & ETL experience of using Informatica 9.6.1/9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager. Hands-on experience across all stages of Software Development Life Cycle (SDLC) using Agile Methodologies including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. Extensive experience in DataWarehousing tools like Informatica 8.x/9.x, Oracle Data Modeler, SQL developer, Putty, Winscp & Control-M. Excellent knowledge in Designing Informatica mappings, workflows, Database Modeling, writing SQL queries both simple and complex. Efficient in implementing established standard, procedure and methodologies. Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines. Excellent Analyzing, Logical, Interpersonal and Communication skills Customer Oriented attitude and experienced in working with senior level managers, business people and developers across multiple disciplines. You will be getting to learn Informatica just as the way you would learn Informatica at the Informatica university with real time examples and hands lab exercises. You will also get to use a liscesened version of Infomratica and Oracle with life time access.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
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
Class Location
Online class via Zoom
Student's Home
Tutor's Home
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
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in PL/SQL Classes
7
4.6 out of 5 5 reviews
Avanthika
"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. "
Krishna
"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. "
Kapil
"Thanks to Nagachandra sir for providing an excellent training in a well structured manner in a very short span. "
Psy
Informatica
"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. "
Have you attended any class with Nagachandra?
Answered on 19/10/2016 Learn IT Courses/Informatica
Ask a Question
Post a Lesson
Like 0 
Answers 19 
Comments Answered on 17/10/2016 Learn IT Courses/Informatica
Ask a Question
Post a Lesson
Like 3 Answers 32 Comments Ask a Question
Also have a look at
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Oracle Training
4
Oracle Products taught
Oracle PL/SQL, Oracle Database
1 Student Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Informatica Training
7
Modules
Developer
Teaches
Informatica powercenter (ETL), Informatica Realtime
Teaching Experience in detail in Informatica Training
I am currently working as development manager in a MNC. Having 9.3+ years of experience in IT industry in Analysis, design, development, documentation, Maintenance and support of Application Software. Indomitable experience in teaching 200+ students. Paramount experience in teaching Informatica (8.x/9.x), Datawarehousing and Oracle SQL. Worked closely with Lead Architects, Product Strategists, Product Managers, Scrum Masters and other Development Leads to enhance the overall structure/outcome of the products owned by me and to scale it to its zenith. Strong Data Warehousing & ETL experience of using Informatica 9.6.1/9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager. Hands-on experience across all stages of Software Development Life Cycle (SDLC) using Agile Methodologies including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing. Extensive experience in DataWarehousing tools like Informatica 8.x/9.x, Oracle Data Modeler, SQL developer, Putty, Winscp & Control-M. Excellent knowledge in Designing Informatica mappings, workflows, Database Modeling, writing SQL queries both simple and complex. Efficient in implementing established standard, procedure and methodologies. Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines. Excellent Analyzing, Logical, Interpersonal and Communication skills Customer Oriented attitude and experienced in working with senior level managers, business people and developers across multiple disciplines. You will be getting to learn Informatica just as the way you would learn Informatica at the Informatica university with real time examples and hands lab exercises. You will also get to use a liscesened version of Infomratica and Oracle with life time access.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
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
Class Location
Online class via Zoom
Student's Home
Tutor's Home
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
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in PL/SQL Classes
7
Answered on 19/10/2016 Learn IT Courses/Informatica
Ask a Question
Post a Lesson
Like 0 Answers 19 Comments Answered on 17/10/2016 Learn IT Courses/Informatica
Ask a Question
Post a Lesson
Like 3 Answers 32 Comments Ask a Question
Want to learn from Nagachandra?
Share this profile 
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
Informatica Course Contents 
