Informatica Data Quality

The Informatica Data Quality - Administration training course provides the fundamental knowledge and skills to maintain an Informatica Data Quality environment. Focused on teaching individuals how to use the Informatica Administrator tool to maintain the required environment.

In Informatica Data Quality Management for Developer training course, you will gain the skills and knowledge necessary to implement and automate a data quality assurance process with the Informatica Data Quality platform. In addition, learn how to cleanse, standardize, and enhance data, students will learn to test and troubleshoot their Data Quality solutions.

In Informatica Data Quality - Advanced Techniques training course, you will learn to leverage advanced techniques when utilizing Developer to profile, cleanse, standardize, de-duplicate and consolidate data in an enterprise. Focused on creating and applying custom built Classifier and Probabilistic Models, utilizing advanced Parsing and Matching methods, refining Human Tasks and Workflows, automatically Associating and Consolidating matched records, applying Parameters in mappings and more.

By attending Informatica Data Quality - Administration workshop, delegates will learn to:

  • Describe core administration tasks and tools
  • Configure the Informatica Administrator tool
  • Create and configure necessary services
  • Manage Informatica security
  • Audit security access and privileges
  • Perform ongoing maintenance
  • Stop or recycle a service
  • Review domain logs

By attending Informatica Data Quality Management for Developer workshop, delegates will learn to:

  • Describe the Data Quality Management Process
  • Illustrate the Data Quality Architecture
  • Differentiate between the Analyst and Developer Roles and Tools.
  • Navigate the Developer Tool
  • Collaborate on projects
  • Perform Column, Rule, Multi object, Comparative and Mid-Stream Profiling
  • Manage Reference Tables
  • Develop standardization, cleansing and parsing Mappings and Mapplets
  • Identify duplicate records using Classic Data Matching
  • Create and execute Workflows to populate user inboxes with Exception and Duplicate record tasks
  • Describe the deployment options available when executing Mappings outside of Informatica Developer
  • Troubleshoot issues that may appear during development

By attending Informatica Data Quality - Advanced Techniques workshop, delegates will learn to:

  • Perform Join Profiling.
  • Create and apply Classification Models
  • Parse data using advanced techniques
  • Create and apply Probabilistic Models
  • Apply sophisticated Grouping and Matching techniques
  • Automatically Associate and Consolidate matched records
  • Refine Exception and Duplicate Record Workflows used to populate Analyst inboxes
  • Design, Implement and Test processes to manage updated exception/duplicate records
  • Appropriate DQ Parameters
  • Examine Performance considerations
  • Review CRM and Dashboard & Reporting Templates
  • Optionally/Time allowing:
    • Leverage Web Services to apply DQ mappings in Excel
    • Perform Identity Matching.
      • Use the Universal ID store to match against master data

For Informatica Data Quality - Administration

  • Knowledge in SQL
  • General relational database (Oracle)
  • Microsoft Windows GUI
  • Windows Command line
  • General programming

For Informatica Data Quality - Advanced Techniques

  • Attend a training on Informatica Data Quality Management for Developer or having equivalent knowledge / experience

For Informatica Data Quality - Administration

  • Administrators

For Informatica Data Quality Management for Developer

  • Developers

For Informatica Data Quality - Advanced Techniques

  • Developers


Informatica Data Quality - Administration
(Duration : 3 Days)


Data Quality Introduction

  • Informatica Data Quality technical architecture
  • Informatica domain, nodes, and application services
  • Overview of the PowerCenter clients

Best Practices

  • Configuring an environment
  • Recognized Naming Conventions

Installing Informatica

  • Installing Informatica
  • Reviewing installation logs
  • Using command-line utilities

Using the Informatica Administrator tool

  • Administration tool layout and navigation
  • Views in the Manage Tab
  • Services and Nodes
  • License key types

Configuring the Model Repository Service

  • Adding and moving a Model Repository Service
  • Auditing

Configuring the Data Integration Service

  • Creating connections
  • Home Directory location
  • Stopping and starting a service

Users and Groups

  • Creating user and group accounts
  • Creating accounts using scripts
  • Adding users to groups
  • Importing LDAP user accounts and groups

Privileges and Roles

  • Configuring roles and privileges
  • Assigning privileges and roles
  • Domain folders and services


  • Assigning permissions to domains and domain objects
  • Verifying permissions

Configuring the Analyst Service

  • Creating connections
  • Analyst Services
  • Analyst Service folders
  • Analyst Service permissions and log
  • The Analyst command line

Configuring the Content Management Service

  • Connecting the Developer client to the domain
  • Data Integration Service defaults
  • MRS projects and set permissions
  • Project folders and set permissions
  • Simple mapping
  • Deploying mappings

Configuring the Data Director Service

  • The Scheduler Service
  • Setting a schedule

Domain Administration and Management

  • Create and configure a Content Management Service (CMS)
  • Install OOTB content
  • Install Identity (IMO) content
  • Install Address Doctor (AD) content
  • Install the Classifier model

Monitoring and Troubleshooting

  • The Monitoring view
  • Configuring Log Management properties
  • Filtering logs
  • Auditing user activity
Informatica Data Quality Management for Developers
(Duration : 4 Days)




Data Quality Process Overview

  • Data Quality Management Process Cycle
  • Dimensions of Data Quality
  • Data Quality Processes
  • Developer and Analyst Roles and Tools
  • Data Quality Architecture

Data Quality Projects and Solutions

  • Customer Data Quality Use Cases
  • Projects that benefit from cleansed and standardized data
  • Data Quality and typical DI/DQ projects
  • Reporting, Gating and Cleansing projects
  • Solution Architecture for Projects with Data Quality

Project Collaboration and Reference Table Management

  • Developer Interface
  • Understanding Analyst projects, Data Objects, Profiles, Rules, Scorecards, Comments and Tags
  • Reference Tables and the Data Quality Process
  • Creating Reference Tables

Working in the Developer Tool

  • Tasks in the Developer Tool
  • Working with Physical and Logical Data Objects
  • Connecting to a table
  • Importing and flat file
  • Creating logical data objects
  • Developer Transformations
  • Mappings and mapplets
  • Content sets and their uses
  • Developer Tips and Tricks

Profiling, Mapplets and Rules

  • Column Profiling
  • Mapplets and Scorecards
  • Profiling techniques to debug and improve development
  • Updating Scorecards with Rules

Standardizing, Cleansing and Enhancing Data

  • Standardizing, cleansing and enhancing data
  • Mappings that cleanse, standardize and enhance data
  • Developing standardization mapplets
  • Configuring standardization transformations

Parsing Data

  • The Parsing Process
  • Parsing techniques
  • Key parsing transformations

Matching Data

  • Match Data definition
  • The DQ matching process
  • The different stages of Matching
  • Grouping and its effect on matching
  • Grouping methods
  • Grouping results and refining a grouping strategy
  • Match algorithms

Manual Exception and Consolidation Management

  • Exception and Duplicate record management
  • Exception Management Process
  • Populating tables with exception and duplicate record tasks

Building, Managing and Deploying Workflows

  • Workflows and Workflow Tasks
  • Human Tasks and Steps
  • Identifying exception and duplicate records
  • Deploying and executing workflows
  • Verifying Tasks in Informatica Analyst

Deploying: Executing Mappings outside of the Developer tool

  • Deployment options
  • Mappings as applications
  • Scheduling mappings, profiles and Scorecards

Importing and Exporting Project Objects

  • Export/import project use cases
  • Basic and Advanced Import options
  • Exporting a project


  • Common Developer errors
  • Common Mapping and Transformation configuration issues
  • Common Workflow configuration errors
  • Tips for working with the Developer tool
Informatica Data Quality - Advanced Techniques
(Duration : 4 Days)




Developer Review & Join Profiling

  • A quick review of Informatica Developer
  • Use Enterprise Discovery to create Join Profiles

Standardizing and Classifying Data

  • Review Standardization Techniques
  • Build, refine and apply a Classifier Model
  • Labs: Create, refine and apply Classifier Model

Advanced Parsing Techniques

  • What is Probabilistic Labeling and Parsing?
  • Build, refine and apply a Probabilistic Model
  • Additional Parsing Techniques:
    • Build regular expressions.

Grouping & Matching Data

  • Additional Grouping Techniques
    • Using Composite keys
  • Advanced Matching Techniques
    • Matched pairs outputs
    • Working with Match Mapplets
    • Manipulating the matched data using the Driver ID
    • Perform Dual Matching

Automatically Associate and Consolidate Matched Data

  • Overview of the Consolidation Process
  • Use the Consolidation Transformation to consolidate matched data
  • Use the Association Transformation to link matched data ahead of Consolidation

Task and Workflow Management

  • Additional Task and Workflow functionality:
    • Permission settings for data access and editing
    • Notifications including Human Task Notification Variables
    • Setting Timeouts
    • Reviewing Tasks
    • Configuring Workflow Recovery

Processing Updated Exception and Cluster Data

  • How to process updated exception records
  • How to process consolidated records
  • Fields of Interest

Analyst Tasks

  • Update exception and duplicate records in Informatica Analyst


  • Explain the difference between System and User defined parameters
  • Use Parameters in Data Quality mappings

Performance tips and tricks

  • General Installation and Memory Information
  • DQ Component Configuration
    • Service Settings
  • DQ Transformations
    • Configuration Settings

Identity Matching

  • Match Data using Identity Matching
    • Use UID to match data against a Master Data Store
  • Mixed Matching Workshop

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.