Data Quality 9.x: Developer, Level 1

Informatica is a leading independent software provider focused on delivering transformative innovation for the future of all things data. Informatica Data quality allows business users to rapidly develop business rules without relying on IT. Its integrated platform also allows you to easily manage exceptions for prompt remediation, and incorporate human tasks into your existing workflow.

  • 24 hours of Direct to Device, Instructor-Led Sessions
  • Program helps in Navigating the Developer Tool and collaborate on projects with Analysts.
  • Perform Helps in : Column, Rule, Multi object, Comparative and Mid-Stream Profiling.
  • Perform Helps in : Run data quality mappings in Power Center.
  • Perform Helps in : Build mappings used to associate and consolidate matched records.
  • Guided Assignments for hands-on learning

Call Me

Online Instructor-Led

batch loading...

Course Features

Related Courses

About Course

This course introduces students to Informatica Data Quality 9.x through lecture and hands-on exercises. The course is designed for Developers who are new to formatica Data Quality.

Informatica Developer is a thick client workbench tool that developers can use to profile, cleanse, standardize, de duplicate and consolidate data in an enterprise.

The course will introduce attendees to working with the Developer Tool, performing tasks such as creating projects and objects, profiling data and identifying anomalies.

It will cover developing mappings and mapplets for use in processes such as data standardization, address validation, identifying duplicate records and consolidation.

This course will provide users with a high-level overview of the Informatica Data Quality Process and will set the foundation for the processes that follow.

Course Objectives

After successfully completing this course, students should be able to:

  • Navigate the Developer Tool and collaborate on projects with Analysts.
  • Perform Column, Rule, Multi object, Comparative and Mid-Stream Profiling.
  • Manage reference tables.
  • Design and develop Mapplets.
  • Create standardization, cleansing and parsing routines.
  • Validate addresses.
  • Identify duplicate records using Classic and Identity matching.
  • Build mappings used to associate and consolidate matched records.
  • Create and execute Workflows to populate IDD user inboxes with Exception and Duplicate record tasks.
  • Run data quality mappings in PowerCenter.
  • Run data quality mappings in DQ Standalone.
Curriculum
Module 1:

Working with Informatica Developer 9

  • GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects
Module 2:

Analyst Collaboration

  • Reviewing projects created by the Analyst
  • Review objects, Profiles, Rules, Scorecards
  • Comments and Tags
  • Create/add Reference tables
Module 3:

Developer Profiling and Logical Data Objects

  • Create a Logical Data Object
  • Perform:
    1. Column Profiling
    2. Multi Object Profiling
    3. Mid-stream Profiling
    4. Comparative Profiling
  • Create Mappings and work with DQ and Core transformations
Module 4:

Data Standardization

  • Cleanse and transform data using Standardization
  • Transformations
  • Develop standardization mappings and mapplets
Module 5:

Parsing

  • Perform parsing using a variety of methods such as:
    1. Token Parser
    2. Pattern Parser
  • NER/Probabilistic parsing
Module 6:

Address Validation

  • Create a Reusable AV Transformation
  • Become familiar with the range of Address Validation
  • Inputs and Outputs
  • Build and execute an Address Validation Mapping
Module 7:

Matching

  • Become familiar with the concepts involved in Matching
  • Grouping data
  • Match Performance Analysis
  • DQ Matching
  • Match Cluster Analysis
Module 8:

Identity Matching

  • Be able to differentiate between the need for Identity or Classic matching
  • Become familiar with the concepts involved in Identity Matching
  • Work with Identity Populations and Strategies
Module 9:

Automatic Consolidation

  • Use the Consolidation Transformation to automatically Consolidate matched records.
  • Be able to choose the most affective consolidation strategy for your data; simple, row based or advanced.
Module 10:

Manual Exception and Consolidation Management

  • Build and execute Mappings, using the Exception Transformation, to identify exception and duplicate records.
Module 11:

Task and Workflow Management

  • Build and execute workflows to populate
  • Informatica Data Director user inboxes with exception and duplicate records.
Module 12:

Informatica Data Director

  • Update exception and duplicate records in IDD.
Module 13:

PowerCenter Integration

  • Export DQ Mappings to PowerCenter as either Mappings or Mapplets.
  • Build and execute a workflow in PowerCenter Developer using DQ mapplets.
Module 14:

Running DQ in a Standalone environment

  • Schedule DQ mappings to run in DQ
  • Standalone using Windows Task Manager.
Module 15:

Object Import/Export

  • Import Projects using both Basic and Advanced methods.
  • Export Projects
Module 16:

Content

  • What content is available with IDQ?
  • Content Management Service
  • Accelerators
Instructor

All our instructor have at least ten years of industry experience and extensive functional expertise in the fields that they teach. Instructor are handpicked from a selected group of industry experts and mentors, and trained to deliver a great online learning experience.

Certification

Course Participation Certificate from NIIT

Course Participation Soft Certificate from OEM

Pre-Requisites

Windows GUI and theoretical understanding of process development and design

FAQs

Who should join this course?

New users of Informatica Developer, including Business and Data Developers.

Users who wish to refamiliarize themselves with the Developer tool.

Why should I join this course?

Informatica Developer is a thick client workbench tool that developers can use to profile, cleanse, standardize, de duplicate and consolidate data in an enterprise.

The course will introduce attendees to working with the Developer Tool, performing tasks such as creating projects and objects, profiling data and identifying anomalies.

It will cover developing mappings and mapplets for use in processes such as data standardization, address validation, identifying duplicate records and consolidation.

This course will provide users with a high-level overview of the Informatica Data Quality Process and will set the foundation for the processes that follow.

What are the class/session timings?

Mon-Thur - 10:00 AM to 4:00 PM

Do you provide any study materials?

The faculty will share relevant reference material and links through our discussion forum and through the batch email list.

What happens if I miss a session?

In additions to the study material, we provide you with recordings of each session that you can view anytime you want. So if you miss any live class, you may refer to the recordings of that session.

What is your refund policy?

After registering for the program if for some reason you are unable or unwilling to participate in the program then you can apply for a refund. You can initiate refund any time before the 2nd session of the course After registering for the program if for some reason you are unable or unwilling to participate in the program then you can apply for a refund. You can initiate refund anytime before the second session of the course by sending a mail to support@training.com with your enrolment details and bank account details (where you want the amount to be transferred). Once you initiate a refund request you will receive the amount within 21 days after confirmation of refund request.This is provided you have not downloaded any courseware for the course.

What are the minimum system requirements to attend the program?

Course Features

batch loading...

Related Courses