Nagachandra

Years of Experience in Oracle Training

4

Years of Experience in Informatica Training

7

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.

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

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

Years of Experience in PL/SQL Classes

7