Senior Informatica MDM Engineer

Gravity IT Resources; Miramar Beach (FL); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Gravity IT Resources is seeking a Senior Informatica MDM Engineer to design and implement the Party Model within Informatica SAS MDM. The role covers data modeling, data integration from multiple sources via IDMC, and building robust data quality rules.

The ideal candidate has extensive MDM development experience, familiarity with Reference 360, and strong scripting and SQL skills for data transformations and loading operations.

Qualifications

• 4+ years of MDM development focused on Informatica MDM and Party Model implementation.

Responsibilities

• Configure and customize Informatica SAS MDM for Party Model implementation
• Define and maintain data models for party-related entities
• Integrate data from various sources using IDMC
• Implement match and merge rules for duplicate resolution
• Configure address verification and data quality rules
• Develop data quality management rules and workflows
• Build UNIX shell scripts for automation
• Work with SFTP/SSH, SQL, PL/SQL, and SQL*Loader for data transfer and loading

Skills

Informatica MDM

MDM development

Party Model

Data modeling

Data profiling

Data cleansing

SQL/PLSQL

IDMC

Scripting (Unix)

Data quality

Communication skills

Agile (Scrum/Kanban)

Education

Bachelor's Degree in Computer Science / Information Systems / Engineering / Business

Tools

IDMC

Reference 360

CDI

CAI

CDQ

SQL*Loader

Job description

Job Title: Senior Informatica MDM Engineer

Location Requirements: Hybrid - onsite in the US with remote flexibility

Job Type: Contract To Hire

Role Overview:
You will configure and customize Informatica SAS MDM to implement the Party Model, defining entity types, relationships, business rules, match and merge strategies, and user interfaces. Work with data architects and stakeholders to design and maintain the data model for party-related entities, ensuring data accuracy and consistency. Integrate data from multiple sources through IDMC, perform data profiling, cleansing, and transformation. Implement match and merge rules to identify and consolidate duplicate records. Configure address verification, define data quality rules, and monitor data quality. Optimize performance within the system, conduct testing, and maintain technical documentation. Automate jobs using UNIX shell scripting and handle data transfer with SFTP/SSH, SQL, PL/SQL, and SQL *Loader.

Responsibilities:

• Configure and customize Informatica SAS MDM for Party Model implementation
• Define and maintain data models for party-related entities
• Integrate data from various sources using IDMC, with profiling, cleansing, and transformation
• Implement match and merge rules for duplicate record resolution
• Configure address verification engines and email and phone validation
• Develop data quality management rules and workflows
• Work with Reference 360 and its usage within the MDM domain
• Optimize system performance for data loading, matching, and retrieval
• Conduct unit testing and integration testing of MDM configurations
• Maintain comprehensive technical documentation including design specs, guides, and troubleshooting manuals
• Build UNIX shell scripts for automation of job scheduling, backup, and other tasks
• Work with SFTP/SSH, SQL, PL/SQL, and SQL *Loader for data transfer and loading

Required Qualifications:

• 4+ years of experience in MDM development focused on Informatica MDM and Party Model implementation
• Hands-on experience implementing Informatica's SAS MDM application
• Experience working with Reference 360 and its usage within the MDM domain
• Experience with CAI, CDI, and CDQ
• In-depth knowledge of Informatica's SAS MDM tools, including IDMC, and their functionalities for party entities
• Strong understanding of data modeling principles and data integration techniques
• Knowledge of data quality management and data governance practices within an MDM environment
• Proficiency in data profiling, cleansing, and transformation processes
• Excellent problem-solving and analytical skills
• Strong communication and collaboration skills
• Knowledge of technology and software development processes
• Good presentation development and delivery skills
• Familiarity with Agile methodologies (e.g., Scrum, Kanban)
• Experience in the travel and hospitality industry is a plus
• Bachelor's Degree from an accredited college or university in Computer Science, Information Systems, Engineering, Business, or related field

Equal Employment Opportunity Statement
Gravity IT Resources is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other legally protected characteristic. All employment decisions are based on qualifications, merit, and business needs.