Informatica

INTRODUCTION TO DATAWAREHOUSING

·         Data Warehousing Concepts

·         Dataware housing (what/Why/How)

·         Data Modelling(Schemas, FACTS and DIMENSIONS)

·         Slowly Changing Dimensions

·         Metadata

POWERCENTER COMPONENTS AND USER INTERFACE

·         PowerCenter Architecture

·         PowerCenter Client Tools

·         Lab – Using the Designer and Workflow Manager

SOURCE QUALIFIER

·         Source Qualifier Transformation

·         Lab Project Overview

·         Lab A – Load Payment Staging Table

·         Source qualifier Joins

·         Lab B – Load Product Staging Table

·         Source Pipelines

·         Lab C – Load Dealership and Promotions Staging Table and Real time issues

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 I

·         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 – LAB

SCD type2 – LAB

SCD type3 – LAB

MAPPLETS

·         Mapplets

·         Lab – Load Product Daily Aggregate Table

·         Review and more Lab Activities and Real time issue

WORKFLOW VARIABLES AND TASKS

·         Link Conditions

·         Workflow Variables

·         Assignment Task

·         Decision Task

·         Email Task

·         Lab – Load Product Weekly Aggregate Table

MORE TASKS AND REUSABILITY

·         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

·         Lab – Load Inventory Fact Table

INFORMATICA ANALYST 9.1

·         Analyst GUI

·         Metadata and Data access/import

·         Column Profiling

·         Frequency/Patterns/Statistics/Drill downs

·         Rule Profiling

·         Out Of The Box rules

·         Custom rules

·         Reference Tables Management

·         Project Collaboration

·         Data Quality Score carding

INFORMATICA DEVELOPER 9.1

·         Developer GUI

·         Developer Profiling including:

·         Mid-stream profiling

·         Join analysis profiling

·         Building Data Quality Mapplets and Rules

·         Data Standardization

·         Cleanse, transform and parse data using DQ transformations such as the Case Converter, Merge, Labeller, Standardizer, Parser

·         Address Validation

·         Perform address validation and create AV mapplets and mappings 

·         Matching

·         Group data prior to matching to improve matching performance

·         Perform DQ and Identity Matching to identify duplicate records

·         Develop Matching Mapplets

·         Associate and Consolidate matched data

·         Work with the Data Quality Assistant

·         PowerCenter Integration

·         Parameterization

·         Data Quality Workshop

Business Analyst

BA fundamentals 

The 80/20 Practical Training Model

Most of your training time is spent in hands-on practice, enabling you to master the methods and techniques that professional BAs use on the job.

---

Live Project Documents

Working with live project documents, such as Business Requirements (BRDs), Functional Requirements (FRDs), and Use Case Documents, lets you see the details of actual projects from the inside out.

---

Complete Reference Material

You'll get complete documentation of each session plus a reference guide to key BA concepts and practices, providing you with a centralized source for ongoing reference.

---

Hands-on Case Study Approach

Our Case Study approach teaches you to think like a BA. Practice using BA methods to develop all the key BA deliverables (including BRDs, FRDs, Use Case Diagrams, etc.) based on realistic Business scenarios.

---

Access to BA Modeling Tools

Hands-on practice using the tools BAs use to maximize productivity on the job. Sample tools: Rational Suite, MS-Visio, MS-Project, HP Quality Center, JIRA, and Team Forge.

---

Resume Preparation

Assistance in preparing your resume to meet expectations of potential employers.

---

Job Search / Placement Assistance

Job search assistance including direct referrals, as well as access to lists of employers and job openings plus job search advice based on your interests and qualifications.

---

Mock Interviews

We provide sample questions and answers and coach you through mock interviews. Practice answering tough interview questions and receive a critique of your answers.

---

Continuing on the Job Support

The Trainer continues to be available post-training when students are on the job.

Our BA Essentials ^SM course offers what you need to overcome the challenges and get started in a BA career.

• Our structured lessons teach you the concepts, skills and ways of thinking you need to become a successful Business Analyst
• Written documentation provides a recap of each course session, plus comprehensive details about BA methods for ongoing reference.
• Live project documents produced by working BAs show you the details of what BAs produce.
• Case study projects give you hands-on practice applying BA methods to real business problems. Learn the skills BAs actually use on the job, and have the instructor critique your work.
• Small classes provide direct interaction with the instructor and other students to help ensure the course works for you.

CONTACT

COMUNICATION METHOD:

Email: Michleramds@gmail.com

Phone: +1-347-491-5246

G-talk: roiarjun5

 This course aims to provide participants with the solid experience and know-how to work as Business Analyst in various domains like Banking, HealthCare, Finance, Ecommerce, Mobile and Product. This course has been developed for real-world scenarios with in-depth explanations.

MODULES

Module 1.        Introduction to Business Analysis

Module 2.        Understanding and Capturing business needs

Module 3.        Requirement Analysis Process

Module 4.        Creating Requirement gathering strategy

Module 5.        Modeling Data and Processes

Module 6.        UML Methodology

Module 7.        Creating Effective Use Cases

Module 8.        Business Analysis Tools

Module 9.        Requirement Gathering, Business Modeling & Analysis Tools – MS Visio

Module 10.      Project Documentation and Management

Module 11.      Software Testing

Module 12.      Requirement Gathering, Analysis and BRD creation

All these modules are covered with notes

           

And shared with the student once the topic is completed.

Attendees will be assigned with assignments at the end of each class.

All the examples discussed are related to different domains like: Banking, E-Commerce, Health Care etc

Topics Covered

Introduction to Business Analysis

1.         Introduction to Business Analysis

2.         Business Composition and Architecture

3.         Roles and Responsibilities of a Business Analyst

4.         Need for a Business Analyst

5.         Project Team

6.         Importance of a Business Analyst in the Project Team

System Development Life Cycle (SDLC)

1.         Understanding Concept of Business Modeling

2.         Requirement Gathering

3.         Analysis

5.         Implementation

6.         Testing

7.         Deployment

SDLC Methodologies:

Waterfall Model

Prototype

RUP

Spiral

V-Model

Agile

SCRUM

Understanding and Capturing business needs

1.         Setting up priorities

2.         Feasibility studies

3.         Project scope

4.         Business case

5.         Risk assessment

6.         Evaluating and selecting an initiative

7.         Setting up future vision

Requirement Analysis Process

Identify Key Stakeholders

Gather Stakeholder requirements

Categorize Requirements

Interpret and Record Requirements

Signoff

Requirement Gathering Techniques

Brainstorming

Focus Group Interviews

Questionnaire(Survey)

Observation(Client and Client Customer)

Use Cases

Studying the existing documents

Prototyping

JAD

Requirement Documentation

Business Requirement Document

High Level Requirements Document

Low Level Requirements Document

Software  Requirements Specification Document

Change Request Document

Requirement Traceability Matrix

Effort Estimations

Minutes Of Meeting

Proof Of Concept

Request For Proposal

Use Case Document

Understanding Use Cases

Use Case Relationships

Use Case Brainstorming

Creating Use cases from Requirements

Creating Use Case Narratives

Change Management & Version Control Concept

K245: Requirement Gathering Document used only by American Express

UML (MS Visio and Wire framing Tools)

Activity Diagrams

Use Case Diagrams

Communication Diagrams

Interaction Diagrams

Collaboration Diagrams

Class Diagrams

Sequence Diagrams

Wire framing

Software Testing

1.         Introduction to QA Methodology

2.         Role of BA in Testing

3.         Creating Test Plans

4.         Creating Test Cases

5.         Different Testing Methods

6.         Functional and Regression testing

7.         White Box and Black Box Testing

8.         Positive and Negative Testing

9.         GUI and Unit Testing

10.       User Acceptance Testing

​

Phone: 347 491 5246

Email: michleramds@gmail.com

| BA | QA | JAVA | HADOOP | SQL | ORACLE | SELENIUM |

"Training & Job Placement + Profile Marketing Help |