Senior Informatica MDM Engineer
Duration: : 6 month contract to hire
Interview: Virtual interview
Additional Details/Notes:, Has to have Hands on Configuration with MDM. Informatica experience is a nice to have now not a need. Bachelor degree required.
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
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
