Data Quality 10 Developer, Professional Certification (2022)

Untitled DocumentView Skill Set Inventory

Certification Overview

This test measures your competency as a member of a project implementation team. This involves an in-depth knowledge of Data Quality processes such as Profiling, Standardization, Matching, and Consolidation. You must select and configure the appropriate Data Quality transformations and build, debug and execute Data Quality mappings including integrating those mappings into Power Center if needed

When you are ready to test and become an Informatica Certified Professional (ICP), please follow these steps :

  1. Click Enroll and log in to your Informatica account.
  2. Click Add to Cart and complete your registration/purchase.
  3. Once you have registered go to My Training and View Your Transcript.
  4. Now you can simply Launch and take your test Anytime/Anywhere prior to your test’s expiry date.

The below can be used as a guide to preparing before taking the test. Included is an outline of the technical topics and subject areas that are covered in the test, test domain weighting, test objectives and topical content.

Data Quality 10 Developer, Professional Certification (1)

Target Audience

  • Students seeking certification as a Data Quality DeveloperCertified Professional

Prerequisites

The skills and knowledge areas measured by this test are focused on product core functionality inside the realm of a standard project implementation. Training materials, supporting documentation and practical experience may become sources of question development.

The suggested training prerequisites for this certification level are the completion of the following Informatica course(s):

  • Data Quality: Data Quality Management for Developers (onDemand OR Instructor Led)
  • Data Quality: Advanced Techniques (onDemand OR Instructor Led)
  • Informatica Analyst (onDemand)

Test takers will be measured on:

  • Navigation through the Developer Tool
  • Project Collaboration techniques such as Tags and Comments,
  • Using Profiles and reference tables to share information with Analysts
  • Profiling methods to identify data irregularities and inaccuracies.
  • Converting a profile into a mapping
  • Using mappings and mapplets to cleanse and standardize data
  • Performing Address Validation
  • Identifying duplicate records
  • Automat and manual consolidation of e duplicate records into a master record
  • Executing mappings in PowerCenter
  • Deploying Data Quality Mappings in an Excel spreadsheet (connect to Web Services)

Test Domains

The test domains and the extent to which they are represented as an estimated percentage of the test follows:

Title

% of Test

Informatica Overview10%
Analyst Collaboration10%
Profiling15%
Standardization/Mapplets10%
Address Validation5%
Matching10%
Consolidation and the DQA10%
Integration with PowerCenter5%
Object Import and Export5%
DQ for Excel5%
Parameters5%
Content10%

Question Format

You may select from one or more response offerings to answer a question.

You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.

A passing grade of 70% is needed to achieve recognition as an Informatica Data Quality 10 Developer CertifiedProfessional.

You are given 90 minutes to complete the test. Formats used in this test are:

  • Multiple Choice: Select one option that best answers the question or completes the statement
  • Multiple Response: Select all that apply to best answer the question or complete the statement
  • True/False: After reading the statement or questions select the best answer

Test Policy

  • You are eligible for one attempt and re-take, if needed, per test registration.
  • If you do not pass on your first attempt:
    • The purchase of the test will include one second-attempt if a student does not pass a test.
    • You must wait two weeks after a failed test to take the test again.
    • Any additional retakes are charged the current fee at the time of purchase.
    • Promotions are excluded and cannot be combined.

Test Topics

The test will contain 70 questions comprised of topics that span across the sections listed below. In order to ensure that you are prepared for the test, review the subtopics with each section.

Informatica Overview

  • Describe the Informatica 10 architecture and set up including the repositories required for installation
  • Provide information on the Data Quality process and dimensions of data quality

Analyst Collaboration

  • Use and describe the functionality of the Analyst Tool including Scorecarding, Reference Table Management, Tags, Filters, Profiles and Comments
  • Describe how Analysts and Developers can collaborate on projects
  • Describe the benefits of project collaboration to a team


Profiling

  • Perform and interpret column, rule, comparative and mid-stream profiling

Standardization/Mapplets

  • Be aware of where data standardization fits in the DQ process
  • Apply, configure and troubleshoot data standardization transformations
  • Differentiate between the various parsing techniques available
  • Recognize how reference tables are used in the standardization process

Address Validation

  • Verify the importance of Address Validation
  • Configure the Address Validation transformation including explaining each mode that is available and what custom templates can be used for
  • Interpret the AV outputs generated

Matching

  • Develop and build match plans to identify duplicate or related data
  • Differentiate between the matching algorithms available and explain how matching scores are
  • Configure Identity Matching option for the match transformation
  • Explain populations, the identity match strategies that are available and how they are used in Identity Matching

Consolidation and the DQA

  • Explain Automatic and Manual consolidation techniques and configure the Transformations used for automatic consolidation
  • Use the Exception Transformation to generate and populate the Bad Records and Duplicate Records tables
  • Troubleshoot any problems that may occur
  • Generate a survivor record in the DQA
  • Remove duplicates using DQA

Integration with Power Center

  • Explain how to integrate IDQ mappings and mapplets into PowerCenter Workflows including how content is handled

Object Import and Export

  • Define the difference between the Basic and Advanced Import options available
  • Explain Dependency conflict resolution and how it is handled
  • Describe how to Export a Project

DQ for Excel

  • Describe the requirements for integration for Excel
  • Define the techniques for creating mappings for DQ for Excel
  • Explain the Web service capabilities required for DQ for Excel
  • Provide an explanation on how to use the Informatica ribbon in Excel

Parameters

  • Explain what parameters are and why they are used including what parameter functions are supported
  • Identify which Transformations can use parameters
  • Describe the process of exporting mappings with parameters built in

Content

  • Explain what Content is, what is contained in the Core Accelerator and why it is used in the Core Accelerator and why it is used

Sample Test Questions

How are the Identity Match populations installed for Data Quality?
A.XNone
B.XOne
C.XMultiple, but only if you have been granted the Sources and Target privilege
D.CorrectMultiple
Workflow recovery(introduced in version 9.5.1 HF1) property can be set in ___.
A.CorrectAddress reference data, identity population, and accelerator demonstration data
B.XDictionaries only
C.XAddress Validator Transformation and Address subscription data
D.XPre-built Mappings, Demo Mappings, Dictionaries, Address Validator, Address subscription data
In IDQ scorecard results are stored in the Profile Warehouse
A.CorrectTrue
B.XFalse
Which of the following is FALSE with regard to import/export functionality?
A.XAdvanced Import Wizard allows users to perform fine grain conflict resolution.
B.XWhen using the Basic Method users must import entire Projects with a generic conflict resolution.
C.XWhen exporting, the user identifies a set of objects within a project, and all the objects plus their dependencies are exported to XML.
D.CorrectWhen doing a Basic import the only conflict resolution available is Add Object to Target or Replace Object in Target
Which of the following will impact the total amount of time it takes to execute a column profiling process?
A.XNumber of Columns in the file
B.XNumber of Rows in the source data
C.XAmount of memory and speed of the processor on the servers
D.CorrectAll of the above

Additional Information

Retake Policy: Current purchases of the test will include one second-attempt if a student does not pass a test. Any additional retakes are charged the current fee at the time of purchase. Promotions are excluded and cannot be combined. You must wait two weeks after a failed test to take the test again.

Informatica University has a community page so students can assist one another in their test preparation within the Informatica Network:https://network.informatica.com/welcome

Formore information on Informatica Certifications visithttps://www.informatica.com/services-and-training/certification.html

To find the class that is right for you, fill out the format the top of this page, or visit our website athttp://www.informatica.com/us/services-and-training/training/. For onsite class information contact your local Education Sales Specialist.

Data Quality 10 Developer, Professional Certification (2)

Back to Certification Overview

QUESTIONS?

Certification Exam | Data Quality | Version 10 | Skill Set Inventory

Test takers will be measured on:

  • Navigation through the Developer Tool
  • Project Collaboration techniques such as Tags and Comments,
  • Using Profiles and reference tables to share information with Analysts
  • Profiling methods to identify data irregularities and inaccuracies.
  • Converting a profile into a mapping
  • Using mappings and mapplets to cleanse and standardize data
  • Performing Address Validation
  • Identifying duplicate records
  • Automat and manual consolidation of e duplicate records into a master record
  • Executing mappings in PowerCenter
  • Deploying Data Quality Mappings in an Excel spreadsheet (connect to Web Services)

Test Domains

The test domains and the extent to which they are represented as an estimated percentage of the test follows:

Title

% of Test

Informatica Overview10%
Analyst Collaboration10%
Profiling10%
Standardization/Mapplets20%
Matching15%
Consolidation and the DQA15%
Object Import and Export5%
DQ for Excel5%
Parameters5%
Content5%

Question Format

You may select from one or more response offerings to answer a question.

You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.

A passing grade of 70% is needed to achieve recognition as an Informatica Data Quality 10 Developer Certified Professional.

You are given 90 minutes to complete the test. Formats used in this test are:

  • Multiple Choice: Select one option that best answers the question or completes the statement
  • Multiple Response: Select all that apply to best answer the question or complete the statement
  • True/False: After reading the statement or questions select the best answer

Test Policy

  • You are eligible for one attempt and re-take, if needed, per test registration.
  • If you do not pass on your first attempt:
    • The purchase of the test will include one second-attempt if a student does not pass a test.
    • You must wait two weeks after a failed test to take the test again.
    • Any additional retakes are charged the current fee at the time of purchase.
    • Promotions are excluded and cannot be combined.

Test Topics

The test will contain 70 questions comprised of topics that span across the sections listed below. In order to ensure that you are prepared for the test, review the subtopics with each section.

Informatica Overview

  • Describe the Informatica 10 architecture and set up including the repositories required for installation
  • Provide information on the Data Quality process and dimensions of data quality

Analyst Collaboration

  • Use and describe the functionality of the Analyst Tool including Scorecarding, Reference Table Management, Tags, Filters, Profiles and Comments
  • Describe how Analysts and Developers can collaborate on projects
  • Describe the benefits of project collaboration to a team


Profiling

  • Perform and interpret column, rule, comparative and mid-stream profiling

Standardization/Mapplets

  • Be aware of where data standardization fits in the DQ process
  • Apply, configure and troubleshoot data standardization transformations
  • Differentiate between the various parsing techniques available
  • Recognize how reference tables are used in the standardization process

Address Validation

  • Verify the importance of Address Validation
  • Configure the Address Validation transformation including explaining each mode that is available and what custom templates can be used for
  • Interpret the AV outputs generated

Matching

  • Develop and build match plans to identify duplicate or related data
  • Differentiate between the matching algorithms available and explain how matching scores are
  • Configure Identity Matching option for the match transformation
  • Explain populations, the identity match strategies that are available and how they are used in Identity Matching

Consolidation and the DQA

  • Explain Automatic and Manual consolidation techniques and configure the Transformations used for automatic consolidation
  • Use the Exception Transformation to generate and populate the Bad Records and Duplicate Records tables
  • Troubleshoot any problems that may occur
  • Generate a survivor record in the DQA
  • Remove duplicates using DQA

Integration with Power Center

  • Explain how to integrate IDQ mappings and mapplets into PowerCenter Workflows including how content is handled

Object Import and Export

  • Define the difference between the Basic and Advanced Import options available
  • Explain Dependency conflict resolution and how it is handled
  • Describe how to Export a Project

DQ for Excel

  • Describe the requirements for integration for Excel
  • Define the techniques for creating mappings for DQ for Excel
  • Explain the Web service capabilities required for DQ for Excel
  • Provide an explanation on how to use the Informatica ribbon in Excel

Parameters

  • Explain what parameters are and why they are used including what parameter functions are supported
  • Identify which Transformations can use parameters
  • Describe the process of exporting mappings with parameters built in

Content

  • Explain what Content is, what is contained in the Core Accelerator and why it is used in the Core Accelerator and why it is used

Sample Test Questions

How are the Identity Match populations installed for Data Quality?
A.XNone
B.XOne
C.XMultiple, but only if you have been granted the Sources and Target privilege
D.CorrectMultiple
Workflow recovery(introduced in version 9.5.1 HF1) property can be set in ___.
A.CorrectAddress reference data, identity population, and accelerator demonstration data
B.XDictionaries only
C.XAddress Validator Transformation and Address subscription data
D.XPre-built Mappings, Demo Mappings, Dictionaries, Address Validator, Address subscription data
In IDQ scorecard results are stored in the Profile Warehouse
A.CorrectTrue
B.XFalse

Which of the following is FALSE with regard to import/export functionality?

A.XAdvanced Import Wizard allows users to perform fine grain conflict resolution.
B.XWhen using the Basic Method users must import entire Projects with a generic conflict resolution.
C.XWhen exporting, the user identifies a set of objects within a project, and all the objects plus their dependencies are exported to XML.
D.CorrectWhen doing a Basic import the only conflict resolution available is Add Object to Target or Replace Object in Target
Which of the following will impact the total amount of time it takes to execute a column profiling process?
A.XNumber of Columns in the file
B.XNumber of Rows in the source data
C.XAmount of memory and speed of the processor on the servers
D.CorrectAll of the above

Additional Information

Retake Policy: Current purchases of the test will include one second-attempt if a student does not pass a test. Any additional retakes are charged the current fee at the time of purchase. Promotions are excluded and cannot be combined. You must wait two weeks after a failed test to take the test again.

Informatica University has a community page so students can assist one another in their test preparation within the Informatica Network:https://network.informatica.com/welcome

Formore information on Informatica Certifications visithttps://www.informatica.com/services-and-training/certification.html

To find the class that is right for you, fill out the format the top of this page, or visit our website athttp://www.informatica.com/us/services-and-training/training/. For onsite class information contact your local Education Sales Specialist.

Data Quality 10 Developer, Professional Certification (3)

You might also like

Latest Posts

Article information

Author: Trent Wehner

Last Updated: 06/08/2022

Views: 5817

Rating: 4.6 / 5 (56 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Trent Wehner

Birthday: 1993-03-14

Address: 872 Kevin Squares, New Codyville, AK 01785-0416

Phone: +18698800304764

Job: Senior Farming Developer

Hobby: Paintball, Calligraphy, Hunting, Flying disc, Lapidary, Rafting, Inline skating

Introduction: My name is Trent Wehner, I am a talented, brainy, zealous, light, funny, gleaming, attractive person who loves writing and wants to share my knowledge and understanding with you.