Senior Informatica Data Quality Developer

Careers at Bloomberg

New York

Posted Nov 8, 2016 - Requisition No. 55555

Our Team:

Bloomberg's Master Data team is responsible for establishing data governance and improving data quality across various data domains (Customer, Vendor, Material, etc.). The goal of the team is to improve decision-making capabilities across the organization and also support transactional systems and master data processes. We are seeking an Informatica Data Quality expert to join our team to bring hands on expertise and a passion for data quality.

We’ll trust you to:

  • Lead end to end implementation of Informatica Data Quality (IDQ) suite and Data as a Service (DaaS) components which includes Global Address, Contact Verification and Business Data Enrichment
  • Implement global address verification which includes transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes
  • Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
  • Utilize “Informatica Developer” and “Informatica Analyst” to design and develop custom objects and rules, reference data tables and create/import/export mappings
  • As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools
  • Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates
  • Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
  • Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and PowerCenter
  • Serve as the primary resource to team members and data stewards for training, problem resolution, data profiling etc.
  • Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement
  • Participate in improvement of master data management process and support transactional systems and processes utilizing SAP
  • Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity
  • Maintain excellent working relationship between internal (team and the whole organization) and external parties (vendors, customers)
  • Assist with special projects or ad-hoc reviews as needed

You need to have:

  • Minimum 5 years of hands-on experience with Informatica Data Quality (IDQ) toolset and proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
  • Experience implementing Informatica Address Doctor for global address verification across a large organization
  • Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services
  • Excellent data analysis and data profiling skills using Informatica and Excel
  • Bachelor’s degree in Computer Science or Information Technology is a plus
  • Good understanding of data governance principals and strong experience on data quality development and issue management and remediation
  • Experience with at least one end to end Master Data Management implementation is required
  • Good communication and presentations skills and ability to lead meetings effectively
  • Ability to multi-task with strong attention to detail and analytical skills
  • Strong work ethic with a highly positive, hands-on, can-do attitude
Similar jobs