Informatica IICS SQL MDM Developer

Role: Informatica IICS SQL MDM Developer

Location: Houston, TX

Duration: 6+ Months

Job Summary: We are seeking a highly skilled and experienced Informatica IICS SQL MDM Developer to join our team. In this role, you will be responsible for designing, developing, and maintaining data integration solutions using Informatica IICS, SQL databases, and Master Data Management principles. You will collaborate with cross-functional teams to ensure data quality, consistency, and accuracy across the organization.

Key Responsibilities:

· Data Integration Development: Develop and maintain data integration solutions using Informatica Intelligent Cloud Services (IICS) to extract, transform, and load (ETL) data from various source systems into SQL databases.

· Master Data Management (MDM): Implement and manage Master Data Management processes and systems to ensure data consistency and accuracy. Create and maintain master data models and mappings.

· SQL Database Management: Design, optimize, and maintain SQL databases, including writing complex SQL queries, stored procedures, and triggers for data transformation and retrieval.

· Data Quality Assurance: Monitor and improve data quality by implementing data cleansing, validation, and enrichment processes. Develop data quality rules and perform data profiling.

· Performance Optimization: Optimize ETL processes and SQL queries for maximum efficiency and performance. Identify and resolve performance bottlenecks.

· Collaboration: Collaborate with business analysts, data architects, and other stakeholders to understand data requirements and ensure data solutions align with business objectives.

· Documentation: Create and maintain technical documentation, including data mappings, ETL workflows, and data dictionaries.

· Data Security: Implement data security measures to protect sensitive information and ensure compliance with data privacy regulations.

· Troubleshooting: Investigate and resolve data integration and data quality issues in a timely manner. Provide support for production data-related incidents.

Qualifications:

· Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree is a plus.

· Proven experience in Informatica IICS development, SQL database management, and Master Data Management (MDM).

· Strong SQL programming skills and experience with relational databases (e.g., Oracle, SQL Server, MySQL).

· Proficiency in data modeling and ETL concepts.

· Familiarity with data quality tools and methodologies.

· Excellent problem-solving and troubleshooting skills.

· Strong communication and teamwork abilities.

· Knowledge of data privacy and compliance regulations (e.g., GDPR, HIPAA) is a plus.

· Relevant certifications in Informatica and MDM are advantageous.