Data Quality: Data Quality Management for Developers

Training Overview

This training is applicable to version 10. x. Gain the skills & knowledge necessary to implement & automate the data quality assurance process with the Informatica Data Quality platform. In addition, master how to cleanse, standardize, & enhance data while testing & troubleshooting Data Quality solutions.

Audience

Developer

Learning Objectives

After successfully completing this training, professionals should be able to:

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

Content Outline

  • Training topics
  • Modules & content
  • Data Quality Management Process Cycle
  • Dimensions of Data Quality 
  • Data Quality Processes 
  • Developer & Analyst Roles & Tools
  • Data Quality Architecture
  • Customer Data Quality Use Cases
  • Projects that benefit from cleansed & standardized data
  • Data Quality & typical DI/DQ projects
  • Reporting, Gating, & Cleansing projects
  • Solution Architecture for Projects with Data Quality
  • Developer Interface
  • Learning about Analyst projects, Data Objects, Profiles, Rules, Scorecards, Comments, & Tags
  • Reference Tables & the Data Quality Process
  • Creating Reference Tables 

    Lab: 

  • Review a project created by an Analyst
  • Build Reference Tables
  • Tasks in the Developer Tool
  • Working with Physical & Logical Data Objects
  • Connecting to a table
  • Importing & flat file
  • Creating logical data objects
  • Developer Transformations
  • Mappings & mapplets
  • Content sets & their uses
  • Developer Tips & Tricks
  • Lab: 
  • Create a project & assign permissions
  • Create a connection to an Oracle table & import a flat file
  • Build a Logical Data Object
  • Column Profiling 
  • Mapplets & Scorecards
  • Profiling techniques to debug & improve development 
  • Updating Scorecards with Rules

Lab: 

  • Creating a rule to measure the accuracy of data in a field.
  • With the help of an Informatica Analyst, apply the rule to a Scorecard & review the results.
  • Standardizing, cleansing, & enhancing data.
  • Mappings that cleanse, standardize, & enhance data
  • Developing standardization mapplets
  • Configuring standardization transformations

Lab: 

  • Build a Standardization Mapping & Mapplets using Standardization Transformations.
  • The Parsing Process 
  • Parsing techniques 
  • Key parsing transformations

Lab:

  • Perform Parsing using a variety of Parsing Transformations
  • Complete a Standardization Mapping
  • Match Data definition
  • The DQ matching process
  • The different stages of matching 
  • Grouping & its effect on matching
  • Grouping methods
  • Grouping results & refining a grouping strategy 
  • Match algorithms

Lab:

  • Build & fine tune a grouping & matching mapping
  • Exception & Duplicate record management 
  • Exception Management Process.
  • Populating tables with exception & duplicate record tasks

Lab:

  • Build a Mapping that can be used to identify Exception data
  • Build a Mapping that can be used to identify Duplicate data
  • Workflows & Workflow Tasks
  • Human Tasks & Steps
  • Identifying exception & duplicate records
  • Deploying & executing workflows
  • Verifying Tasks in Informatica Analyst.
  • Lab: Build a Workflow to populate the Analyst Inbox with Exception Tasks

Lab: 

  • Build a Workflow to populate the Analyst Inbox with Duplicate Record Tasks
  • Deployment options.
  • Mappings as applications
  • Scheduling mappings, profiles, & Scorecards 

Lab:

  • Schedule Mappings to run using Informatica Scheduler.
  • Export/import project use cases
  • Basic & Advanced Import options
  • Exporting a project 
  • Lab: Import a Project using the Basic method.
  • Lab:
  • Import a Project using the Advanced Method.
  • Export a Project.
  • Common Developer errors
  • Common Mapping & Transformation configuration issues
  • Common Workflow configuration errors
  • Tips for working with the Developer tool 
  • Lab (Optional): Troubleshoot Mapping configuration issues

FAQs

A: To maintain a high quality of information, a set of practices are done by organizations & this is called Data Quality management.

A: Flow charts, check sheets, cause & effect diagrams, Histograms, and Control charts are some of the tools of quality management.

A: With the Informatica Data Quality platform, professionals will learn how to implement & automate a data assurance quality process. Professionals will gain knowledge to enhance, clean & standardize data.

A: Improved data quality leads to better decision-making for a company. Users will be more confident in decisions with high quality. Good data reduces risk & can result in consistent improvements in results.

A: Types of data management tools are:

  • PIM (Product Information Management)
  • MDM (Master Data Management)
  • DM (Data Modelling)
  • DW (Data Warehouse)

A: Radiant has highly intensive selection criteria for Technology Trainers & Consultants who deliver training programs. Our trainers & consultants undergo rigorous technical & behavioral interviews & assessment processes before they are onboarded in the company.

Our Technology experts/trainers & consultants carry deep-dive knowledge in the technical subject & are certified by the OEM.

Our training programs are practically oriented with 70% – 80% hands-on training technology tools. Our training program focuses on one-on-one interaction with each participant, the latest content in the curriculum, real-time projects & case studies during the training program.

Our faculty will provide you the knowledge of each training from a fundamental level in an easy way & you are free to ask your doubts any time from your respective faculty.

Our trainers have the patience & ability to explain difficult concepts in a simplistic way with depth & width of knowledge.

To ensure quality learning, we provide support sessions even after the training program.

A: Radiant Techlearning offers a training program on weekdays, weekends & a combination of weekdays & weekends. You can always choose the schedule that best suits your need.

A: We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or any commercial use.

A: Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant hand-on-practice. 

Participants can easily access these labs over Cloud with the help of a remote desktop connection. 

Radiant virtual labs provide you the flexibility to learn from anywhere in the world & in any time zone. 

Send a Message.


  • Enroll
    • Learning Format: ILT
    • Duration: 80 Hours
    • Training Level : Beginner
    • Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
    • Price : INR 25000
    • Learning Format: VILT
    • Duration: 50 Hours
    • Training Level : Beginner
    • Validity Period : 3 Months
    • Price : INR 6000
    • Learning Format: Blended Learning (Highly Interactive Self-Paced Courses +Practice Lab+VILT+Career Assistance)
    • Duration: 160 Hours 50 Hours Self-paced courses+80 Hours of Boot Camp+20 Hours of Interview Assisstance
    • Training Level : Beginner
    • Validity Period : 6 Months
    • Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
    • Price : INR 6000

    This is id #d