Informatica MDM & IDQ Developer

Artifintech; Dallas (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC is seeking an experienced Informatica Developer to translate business requirements into robust data integration solutions across multi-environment deployments.

You will design ETL processes, implement data quality controls, and enhance master data management while collaborating with stakeholders in a fast-paced setting. The role demands hands-on Informatica Developer, IDQ and MDM experience, SQL and shell scripting, and strong communication skills.

Qualifications

• Experience with Informatica Developer, IDQ and MDM.
• Strong ETL design and data quality capabilities.
• Proficiency in data profiling, cleansing, and transformation techniques.
• Shell scripting and SQL proficiency; ability to document processes clearly.

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 batch execution.
• Deploy and manage data mappings in scheduled, batch, or real-time environments.
• Document all mappings, mapplets, and rules 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 IDQ and load data into 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

SQL

Shell scripting

Data profiling

Data cleansing

Tools

Informatica PowerCenter

Informatica IDQ

Job description

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC is seeking an experienced Informatica Developer to translate business requirements into robust data integration solutions across multi-environment deployments.

You will design ETL processes, implement data quality controls, and enhance master data management while collaborating with stakeholders in a fast-paced setting. The role demands hands-on Informatica Developer, IDQ and MDM experience, SQL and shell scripting, and strong communication skills.