MDM Specialist - Master Data Management with Informatica & Pimcore

Role Overview

We are seeking a skilled professional to architect a scalable, multi-layered data framework that immediately supports Finance functions while preparing for future Vendor and Asset domain needs. The role centers around designing, configuring, and implementing Master Data Management (MDM) tools, particularly Pimcore.

Key Duties

• Lead the design and deployment of the Pimcore platform.
• Create logical data models encompassing entities, attributes, and relationships for the MDM hub.
• Plan integration strategies by choosing between batch processing (Spark) or real-time streaming (Kafka) to comply with strict 24-hour data lineage service levels.
• Develop technical protocols governing source-to-target data mappings and implement data sensitivity masking.
• Construct, test, and deploy efficient data pipelines syncing six disparate source systems with the MDM hub.
• Develop ETL/ELT workflows utilizing industry tools such as Informatica, Talend, or Azure Data Factory.
• Process large datasets using Big Data frameworks like PySpark or Scala/Spark to execute data cleansing, deduplication, and financial data transformations.
• Deploy Apache Kafka messaging for real-time metadata synchronization and system change notifications.
• Create Python scripts for API handling, automated data validations, and routine maintenance.

Required Qualifications and Skills

• Hands-on experience deploying MDM solutions, especially Pimcore.
• Strong expertise in MDM architecture and advanced data modeling.
• In-depth knowledge of distributed computing and event-driven architecture paradigms.
• Experience with cloud-native data security, including role-based access control and PII encryption methods.
• Advanced programming skills in SQL, Python, and Spark (PySpark).
• Practical experience with Kafka or equivalent messaging queues.
• Proficiency in at least one enterprise ETL platform.
• Familiarity with Git-based CI/CD pipelines tailored for data engineering workflows.
• Capability to perform custom data transformations and deduplication across multiple inconsistent data sources using Python and PySpark.
• Maintaining unified data consistency across streams with Apache Kafka.
• Standardizing Chart of Accounts and cost centers into a centralized MDM repository.
• Expertise in complex SQL querying, data profiling, and database management.
• Implementing stringent data quality gates to block non-compliant financial data ingestion.

Compensation and Work Conditions

• This role offers an hourly payment of INR 1,250, with an expected minimum commitment of 16 hours per week, totaling approximately INR 20,000 weekly.
• The position is fully remote, allowing you to work from home.
• Immediate joining is expected.
• Part-time work arrangements are supported.