Informatica Data Quality Developer

Job Title: IDQ Developer

Location: Remote

Job Description:
A data product 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

Job Type: Full-time

Salary: ₹61.00 - ₹65.00 per hour

Benefits:
• Health insurance
• Life insurance
• Paid time off

Schedule:
• Night shift

Supplemental pay types:
• Yearly bonus

Work Location: Remote