Data Quality Developer

The Data Quality Developer is responsible for designing, testing, deploying and documenting a project's data quality procedures and its outputs. The Data Quality Developer often provides the Data Integration Developer or MDM/PIM designer with all relevant outputs and results from the data quality procedures, including any on-going procedures that will run in the Operate phase or after project-end. The Data Quality Developer must provide the Business Analyst the summary results of the data quality analysis as needed during the project.

The Data Quality Developer must also document at a functional level how the procedures work within the data quality applications. The primary tasks associated with this role are to use Informatica Data Quality tools to profile the project source data, define or confirm the definition of the metadata, cleanse and validate the project data, check for duplicate or redundant records, and provide data consuming parties with concrete proposals on how to proceed with solution development.

Responsibilities

• Profile source data and determine all source data and metadata characteristics
• Design and execute a Data Quality Audit/Assessment
• Present profiling/audit results, in summary or in detail, to the business analyst, the project manager, the data steward, or business management as needs dictate
• Assist the business analyst/project manager/data steward in defining or modifying the project plan based on the results of a data quality assessment
• Assist the Data Integration Developer in designing source-to-target mappings
• On applicable projects, work with Business Intelligence, Master Data Management, or Product Information Management designers to coordinate solution design and development
• Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data for the implementation phase
• Test Data Quality mappings for accuracy and completeness
• Assist in deploying mappings that will run in a scheduled, batch, or real-time environment
• Document all mappings, mapplets, and rules in detail
• Assist in any other areas relating to the use of data quality processes, such as unit testing, or integration deployment
• Assist in identification and definition of business glossary terms as well as general business glossary management

Qualifications/Certifications

• Has knowledge of the tools and technologies used in the data quality solution
• Results oriented team player
• Possesses excellent communication skills, both written and verbal
• Must be able to work effectively with both business and technical stakeholders
• Must be able to understand and articulate the technical and business implications of data quality problems
• Familiar with current practices according to project needs:
  • Data Integration
  • Data Governance
  • Master Data Management
  • Product Information Management