Data Quality 10 Developer, Professional Certification (2022)

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.

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:

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

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

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.

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:

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.

Sample Test Questions

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

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.