MDM IDQ Developer

Cloud Analytics Technologies, LLC; Dallas (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading cloud analytics firm in Texas, Dallas is seeking an experienced Informatica Developer. The role involves translating functional requirements into technical specifications, managing data loading and quality processes, and utilizing tools for data profiling and transformation. Strong experience with Informatica Developer, IDQ, MDM, and proficiency in shell scripting and SQL are essential. This position also entails documenting technical processes and communicating effectively with stakeholders.

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.

Responsibilities

• Translate functional requirements into technical specifications and develop code.
• Profile source data and analyze data characteristics.
• Design and execute mappings for data cleansing and transformation.
• Implement data loading and quality processes efficiently.
• Document mappings and deliver documentation to stakeholders.

Skills

Informatica Developer

ETL Design

Data Quality Processes

Master Data Management

SQL

Shell Scripting

Data Profiling

Analytical Skills

Problem-Solving Skills

Job description

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.

Requirements for Informatica Developer

• 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.

Equal Opportunity Employer

CLOUD ANALYTICS TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract