Job Information
Sanofi Group Product 360 MDM Expert in Hyderabad, India
Job Title: Product 360 MDM Expert
Location: Hyderabad
Position overview
This position reports to Market Data Lead in Opella (CHC BU of Sanofi).
A corner stone of CHC transformation in the coming years, the Master Data & Governance defines the strategy and operationalization of data practices to lead the change and transform internal practices.
Embody Sanofi transformation with regular communications, upskilling, and proactivity.
The core objective the Product 360 MDM Expert in the Digital Data, Analytics & AI department will spearhead the development and management Product 360 data products. This role requires a blend of technical expertise and business acumen to deliver data solutions that drive decision-making and support Digital initiatives. They play a critical role in ensuring seamless, efficient, and effective integration across different departments and organizations.
As an Informatica Product 360 MDM (Master Data Management) Expert, you will be an experienced and highly skilled Subject Matter Expert (SME) where you will be responsible for providing knowledge and guidance in the implementation and optimization of Informatica MDM P360 solutions. Your role will involve collaborating with business stakeholders and technical teams to understand their master data management challenges and requirements, help with the designing MDM solutions using Informatica P360, and assisting in the implementation, configuration, and maintenance of these solutions. You will play a critical role being responsible for developing the master data management system, including data integration, data modeling and data migration, ensuring data quality, data integration, and consistency across enterprise systems.
You will be responsible for working with Informatica MDM components and services, data models, and industry best practices.
Additionally, you will play a key role in handling critical production data issues and collaborating with cross-functional teams to deliver high-quality solutions around Product MDM.
You would provide architecture and design, use case development, and solution implementation advice, responding promptly to internal Product questions with technical explanations of product features and capabilities when needed, and being able to prepare and deliver unique solution presentations or technical proposals.
Also, as we are working with other Digital areas in the organization, you will become the technical coach to your colleagues.
DETAILED ROLES AND RESPONSIBILITIES
Solution Design and Implementation
Work with Informatica MDM 360 solutions multi-domain edition (Product, Reference, etc.), related components and services (create Business 360 connections, multidomain MDM SaaS solution, defining business entities, base objects, staging tables, lookup tables, manage and migrate assets, defining hierarchies and relationships, mappings, cleanse function, designing user interface, configuring data quality and survivorship rules, managing custom user roles and privileges, onboarding data, configuring trust & match & merge models and rules, defining jobs and business events, manage reports and dashboards, etc.
Utilize your expertise in Informatica MDM P360 to configure and customize the MDM solution.
Ensure adherence to MDM best practices and industry standards across the Product domain.
Create, enhance, and manage data models to meet business requirements.
Drive the technical design, implementation, and governance of the MDM solution.
Responsible for creating and customizing the Product 360 and Reference 360 data model to cater the current business need without impacting the existing downstream applications.
Be able to define, tune and refine data models, hierarchies, relationships, data matching, survivorship, and merge rules, and achieve optimal balance between functionality and performance.
Be able to refine MDM domains and reference data models as the business evolves.
Provide technical mentorship and guidance to the team on implementing solutions on the Informatica SaaS platform in the Product Domain
Create and manage data mappings, transformations, and workflows within Informatica MDM Hub
Collaborate with technical teams to integrate Informatica MDM with other enterprise systems, applications, and databases
Configure and customize Informatica MDM Product 360 and associated components to meet specific business needs, assisting in the installation, configuration, and administration of Informatica MDM environments if needed.
Perform data profiling, cleansing, and matching activities to ensure data quality and consistency when needed.
Governance
Define and enforce data governance processes and policies within the Product Domain
Collaborate with data stewards and business users to establish data quality rules and data governance workflows
Provide guidance and support in data stewardship activities
Implement data security and access controls to protect sensitive master data
Implement and maintain data quality monitoring and reporting mechanisms
Implements the dashboards and reports to be able to monitor the data governance program progress for each our data foundations and data products
Integration
Provide design approach for ingress and egress mechanism from/to source/target by means of batch and API
Configure and manage data integration processes between Informatica MDM and other source/target systems
Design and implement data synchronization and replication mechanisms to ensure consistency across systems
Troubleshoot data integration issues, perform data reconciliations, and resolve data conflicts
Monitor and analyze Informatica MDM performance and identify areas for optimization
Tune and optimize MDM processes, workflows, and database configurations for improved efficiency
Conduct performance testing and capacity planning to ensure scalability of the MDM solution
Define the test strategies both for batch and real time ingestion and assist in development of methodology, libraries, and templates for reuse
Develop and execute data loading processes and integration workflows using Informatica MDM
Data quality
The MDM Expert is expected to help the team to produce and report on data quality and trending analytics to steering committees and working groups
Perform data profiling activities to analyze data sources, identify data quality issues, and assess data completeness
Develop and implement data cleansing processes to standardize and cleanse data, remove duplicates, resolve inconsistencies, and apply data validation rules
Design and implement data quality rules using Informatica Data Quality tools, including business rules, data validation rules, and data standardization rules
Collaborate with data integration teams to ensure seamless integration of data quality processes within data integration workflows
Conduct data quality assessments, create data quality metrics, and analyze data quality reports to measure the effectiveness of data cleansing processes
Investigate data quality issues, identify root causes, and develop solutions to address them. Perform impact analysis and implement corrective measures
Maintain metadata repositories and data dictionaries to document data quality rules, transformations, and data lineage
Optimize data quality processes for efficiency and performance by analyzing data processing workflows, identifying bottlenecks, and fine-tuning data quality transformations and rules
Collaborate with business analysts, data stewards, and other stakeholders to understand data quality requirements and develop data quality strategies
Create technical documentation, including data quality specifications, process flows, and user guides
Transversal topics
Participate in workshops, collaborate with business stakeholders and technical teams to understand master data management objectives, challenges, and requirements, and translate them into technical requirements to prepare future Informatica Product MDM solutions.
Analyze existing data structures, systems, and processes to identify data management gaps and opportunities for improvement.
Resolve technical incidents in the tools under his responsibility.
Support and participate in change management activities by generating content, giving training, etc.
Bring industry best practices in enterprise master data management and solution integration.
Build Logical and Physical Data Models, Hierarchies, Trust setting, User Security, Data Flow configuration, De-Duplication, Matching and cleansing
Perform development activities, document and execute unit test cases/scripts and document test and review results
QUALIFICATIONS AND SKILLS
Bachelor's or master’s degree in Computer Science, Information Systems, or a related field
8+ years of experience in Data Management
5+ years of hands-on experience in Informatica SaaS solutions, preferable in Informatica Intelligent Data Management Cloud (IDMC) Product 360
Experience implementing full lifecycle MDM projects.
Hands-on experience as an MDM expert/specialist or a similar role, specifically with Informatica MDM Product 360 and/or Multidomain MDM and/or Reference 360, including handling critical production data issues, hot fixes, and patches.
Strong understanding of master data management concepts, data governance principles, and data integration strategies
Experience in designing and implementing MDM solutions, data models, and data hierarchies
Proficiency in data profiling, data cleansing, and data matching techniques
Excellent analytical and problem-solving skills with the ability to translate business requirements into technical solutions
Strong communication and interpersonal skills to effectively collaborate with clients and cross-functional teams
Hands-on experience in Microsoft PowerBI and Snowflake is desirable
Strong ability and passion to document things and present to different audiences
Strong understanding of MDM best practices and industry standards in the Product domain.
Experience in integrating external business applications with MDM hub
Understanding of data governance and data profiling concepts
Strong understanding of MDM architectures and business processes
Solid understanding of Data integration, Data Quality, Data Architecture, and Master Data Management
Awareness of MDM trends, MDM Concepts, and other MDM tools specially around Product in Pharma Industry
Familiarity with other related Informatica services is plus.
Relevant certifications in Informatica MDM, such as Informatica MDM Developer or Administrator, are a plus
Familiarity with other Informatica products, and data quality and data governance frameworks are desirable
Pursue progress , discover extraordinary
Better is out there. Better medications, better outcomes, better science. But progress doesn’t happen without people – people from different backgrounds, in different locations, doing different roles, all united by one thing: a desire to make miracles happen. So, let’s be those people.
At Sanofi, we provide equal opportunities to all regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, ability or gender identity.
Watch our ALL IN video (https://www.youtube.com/watch?v=SkpDBZ-CJKw&t=67s) and check out our Diversity Equity and Inclusion actions at sanofi.com (https://www.sanofi.com/en/our-responsibility/equality-and-inclusiveness) !
Sanofi is dedicated to supporting people through their health challenges. We are a global biopharmaceutical company focused on human health. We prevent illness with vaccines, provide innovative treatments to fight pain and ease suffering. We stand by the few who suffer from rare diseases and the millions with long-term chronic conditions.
With more than 100,000 people in 100 countries, Sanofi is transforming scientific innovation into healthcare solutions around the globe. Discover more about us visiting www.sanofi.com or via our movie We are Sanofi (https://youtu.be/96EwNjb1TLo)
As an organization, we change the practice of medicine; reinvent the way we work; and enable people to be their best versions in career and life. We are constantly moving and growing, making sure our people grow with us. Our working environment helps us build a dynamic and inclusive workplace operating on trust and respect and allows employees to live the life they want to live.
All in for Diversity, Equity and Inclusion at Sanofi - YouTube (http://www.youtube.com/watch?v=SkpDBZ-CJKw&t=2s)