Informatica Data Quality (IDQ) Lead

  • Capgemini,
  • Jersey City, NJ
company banner
Informatica Data Quality (IDQ) Lead
Full Time, Full Time
Depends On Experience
Telecommuting not available Travel not required

Job Description

About Capgemini

 With more than 193,000 people in over 44 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2016 global revenues of EUR 12.539 billion. Together with its clients, Capgemini creates and delivers business and technology solutions that fit their needs and drive the results they want. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model. Learn more about us at http://www.capgemini.comRightshore ® is a trademark belonging to Capgemini 

Informatica Data Quality (IDQ) Lead 

Jersey City NJ 

Duties & Responsibilities: 

10 or more years of IT development/programming/coding professional work experience with a minimum of 7 years of hands-on experience with Informatica Data Quality (IDQ) toolset

•        Proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling

•        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

•        Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.

•        Document all mappings, mapplets, and rules in detail and hand over documentation to the customer

•        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”, “Informatica Power Exchange”, “Informatica Metadata Manager”, 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

•        Build human task workflow scenarios and IDQ scorecards to support data remediation•         Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools

•        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

•        Good knowledge on writing shell-scripts to invoke mappings or workflows

•        Proficient at writing SQL queries and verifying the results

•        Should be familiar in migrating objects from IDQ to PowerCenter or other Informatica tools

•        Should be familiar in deploying and validating objects to different environments

•        Good at writing test scenarios, performing unit testing, and verifying the end results with business requirements

•        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)

•        Good understanding of data governance principals

•        Strong experience on data quality development process, issue management, and data remediation

•        Experience and understanding with unit testing, release procedures, coding design and documentation protocol as well as change management procedures

•        Experience with at least one end to end Master Data Management implementation is required

•        Experience mentoring / or leading other development staff

•        Proven leadership abilities including effective knowledge sharing, conflict resolution, facilitation of open discussions, fairness and displaying appropriate levels of assertiveness

Company Information

Global leader in consulting, technology, outsourcing, and local professional services. Capgemini is headquartered in Paris, France and operates in over 40 countries. We are, above all, a people company — 180,000 people worldwide. Read more:
Dice Id : KANBAY
Position Id : 231860

Similar Positions at Capgemini

Informatica/Business Objects Admin
  • Columbus, OH
  • 3 weeks ago
Informatica MDM Specialist
  • Charlotte, NC
  • 4 days ago
Informatica Lead (Salesforce is Must)
  • Jeffersonville, IN
  • 19 hours ago
Informatica lead
  • Woodland Hills, CA
  • 19 hours ago
Lead Master Data Management
  • Fort Wayne, IN
  • 4 days ago