Informatica Data Quality Developer

Job Description

The Data Quality Developer is an instrumental role in the Data Quality Services organization to develop and support an enterprise data quality solution for Globalsoft. This role will support the business in the ability to analyze and assess the master data quality in transactional environments, acquisitions and the real-time Customer Hub MDM solution. This will be key in helping to support the Data Governance Council with actionable information to improve the quality and value of information assets.Principal Duties and Responsibilities:IDQ DevelopmentThe Informatica Data Quality Developer (DQ Developer) is responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs. Throughout each project phase, the DQ Developer provides relevant outputs and results from the data quality procedures, including any ongoing procedures that will run after project end. The DQ Developer must also document at a functional level how the procedures work within the data quality applications. Perform Upgrades when necessary Perform data load and mappings from source systems as the scope of quality information increase across the enterprise. Responsible for standards when creating mapplets and code migration from development through test. Ensure oversight and access management for the IDQ Repository. Maintain and support the Address Doctor Real Time connector with the MDM Hub environment. Maintain data matching logic and Address Doctor dictionaries. Support all request for new API Connections.Business rules ManagementThe DQ Developer must partner with Enterprise Information Quality & Governance Office and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data. The DQ Developer must also document at a functional level how the procedures work within the data quality applications. Develop and implement additional data quality monitoring based on requirements gathered from business units. Maintain the business playbook which lists all re-useable business rule assets. Provide Data Quality Scorecards, Dash-Boards and Ad-Hoc reporting. Providing recommendations for modification or creation of business rules based on data results Implement on-going monitoring jobs via Control-M Aptitude to understand business challenges and offer advice on how to solve them with DQ Data Quality as a Service. Develop and implement additional data quality monitoring based on requirements gathered from business units. Managing and prioritizing a request queue for new data quality monitoring requests over new data elements, new data quality rules, and maintenance to existing rules. Provide a high level of data quality awareness within the Data Service Delivery Unit assigned. Provide reports for data matching consult on pattern analysis and provide insight to data quality errors. Support data cleansing activities and spreadsheets which can be utilized for Winshuttle load scripts. Should have understanding on Data Quality Assessment approaches.SkillsDetailed understanding of Informatica Power Center 9.5 Components and Informatica Developer Components. Knowledge of Informatica Data Quality standards, guidelines and best practices. 3+ years experience in defining and deploying data quality programs and tools on enterprise data quality projects. Experience in data profiling & data quality rules development using Informatica Data Quality tools. 3+ years of data analyst experience performing data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases, etc. Experience with Address Doctor is required. Proven experience translating business problems into actionable data quality initiatives. Familiarity with current trends in Data Quality technologies. Good knowledge on Informatica Data Services (IDS) Informatica Analyst and Informatica Developer. Experience developing web services-based applications with SOA. Data mapping experience mapping data sources to and from multiple applications. The Informatica Data Quality Developer (DQ Developer) is responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs. Throughout each project phase, the DQ Developer provides relevant outputs and results from the data quality procedures, including any ongoing procedures that will run after project end. The DQ Developer must also document at a functional level how the procedures work within the data quality applications. Perform Upgrades when necessary Perform data load and mappings from source systems as the scope of quality information increase across the enterprise. Responsible for standards when creating mapplets and code migration from development through test. Ensure oversight and access management for the IDQ Repository. Maintain and support the Address Doctor Real Time connector with the MDM Hub environment. Maintain data matching logic and Address Doctor dictionaries. Support all request for new API Connections. Need to have good knowledge on different dataquality transformations like Parser, KeyGenerator, Match, RestWebService Consumer transformation, WebService Consumer transformation, Human Task etc. Need to have good knowledge on Monitor tool and Analyst tool for creating profiles, score Cards, Data Steward records handling processed by human task (Exceptional handling). Need to have good knowledge on Creating Workflows in IDQ and able to deploy in Application and monitoring, debugging workflows.Able to Migrate IDQ mappings from IDQ to Power Center. Good to have understanding on Data Quality Assessment approaches. Performance tuninin in IDQ Data Quality as a Service Develop and implement additional data quality monitoring based on requirements gathered from business units. Managing and prioritizing a request queue for new data quality monitoring requests over new data elements, new data quality rules, and maintenance to existing rules. Provide a high level of data quality awareness within the Data Service Delivery Unit assigned. Provide reports for data matching consult on pattern analysis and provide insight to data quality errors. Support data cleansing activities and spreadsheets which can be utilized for Winshuttle load scripts.Personal attributes: Highly detail oriented, accurate, and organized Ability to perform comfortably in a fast-paced, deadline oriented work environment Strong oral and written communication skills Must be flexible and comfortable with change Applicant will be a self-starter with a strong desire to grow both technically and in their knowledge of operational business.Location This role will be based in Bangalore.,

Keyskills :
informatica power centeruse casetest casesmaster datadata qualitydata mappingmusic makingdata analysisdata servicesbusiness rulesdata cleansingdata profiling