Informatica Analyst, Data Discovery and Advanced Profiling

Instructor Led | Data Quality | 3 Days | Version 10

Course Overview

This course is applicable to software versions 10x. Learn to use Informatica Analyst and Developer tools to create projects and objects, profile data, and identify anomalies in order to develop a better understanding of data sets. Discover the content and structure of data through topics such as Data Domain Discovery and Enterprise Discovery Profiling including; Join Analysis, Functional Dependency Profiling, Primary Key Inference, Overlap Discovery and Foreign Key Profiling.


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

  • Navigate through the Informatica Analyst tool.
  • Create projects and assign permissions.
  • Work with Physical and Logical data objects.
  • Perform Column Profiling
  • Create and apply Rules to profiles
  • Create and manage Reference Tables
  • Build a Rule Specification
  • Manage Exception and Duplicate Record Tasks
  • Perform Scorecarding
  • Task management
  • Apply Data Domain Discovery to profiles in the Analyst Tool
  • Build and execute an Enterprise Discovery Profile in the Analyst Tool
  • Define the different types of Profiling that are available in the Developer Tool
  • Create and execute Enterprise Discovery Profiles in the Developer Tool
  • Perform Data Domain Discovery and Join Analysis Profiling
  • Perform Functional Dependency and Primary Key Inference
  • Perform Overlap Discovery and Foreign Key Profiling
  • Update the model with Primary and Foreign Key relationships
  • Generate DDL from the updated model

Target Audience

  • Business Analyst
  • Developer
  • Data Analyst
  • Data Steward


  • None

Informatica Analyst

Module 1: Introduction to Data Quality
  • Define Data Quality Management.
  • Explain the Data Quality Process.
  • Discuss Informatica’s Data Quality Architecture.
  • Navigate the Analyst Interface.
  • Create Projects and Assign Permissions.
  • Lab: Create a Project and Assign Permissions.
Module 2: Data Objects
  • Understand the types of Data Objects that exist in Informatica 10.
  • Import Flat Files and create connections to Relational Tables.
  • Build a Mapping Specification.
  • Lab: Create a variety of Data Objects.
  • Lab: Create a Mapping Specification.
Module 3: Analyst Profiling
  • Introduction to Profiling.
  • Perform Column Profiling in Informatica Analyst.
    • Interpret Profile Results using Summary and Detail view.
    • Edit Profiles.
    • Detect Outliers
    • Review and Compare Historical Profile Results
    • Schedule Profiles.
  • Lab: Create profiles, detect outliers and review profile results
Module 4: Project Collaboration
  • Collaborate with team members using shared Projects, Comments, Bookmarks and Data Exports.
  • Lab: Add Comments to Profiles and Export Profile Results.
Module 5: Rules
  • Perform Rule Profiling in Informatica Analyst.
    • Apply Prebuilt and Custom Rules.
    • Interpret Rule Results.
  • Lab: Apply Prebuilt and Custom Rules to Profiles.
  • Lab: Apply Rules to a Mapping Specification.
Module 6: Reference Table Management
  • Create Reference Tables using the Reference Table Editor and the Import Flat Files options.
  • Create Managed and Unmanaged Reference Tables.
  • Auditing of changes.
  • Lab: Create Reference Tables using a variety of methods.
Module 7: Rule Specifications
  • Convert business rules into Rule Specifications that can be applied to data.
  • Validate and Test the Rule Specification.
  • Compile the Rule Specification to create a Mapplet.
  • Review the Mapplet in the Developer Tool.
  • Lab: Create, Test and Compile a Rule Specification
Module 8: Task Management
  • Manage Exception Records.
  • Manually correct Bad/Exception Records and review the Audit Trail.
  • Consolidate Duplicate Records.
  • Review the Audit Trail.
  • Administer Tasks.
  • Lab: Manage Exception Records in the Analyst Tool.
  • Lab: Manage Duplicate Records in the Analyst Tool.
  • Lab: Administer Tasks.
Module 9: Scorecarding
  • Understand how to build and configure a Scorecard.
  • Apply Weightings.
  • Review Trend Charts.
  • Configure Notifications.
  • Lab: Create, Edit and Run a Scorecard.
  • Lab: Configure and Review Notifications.
  • Lab: Schedule Scorecards and Profiles to run using Informatica Administrator.

Data Discovery and Advanced Profiling

Module 1: Analyst Tool: Data Domain Discovery and Enterprise Discovery Profiling
  • Data Domain Profiling 
  • Inferring/identifying sensitive data 
  • Building and executing an Enterprise Discovery Profile 
  • Lab: Update a Profile to perform Data Domain Discovery
  • Lab: Create, execute and review an Enterprise Discovery Profile
Module 2: Developer Tool: Advanced Profiling
  • Varieties of Profiling 
  • Column and Enterprise Discovery Profiles 
  • Navigating an Enterprise Discovery Profile
  • Inference Options 
  • Join Analysis Profiling 
  • Lab: Create and navigate an Enterprise Discovery Profile 
  • Lab: Perform Join Analysis Profiling
Module 3: Developer Tool: Functional Dependency and Primary Key Inference
  • Object content and structure
  • Primary Keys
  • Functional Dependencies
  • Sensitive Data across all objects in the model 
  • Lab: Import and Profile a new set of data
  • Lab: Perform Functional Dependency and Primary Key Inference
Module 4: Developer Tool: Overlap Discovery and Foreign Key Profiling
  • Overlap Discovery between objects
  • Primary Key – Foreign Key relationships across objects
  • Verifying and Approving relationships
  • Generating DDL to create a new schema 
  • Lab: Overlap Discovery 
  • Lab: Primary Key – Foreign Key relationships

Enroll Now

Back to Course Overview

Power User Axon for Community Users (Instructor Led or onDemand) Axon Content Curation (Instructor Led) Axon for Power Users (Instructor Led) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Some more content to make this bigger asdf asdf asdf

Informatica offers programs to extend learning in convenient and economic packages. Programs include self-paced subscriptions as well as bundled instructor led training and certifications. Each program is curated around a specific skillset to enable customer success.

365University Data Governance Annual Subscription

Informatica MasterPass Education Subscription

Informatica Learning Library

Data Governance & Privacy Journey Master

View Full Course Offerings