Informatica IDMC - IICS - Cloud Data Quality (CDQ) Concepts

The Informatica IDMC – Cloud Data Quality (CDQ) Concepts course is designed for beginners, intermediate professionals, data engineers, data stewards, ETL developers, and architects who want to strengthen their expertise in data quality management within the Informatica Intelligent Data Management Cloud (IDMC) ecosystem.

This course provides a comprehensive and hands-on understanding of Informatica’s Cloud Data Quality (CDQ) and Cloud Data Profiling (CDP) applications — powerful, cloud-native solutions that enable organizations to assess, monitor, standardize, cleanse, and govern data quality across enterprise systems.

You will learn how Cloud Data Quality integrates seamlessly with other IDMC services such as Cloud Data Integration (CDI), Customer 360, and Cloud Data Profiling, helping organizations establish accurate, consistent, and trusted data across the enterprise.

By the end of this course, you will be able to ;earn following topics:

Section 1: Introduction to Cloud Data Quality

• Understand the prerequisites for working with Cloud Data Quality

• Learn core terminologies related to Data Profiling and Data Quality

Section 2: Administrative Activities for Data Profiling and Data Quality

• Verify licenses and enabled features required for CDP and CDQ

• Enable Data Quality Services within the Secure Agent Group

• Configure required user groups and roles for Data Profiling and Data Quality access

• Create and configure a Snowflake connection for profiling and quality tasks

Section 3: Data Profiling Overview

• Understand the concept and purpose of Data Profiling

• Explore real-world business use cases for Data Profiling

• Learn how to access and navigate the Informatica IDMC platform

Section 4: Cloud Data Profiling (CDP) – Application Overview

• Overview of the Cloud Data Profiling service

• Understand the Data Profiling Task template and its components

• Configure a Data Profiling Task using a Snowflake connection

• Analyze and interpret profiling results

• Create a Customer Data Profile using a Flat File connection

• Analyze Customer Data Profile results and prepare Data Quality rules

• Design effective Data Quality rules based on profiling insights

Section 5: Cloud Data Profiling – Advanced Features

• Share profiling results with stakeholders

• Understand scheduling options for automated profiling jobs

• Run profiling tasks with filter conditions for targeted analysis

Section 6: Cloud Data Quality (CDQ) – Application Overview

• Overview of the Cloud Data Quality application

• Understand fundamental CDQ concepts

• Install and configure out-of-the-box Data Quality assets

Section 7: CDQ – Dictionary

• In-depth understanding of Dictionaries in CDQ

• Create a Dictionary using Data Profiling results

• Update a Dictionary using file import

• Create a Dictionary manually

• Understand the storage location of Dictionary data on the Secure Agent

Section 8: CDQ – Rule Specification

• Understand the concept of Rule Specification

• Create Rule Specifications to handle null values

• Invoke a Dictionary within a Rule Specification

• Use constant values in Rule Specification logic

• Invoke one Rule Specification within another

• Design and implement multi-step Rule Specifications

Section 9: Integration of CDQ Rule Specification

• Integrate Rule Specifications within Cloud Data Integration (CDI)

• Use Rule Specifications in the Customer 360 application

• Apply Rule Specifications within Cloud Data Profiling

Section 10: CDQ – Address Verifier

• Understand the Address Verifier functionality

• Identify the Address Verifier license location

• Create and configure an Address Verifier

• Integrate Address Verifier within Cloud Data Integration

Section 11: CDQ – Labeler

• Understand the Labeler transformation

• Configure and use the Character Labeler

• Configure and use the Token Labeler

• Invoke the Labeler transformation in Cloud Data Integration

Section 12: CDQ – Parser

• Understand the Parser transformation

• Create a Parser using Regular Expressions

• Create a Parser using a Dictionary

• Invoke the Parser transformation in Cloud Data Integration

Section 13: CDQ – Cleanse

• Explore business scenarios for Cleanse rules

• Configure and design Cleanse rules

• Invoke Cleanse rules in Cloud Data Integration

Section 14: CDQ – Duplication and Consolidation

• Understand Duplicate rule configuration

• Understand consolidation strategies

• Configure a Duplicate rule

• Invoke the Duplicate rule in Cloud Data Integration

Section 15: Realtime Project Scenarios

• Development of Record Rejection Mapplet

• Execution of Record Rejection Mapplet