JOB SUMMARY:We are seeking an experienced MDM Architect to design, implement, and govern enterprise master data solutions. The ideal candidate will have strong expertise in Informatica MDM, deep PL/SQL and database skills, and the ability to collaborate with business and technical stakeholders to deliver scalable, high-quality master data solutions. Experience with Informatica IDMC and pharmaceutical or life sciences domain knowledge is an added advantage.
Key Responsibilities:- Architect and implement enterprise-grade Master Data Management solutions using Informatica MDM.
- Define MDM data models, match/merge rules, survivorship logic, and hierarchy management strategies.
- Develop and optimize complex PL/SQL procedures and perform database performance tuning.
- Design and implement data governance frameworks including data quality and metadata management.
- Collaborate with business stakeholders to translate requirements into scalable MDM architecture.
- Lead end-to-end MDM implementation including data onboarding and golden record creation.
- Define integration patterns between MDM, source systems, and downstream applications using APIs and ETL.
- Support migration and modernization initiatives involving Informatica Intelligent Data Management Cloud (IDMC).
- Establish MDM best practices, standards, and reusable frameworks.
- Ensure data security, privacy, and regulatory compliance.
- Provide technical leadership, code reviews, and mentorship.
- Drive performance optimization, scalability, and platform stability improvements.
- Participate in client discussions and architecture reviews.
- Maintain architecture documentation and operational playbooks.
Required Skills & Experience:- Strong hands-on experience with Informatica MDM.
- Advanced proficiency in PL/SQL development and database performance optimization.
- Strong understanding of enterprise data modeling and integration patterns.
- Experience designing data governance and data quality frameworks.
- Excellent communication and stakeholder management skills.
- Ability to adapt to new technologies and evolving business environments.
Competencies:- Enterprise architecture mindset for data platforms.
- Strong analytical and problem-solving skills.
- Leadership and mentoring capability.
- Strategic thinking aligned with business objectives.
- Strong documentation and presentation skills.
- Understanding of regulatory and compliance-driven environments.
Preferred Skills:- Experience with Informatica IDMC.
- Knowledge of Pharmaceutical / Life Sciences domain.
- Familiarity with data governance, data catalog, and data quality tools.
- Exposure to Google Data Engineering solutions.
- Awareness of AI & Gen AI products and tools in data ecosystems.
