View all jobs
Informatica DQ/DG Developer
Remote, NAResponsibilities
• Ability to code IDQ mapplets, workflows, and rules for deploying data quality validation checks and
bring up scorecards
• Provide expertise in all aspects of data quality, including profiling, validation, standardization, error
handling, and data cleansing using IDQ
• Prepare DQ Scorecard for data validation across chosen dimensions of DQ
• Profile source data and determine all source data and metadata characteristics; Design and
execute a Data Quality Audit/Assessment.
• Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise
prepare the project data
• Create/Manage configurations in the IICS Metadata command center to scan all source/target
applications to build a data catalog and lineage
• Verify data catalog, lineage, and other attributes of enterprise data sets
• Identify key gaps in the catalog/ lineage and take action to configure the missing sources and
datasets
• Develop, and implement functions, stored procedures, and ETL jobs using IICS
• Analyze and provide data metrics to management to help prioritize areas for data quality
improvement
• Good concept of integration between different source systems and target systems
• Review code developed by other Developers and provide input to and drive programming standards
• DQ metrics and dashboard development, and deployment
• Remediation workflow creation, testing, and deployment
• Configure MDM entities, schema, systems, and trust settings in HUB
• Create/update match and merge rules for different business groups/organizations
• Integrate the MDM solution with other enterprise systems
• Develop custom scripts in Python to support data processing and analysis
• Troubleshoot and debug issues related to MDM, data pipelines, workflows, and ETL processes
• Provide support for MDM Data Model and C360 Implementation to customers' business and cross-
functional partners
• Assist in deploying mappings that will run in a scheduled, batch, or real-time environment
• Liaise with business data stewards to develop quality rules and controls through profiling;
participate in the identification and remediation of data quality issues in the functions
Qualifications
• Minimum six (6) years overall current and hands-on development experience with IICS, Informatica
Data Quality (IDQ) and Data Governance/catalog
• Experience in using IICS Data quality modules
• Experience with IICS DGC and Meta Data command center modules
• Strong experience in governance operating model setup, workflows, data stewardship, MDM
concepts, and data quality processes & framework
• Self-starter that takes initiative to fill in gaps where needed
• Minimum five (5) years of current and hands-on experience with complex SQL and high-volume
Relational databases and SQL Query performance tuning
• ETL Development experience with IICS and Master Data Management
• Experience in AGILE-based project development
• Strong decision-making and problem-solving skills and experience with project delivery
• Ability to work independently on multiple projects with other developers in technology delivery
• Hands-on experience in configuring Customer 360 in Informatica MDM Hub, IDD, e360
Provisioning UI
• Ability to code IDQ mapplets, workflows, and rules for deploying data quality validation checks and
bring up scorecards
• Provide expertise in all aspects of data quality, including profiling, validation, standardization, error
handling, and data cleansing using IDQ
• Prepare DQ Scorecard for data validation across chosen dimensions of DQ
• Profile source data and determine all source data and metadata characteristics; Design and
execute a Data Quality Audit/Assessment.
• Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise
prepare the project data
• Create/Manage configurations in the IICS Metadata command center to scan all source/target
applications to build a data catalog and lineage
• Verify data catalog, lineage, and other attributes of enterprise data sets
• Identify key gaps in the catalog/ lineage and take action to configure the missing sources and
datasets
• Develop, and implement functions, stored procedures, and ETL jobs using IICS
• Analyze and provide data metrics to management to help prioritize areas for data quality
improvement
• Good concept of integration between different source systems and target systems
• Review code developed by other Developers and provide input to and drive programming standards
• DQ metrics and dashboard development, and deployment
• Remediation workflow creation, testing, and deployment
• Configure MDM entities, schema, systems, and trust settings in HUB
• Create/update match and merge rules for different business groups/organizations
• Integrate the MDM solution with other enterprise systems
• Develop custom scripts in Python to support data processing and analysis
• Troubleshoot and debug issues related to MDM, data pipelines, workflows, and ETL processes
• Provide support for MDM Data Model and C360 Implementation to customers' business and cross-
functional partners
• Assist in deploying mappings that will run in a scheduled, batch, or real-time environment
• Liaise with business data stewards to develop quality rules and controls through profiling;
participate in the identification and remediation of data quality issues in the functions
Qualifications
• Minimum six (6) years overall current and hands-on development experience with IICS, Informatica
Data Quality (IDQ) and Data Governance/catalog
• Experience in using IICS Data quality modules
• Experience with IICS DGC and Meta Data command center modules
• Strong experience in governance operating model setup, workflows, data stewardship, MDM
concepts, and data quality processes & framework
• Self-starter that takes initiative to fill in gaps where needed
• Minimum five (5) years of current and hands-on experience with complex SQL and high-volume
Relational databases and SQL Query performance tuning
• ETL Development experience with IICS and Master Data Management
• Experience in AGILE-based project development
• Strong decision-making and problem-solving skills and experience with project delivery
• Ability to work independently on multiple projects with other developers in technology delivery
• Hands-on experience in configuring Customer 360 in Informatica MDM Hub, IDD, e360
Provisioning UI