What are the responsibilities and job description for the Informatica MDM Integration Consultant position at Pacific Consultancy Services?
Role: MDM Integration Specialist
Work location: San Diego, CA (Hybrid)
Minimum Requirements:
- Minimum 6 years of experience in Master Data Management (MDM) applications, architecture, and implementation methodologies.
- Minimum 6 years of experience with custom built MDM framework (.Net) or Informatica MDM
- Minimum 5 years of experience with REST APIs, SOAP Web Services, OData, JSON, XML, and API security standards.
- Minimum 2 years of experience in Javascript, Python
- Minimum 5 years of experience in advanced SQL skills in Oracle, SQL Server, PostgreSQL, Snowflake
- Strong experience in designing and implementing enterprise integration solutions.
- Minimum 2 years of hands-on experience with one or more integration platforms:
- XI-ION (Preferred)
- Informatica IDMC/IICS
- Knowledge of message-oriented middleware and event-driven integrations using Kafka, Service Bus, MQ, or similar technologies.
- Experience in ETL/ELT design and development.
- Experience with Git, Azure DevOps, GitHub, or similar version control and CI/CD tools.
- Ability to work effectively in cross-functional and global teams.
- Strong analytical, problem-solving, and decision-making capabilities.
- Experience leading technical discussions, solution design workshops, and integration initiatives.
Nice to have:
- Experience working with cloud platforms such as:
- Microsoft Azure
- Amazon Web Services (AWS)
- Knowledge of cloud-native integration, API management, and data services.
- Experience in Matillion