Informatica IDQ & PIM Developer

IDQ & PIM Developer
A dataops comprises of team members with various skills, competencies, domain understandings, and
process knowledge to build and support end to end life cycle of any Data Product.
This require technical competencies or process skills that are specific to technology and domain being
used, and some of these skills are core and will be applicable and relevant irrespective of the tool or
application being used. E.g. Data Quality(DQ). A developer within data product would understand the
concept of Data quality and would be able to identify DQ issues and suggests a mechanism to measure
and resolve those. Similarly, if you consider Match process, modeling, etc. a very common functionality,
a developer in data product team should be well versed in process.
Applications:
Informatica Product Suites: Informatica Data Quality (Cloud and On-Prem) used for building data
quality mappings/routines that helps in data cleansing and data standardization in most efficient
manner.
o Development efficient & highly tuned data cleansing routines
o Should be able to use all IDQ transformations including Address Doctors
o Understands IDQ architecture and performance techniques with industry standard
coding practices
o Should be able to works with exposing data quality rules as webservices and consumed
data from third party rest APIs
o Should be able to work with managed and unmanaged reference table
o Understands the code deployment & knows to automate it
o Informatica Analyst Used by Business/ Data analyst & data stewards to profile data,
define rule specification and manage business glossary
o Build profile on heterogenous data sources Basic profiling, join data profiling
o Build scorecards
o Build reference tables
o Build mapping and rule specifications
o Build and manage Reference data though reference tables
o Able to build and manage business glossary
o Informatica Data Management Cloud Data Integration and Cloud Application Integration
services are used for data integration and ETL flows and this helps our program with
large scale integration projects with minimum infrastructure
o Develop efficient & highly tuned data transformation mappings
o Deploy and manage the secure agents
o Utilize parametrization features in CDI/CAI
o Build, execute/schedule mapping tasks and task flows
o Performance tuning through lookup and other coding best practices
o Knows SCD Types and its implementation in CDI/CAI
o Rest API consumptions
o Informatica Reference 360 Informatica s SaaS based product for reference data
management
o Build and implement code list
o Build and implement cross walks
o Access management on reference data
o Ingest and export data in and out of Reference -360
Informatica MDM Resource Kit
o Informatica Command Line Utilities
o Informatica OOB API
o Informatica Address Doctor
o Apigee/Mulesoft/etc
Informatica platform administration
Informatica Patching/Upgrade utilities
Process Scheduling Application: Rundeck / Control-M
o Build Jobs for execution of IDQ/ MDM processes
o Build Jobs for execution of Database processes
o Build Jobs for execution of Shell programs on Linux
o Build Workflow Jobs and Daily batch processes
o Setup Alerts/Notification/ Error handling Routines
o Application Start/Stop Routines
Tools/ Utilities:
o Linux Shell Scripting
o Build Shell Programs for process executions
o Application cleanup actions
o SoapUI
o Postman
o CI/CD through Informatica Dev Ops Platform
o Build Custom Operational Reports and Email Notifications
o OS Infrastructure Alerts
o Application Start/Stop routines
Documentation:
o GIT Global Information Tracker
Strong Documentation Skills
Follow change management policies
Platform
o Azure
Fundamental
Cloud computing
Databases
o Oracle
Development
Project level administration
o SQL Server, MYSQL
o Exposure to NOSQL DBs Graph / Document Databases
Functional skills
Data Modeling
o Logical / Physical Modeling
Data Integration
o Batch & Realtime Integration
o ETL
Master Data management
Data Governance
Business Definition of Data Elements
Understand Governance Rules and Policies for Master Data Entity
Data Lineage
Data Element Definition
Relationships Definition
Data Stewardship
Control Roles based Access to the master data
Implement approval / rejection process for create/Edit of master Data
Setup Business rules on Create/Edit of master data using IDD/E360 applications
Control Quality of Data as per defined Governance rules / Policies
Follow process for Manual Merges/ Unmerges
Data Quality
Match & Merge
Cross Referencing
BVT (Best Version of the Truth) and Survivorship Process
Project management skills:
Business Requirements Gathering
Logical Design / Technical Design
Estimation
Team management (For Leads)
Demo/Presentations

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

IDQ & PIM Developer
A dataops comprises of team members with various skills, competencies, domain understandings, and
process knowledge to build and support end to end life cycle of any Data Product.
This require technical competencies or process skills that are specific to technology and domain being
used, and some of these skills are core and will be applicable and relevant irrespective of the tool or
application being used. E.g. Data Quality(DQ). A developer within data product would understand the
concept of Data quality and would be able to identify DQ issues and suggests a mechanism to measure
and resolve those. Similarly, if you consider Match process, modeling, etc. a very common functionality,
a developer in data product team should be well versed in process.
Applications:
Informatica Product Suites: Informatica Data Quality (Cloud and On-Prem) used for building data
quality mappings/routines that helps in data cleansing and data standardization in most efficient
manner.
o Development efficient & highly tuned data cleansing routines
o Should be able to use all IDQ transformations including Address Doctors
o Understands IDQ architecture and performance techniques with industry standard
coding practices
o Should be able to works with exposing data quality rules as webservices and consumed
data from third party rest APIs
o Should be able to work with managed and unmanaged reference table
o Understands the code deployment & knows to automate it
o Informatica Analyst Used by Business/ Data analyst & data stewards to profile data,
define rule specification and manage business glossary
o Build profile on heterogenous data sources Basic profiling, join data profiling
o Build scorecards
o Build reference tables
o Build mapping and rule specifications
o Build and manage Reference data though reference tables
o Able to build and manage business glossary
o Informatica Data Management Cloud Data Integration and Cloud Application Integration
services are used for data integration and ETL flows and this helps our program with
large scale integration projects with minimum infrastructure
o Develop efficient & highly tuned data transformation mappings
o Deploy and manage the secure agents
o Utilize parametrization features in CDI/CAI
o Build, execute/schedule mapping tasks and task flows
o Performance tuning through lookup and other coding best practices
o Knows SCD Types and its implementation in CDI/CAI
o Rest API consumptions
o Informatica Reference 360 Informatica s SaaS based product for reference data
management
o Build and implement code list
o Build and implement cross walks
o Access management on reference data
o Ingest and export data in and out of Reference -360
Informatica MDM Resource Kit
o Informatica Command Line Utilities
o Informatica OOB API
o Informatica Address Doctor
o Apigee/Mulesoft/etc
Informatica platform administration
Informatica Patching/Upgrade utilities
Process Scheduling Application: Rundeck / Control-M
o Build Jobs for execution of IDQ/ MDM processes
o Build Jobs for execution of Database processes
o Build Jobs for execution of Shell programs on Linux
o Build Workflow Jobs and Daily batch processes
o Setup Alerts/Notification/ Error handling Routines
o Application Start/Stop Routines
Tools/ Utilities:
o Linux Shell Scripting
o Build Shell Programs for process executions
o Application cleanup actions
o SoapUI
o Postman
o CI/CD through Informatica Dev Ops Platform
o Build Custom Operational Reports and Email Notifications
o OS Infrastructure Alerts
o Application Start/Stop routines
Documentation:
o GIT Global Information Tracker
Strong Documentation Skills
Follow change management policies
Platform
o Azure
Fundamental
Cloud computing
Databases
o Oracle
Development
Project level administration
o SQL Server, MYSQL
o Exposure to NOSQL DBs Graph / Document Databases
Functional skills
Data Modeling
o Logical / Physical Modeling
Data Integration
o Batch & Realtime Integration
o ETL
Master Data management
Data Governance
Business Definition of Data Elements
Understand Governance Rules and Policies for Master Data Entity
Data Lineage
Data Element Definition
Relationships Definition
Data Stewardship
Control Roles based Access to the master data
Implement approval / rejection process for create/Edit of master Data
Setup Business rules on Create/Edit of master data using IDD/E360 applications
Control Quality of Data as per defined Governance rules / Policies
Follow process for Manual Merges/ Unmerges
Data Quality
Match & Merge
Cross Referencing
BVT (Best Version of the Truth) and Survivorship Process
Project management skills:
Business Requirements Gathering
Logical Design / Technical Design
Estimation
Team management (For Leads)
Demo/Presentations

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.