Data Quality 10 Developer, Professional Certification

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

Untitled Document
View Skill Set Inventory

Data Quality 10 Developer, Professional Certification 

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.

Enroll Now

 

    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 Overview 10%
Analyst Collaboration 10%
Profiling 15%
Standardization/Mapplets 10%
Address Validation 5%
Matching 10%
Consolidation and the DQA 10%
Integration with PowerCenter 5%
Object Import and Export 5%
DQ for Excel 5%
Parameters 5%
Content 10%

 

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. X None
B. X One
C. X Multiple, but only if you have been granted the Sources and Target privilege
D. Correct Multiple
Workflow recovery(introduced in version 9.5.1 HF1) property can be set in ___.
A. Correct Address reference data, identity population, and accelerator demonstration data
B. X Dictionaries only
C. X Address Validator Transformation and Address subscription data
D. X Pre-built Mappings, Demo Mappings, Dictionaries, Address Validator, Address subscription data
In IDQ scorecard results are stored in the Profile Warehouse
A. Correct True
B. X False
Which of the following is FALSE with regard to import/export functionality?
A. X Advanced Import Wizard allows users to perform fine grain conflict resolution.
B. X When using the Basic Method users must import entire Projects with a generic conflict resolution.
C. X When exporting, the user identifies a set of objects within a project, and all the objects plus their dependencies are exported to XML.
D. Correct When 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. X Number of Columns in the file
B. X Number of Rows in the source data
C. X Amount of memory and speed of the processor on the servers
D. Correct All 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

For more information on Informatica Certifications visit https://www.informatica.com/services-and-training/certification.html

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


Enroll Now


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 Overview 10%
Analyst Collaboration 10%
Profiling 10%
Standardization/Mapplets 20%
Matching 15%
Consolidation and the DQA 15%
Object Import and Export 5%
DQ for Excel 5%
Parameters 5%
Content 5%

 

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. X None
B. X One
C. X Multiple, but only if you have been granted the Sources and Target privilege
D. Correct Multiple
Workflow recovery(introduced in version 9.5.1 HF1) property can be set in ___.
A. Correct Address reference data, identity population, and accelerator demonstration data
B. X Dictionaries only
C. X Address Validator Transformation and Address subscription data
D. X Pre-built Mappings, Demo Mappings, Dictionaries, Address Validator, Address subscription data
In IDQ scorecard results are stored in the Profile Warehouse
A. Correct True
B. X False

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

A. X Advanced Import Wizard allows users to perform fine grain conflict resolution.
B. X When using the Basic Method users must import entire Projects with a generic conflict resolution.
C. X When exporting, the user identifies a set of objects within a project, and all the objects plus their dependencies are exported to XML.
D. Correct When 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. X Number of Columns in the file
B. X Number of Rows in the source data
C. X Amount of memory and speed of the processor on the servers
D. Correct All of the above

Additional Certification Support and Questions

Make sure you are familiar with our certification program guidelines BEFORE registering and taking the certification exam.

These include our Test Policy, price and NDA requirement.


Enroll Now

Print Friendly and PDF