Lead Data Engineer
Primary Skills
Informatica MDM
SQL
Java
DWH
Data Modelling
Specialization
ETL Specialization: Data Engineer
Job requirements
Job Description – Informatica MDM Developer
Role Type: Hybrid
Location: All Brillio
Experience: 5+ years
Role Overview
We are looking for an Informatica MDM Developer with strong expertise in Informatica MDM and Java. The role requires a mix of hands-on technical skills in data integration and application development, along with responsibilities in platform management, stakeholder collaboration, and training.
Core Technical Responsibilities
Analyse and resolve match and merge issues, duplicate records and missing Golden records.
Monitor MDM batch jobs and troubleshoot job failures or long-running jobs.
Develop Java modules for exception handling, threading, configuration, and integration.
Write and optimize SQL/PL-SQL queries for data extraction, transformation, and performance tuning.
Support Server patching and validation Activities in prod and non-prod environments.
Create change request(CRs), test evidence, and deployment documents.
Integrate with APIs (SOAP & REST), XML/JSON, and JMS MQ for seamless data exchange.
Collaborate with cross-functional technical teams to deliver robust integration and governance solutions.
Platform & Stakeholder Responsibilities
Collaborate with the business and technical teams to resolve MDM issues
Supporting the Data steward team in resolving incorrect or unmatched records.
Act as the Single Point of Contact (SPOC) for functional aspects of the Data Management Tool, with a focus on MDM.
Support incident, problem, and change management activities.
Manage access management policies and user provisioning for the Data Management platform.
Plan, design, and deliver training sessions for stakeholders and end users.
Support MDM deliveries, product development, and project implementations as part of the Data Management platform team.
Participate in user acceptance testing (UAT) for new releases of MDM modules.
Mandatory Skills
Informatica MDM (Hub Console,IDD,ActiveVOS, Provisioning Tool, External Call configuration).
Core Java (OOP concepts, inheritance, exception & thread handling).
Additional Skills
Strong SQL / PL-SQL (query optimization, packages, functions).
Scripting experience (Shell, Perl, or similar).
Exposure to application servers (JBoss; WebLogic/WebSphere a plus).
Familiarity with version control tools (Bitbucket, Git).
Preferred Skills
Knowledge of MDM concepts and data governance.
Exposure to Salesforce integration via Informatica.
Experience in Agile development environments.
Qualifications
Bachelor’s or Master’s degree in Computer Science, IT, or related field.
Informatica MDM certification is an advantage.