Informatica Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

Informatica Professional Role Based Training Course Duration: 50-55 hrs. + Assignments + Project Based Case Studies Prerequisite: Basic computer skills and IT

C L

Timings: Weekdays & Weekends (after work hours) Mode of Training: Live Instructor-led online training using Cisco Webex Meeting Center tool.

L

How Are We Different?  We just don’t teach Informatica Concepts but we share our real-time implementation experiences to get the audiences ready to face customers and Implement Solutions.  We don’t just teach Informatica but we make them Complete & Full-fledged Informatica Consultants by training them on Development, Administration & Application Design with Project based real-time scenarios and several Case Studies for practice  Our faculties are not just technical developers or trainer’s, they are industry experts and consultants for fortune 500 companies who are highly capable of understanding the

h c

e T

Training Highlights: Benefits: Gettingstarted with Cleansing Package Builder Focus on Hands on training  Quality Course Material & E-books • About cleansing data  Video Recordings of sessions provided  24 x 7 Online access to trainers for Doubts • About cleansing packages • Cleansing package types Clarification,  Demonstration of Concepts using different • Create cleansing packages tools  Project based training with hands on exp • Assign standard forms and variations • Updating a published cleansing package  One Problem Statement discussed across the  Assignments after every sessions • Viewing published cleansing packages training program  Video Recordings provided for Review • Person Whole and firm cleansing packages  Introduction to Data Warehousing, Infomatica  Resume Preparation Guidance Designer  Mock Interviews from Professional Consultants,  Understand the Transformation, Mapping and  Marketing one-on-one with a Recruiter Qualifier  Real-time Project Documents CourseTitle: Business Analyst Competency Development Program Resume prep, Interview Questions provided  Onsite Job assistance for 3-4 months Course Duration: 45 hours Training  Informatica Certification Guidance  Special Project training programs for trained Training Materials: All attendees would receive

n a

r a

Z

 

OPT’s and CPT’s

Training presentation of each session,

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 1 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

Informatica Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

Training Format: This course is delivered as a highly interactive session, with extensive live examples. This course is delivered in Online using Web and Audio Conferencing. In this training, attendees will learn:

Module Module Module Module Module Module Module Module Module

1. 2. 3. 4. 5. 6. 7. 8. 9.

Informatica Introduction Introduction to Data Warehousing Configuration Introduction to Informatica Designer Transformation Mapping Qualifier Workflow Manager Informatica Advanced Features

C L

Attendees also learn: 1. Resume Preparation Guidelines and Tips 2. Mock Interviews and Interview Preparation Tips should attend? Who should plan on joining?  College Degree from any University.  SQL Knowledge preferred but not Mandatory

h c

L

e T

About the trainer: 1. Certified HANA 1.0 consultant with exclusive experience in POC (Proof of Concept) projects with BIG 5 consulting companies and a Sr. SAP consultant. 2. More than 12 years of Consulting & Teaching experience in different modules of SAP BW versions (2.0B, 2.1, 3.0B, 3.1C, 3.5, BW 7.0 NW 2004S, BW 7.3), BPC 10, CRM (5.0, CRM2007), SD, ABAP/4. SAP Business Objects. Primarily SAP BI 4.1. 3. Certified SAP BO Consultant with WEBI and Crystal reports Certifications 4. With a strong back ground in training and deep knowledge of the core subject and techniques on getting certification successfully completed many batches in US and Canada. 5. Trained over 500 students and 80% of the students accomplished in getting certification in various modules.

n a

r a

Z

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 2 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

Informatica Competency Development Program

Informatica Professional Based Training Enhancements

We focus on delivering Role-Specific training rather than Product based Training

INFORMATICA TRAINING PROGRAM ROADMAP Introduction to Data Warehousing

Introduction to Informatica

h c

Introduction to Informatica Designer

Transformation

e T

L

Workflow Manager

Qualifier

C L Configuration

Mapping

Informatica Advanced Features

n a

r a

100 plus Assignments Sample Questions, Case Studies Informatica Certification Guidance

Z

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 3 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

Informatica Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

Topics covered: Introduction to Informatica 1. Overview 2. Basic Definitions 3. Informatica products 4. Informatica Architecture 5. Folders-Sub folders 6. ETL Tools and their roles 7. ETL information power center / Power mart

C L

Introduction to Data Warehousing 1. Data warehousing (what is Data warehousing /Why Data warehousing/How Data warehousing) 2. Slowly Changing Dimensions (SCD1, SCD2, SCD3) 3. Metadata 4. Dimensional Table 5. Types Of Dim Tables 6. Fact Table 7. Types of Fact Tables 8. OLTP (Online Transaction Processing) 9. OLAP (Online Analysis And Processing) 10. OLTP Vs OLAP 11. Advantages of OLAP 12. Different Methodologies of DWH

h c

Configuration 1. Informatica configuration 2. Instigation Services 3. ETL Folder 4. ETL Job Filz

L

e T

n a

r a

Introduction to Informatica Designer 1. Introduction to Designer 2. Logon to Designer 3. Designer interfaces 4. Designer Tools 5. Defining Sources 6. Database as a source 7. Flat File sources 8. Defining Targets 9. Importing from database 10. Creating a new target 11. Creating target database objects

Z

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 4 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

Informatica Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

Transformation 1. Aggregate Transformation 2. Shorter Transformation 3. Active and Passive Transformations 4. How Sequencer work and Uses of Sequencer Transformation 5. Filter Transformation 6. Lookup transformation 7. Connected lookup 8. Unconnected lookup 9. Joiner Transformation 10. Filter Transformation 11. Ranking Transformation 12. Router Transformation 13. Expression Transformation 14. Sequence Generator Transformation 15. Rank Transformation 16. Stored Procedure Transformation(Connected and Unconnected) 17. Union Transformation 18. XML Transformation Mapping 1. Mapping Introduction 2. Ports 3. Mapping – Table to Table 4. Mapping Flat File to Table 5. Mapping Wizards 6. Implementing Type-I, Type-II, Type-III Mappings

h c

C L

L

e T

n a

Qualifier 1. Source Qualifier Transformation 2. SQL override in source qualifier transformation 3. Source qualifier transformation joins concept 4. Source qualifier transformation on Relational Databases 5. Source qualifier transformation on File systems 6. Source qualifier transformation filter concepts 7. Difference Between SQL Override, Other Options 8. Source Qualifier to join Data 9. Source Qualifier Transformation Performance Tunning 10. Pre SQL and Post in Source Qualifier Transformation

r a

Z

Workflow Manager 1. Workflow Introduction 2. Tasks 3. Workflow tools 4. Connections 5. Defining tasks 6. Command Tasks 7. Email Task

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 5 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

Informatica Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

8. 9. 10. 11. 12. 13. 14.

Session Task Link Conditions Event Wait & Event Raise Setting Properties of Session Task Creating Workflow Starting Workflow Monitoring Workflow

Informatica Advanced Features 1. Incremental Aggregation 2. Mapplet Implementation 3. Target Load Plan 4. Constraint Based Loading 5. Mapping Variable 6. Session Parameters 7. Link Conditions 8. Reusable Transformation 9. Task and Types of Tasks 10. Work let and Types of work lets 11. Scheduling Workflow 12. Control flow using Command task and event wait task 13. Incremental Loading

C L

h c

L

e T

n a

r a

Z

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 6 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA

Informatica Competency Development Program We focus on delivering Role-Specific training rather than Product based Training

CASE STUDY # 1 – “Creation of HANA Schema for SALES” Creation of HANA Schema from scratch (Sales Domain):

C L

In this Case study we will be creating a SAP Schema from scratch for Sales Domains. This Case Study also illustrates different types of challenges you will face while designing the HANA schema, importing the tables, Tasks: 1. 2. 3. 4. 5. 6.

Designing HANA schema Designing SAP BODS 4.2 Dataflows to load the data to HANA Troubleshooting Creating Attribute Views, Analytical Views and Calculation Views Reporting – Generating Sales reports using BI 4.1 reporting tools and MS Excel Example Reports are Sales Order Header, Item Level, Scheduling level and Sales Overview reports

h c

L

CASE STUDY # 2 – “Creation of HANA Schema for FINANCE” Creation of HANA Schema from scratch (Finance Domain):

e T

In this Case study we will be creating a SAP Schema from scratch for Finance Domains. This Case Study also illustrates different types of challenges you will face while designing the HANA schema, importing the tables, Tasks: 1. 2. 3. 4. 5. 6.

Designing HANA schema Designing SAP BODS 4.2 Dataflows to load the data to HANA Troubleshooting Creating Attribute Views, Analytical Views and Calculation Views Reporting – Generating Finance reports using BI 4.0 reporting tools and MS Excel Example Reports are Balance Sheet Reports, Income Statements, Consolidated Income Statements, P&L Reports

n a

r a

Z

ZaranTech LLC. , http://www.zarantech.com, [email protected] , (515) 309-7846, Page - 7 5550 Wild Rose Lane, Suite # 400, West Des Moines, IOWA 50266. USA