Senior Informatica IDQ/MDM Developer

MACHINE LEARNING TECHNOLOGIES LLC; Dallas (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in Dallas, TX seeks a Senior AI Developer to design and implement data integration solutions using Informatica IDQ/MDM. You will profile data, design mappings, and deploy ETL processes across environments, ensuring data quality and accuracy for master data assets.

The role requires hands-on Informatica development, IDQ, and MDM expertise, plus SQL and shell scripting capabilities, with documentation and collaboration across stakeholders as core responsibilities.

Qualifications

• Strong experience with Informatica Developer, IDQ, and MDM.
• Proficiency in ETL design, data quality processes, and master data management.
• Solid understanding of data profiling, cleansing, and transformation techniques.
• Hands-on experience with shell scripting and SQL.
• Ability to document technical processes and communicate effectively with stakeholders.
• Familiarity with deployment and validation in multi-environment setups.
• Strong analytical and problem-solving skills.

Responsibilities

• Translate functional requirements into technical specifications and develop code and interfaces for Global Business Services.
• Profile source data and analyze all source data and metadata characteristics.
• Design and execute mappings to cleanse, de-duplicate, transform, and load master data.
• Implement and optimize data loading and quality processes, including transliteration, parsing, analysis, standardization, and enrichment for efficient batch execution.
• Deploy and manage data mappings in scheduled, batch, or real-time environments.
• Document all mappings, mapplets, and rules in detail and deliver documentation to stakeholders.
• Utilize Informatica Developer to design and develop custom objects, rules, reference data tables, and create/import/export mappings.
• Run ETL jobs for address standardization, email cleanup, name parsing, and validation using Informatica Data Quality (IDQ) and load data into Informatica MDM.
• Analyze and provide data metrics to management on data loads and data quality improvements.
• Write shell scripts to invoke mappings or workflows.
• Develop and execute SQL queries for data verification.
• Deploy and validate objects across different environments.
• Perform unit testing and verify end results against business requirements.

Skills

Informatica Developer

IDQ

MDM

ETL design

data quality

master data management

data profiling

shell scripting

SQL

documentation

stakeholder communication

multi-environment deployment

Tools

Informatica Developer

Informatica IDQ

MDM

Job description

MACHINE LEARNING TECHNOLOGIES LLC in Dallas, TX seeks a Senior AI Developer to design and implement data integration solutions using Informatica IDQ/MDM. You will profile data, design mappings, and deploy ETL processes across environments, ensuring data quality and accuracy for master data assets.

The role requires hands-on Informatica development, IDQ, and MDM expertise, plus SQL and shell scripting capabilities, with documentation and collaboration across stakeholders as core responsibilities.