Sr ETL Developer MuleSoft

Description

Key Responsibilities

1. Integration & API Development

• Design and develop integration flows using Mulesoft Anypoint Platform:
• System APIs
• Process APIs
• Experience APIs
• Build integrations for:
• Customer creation and updates
• Address validation and enrichment
• Duplicate checks and MDM-based match requests
• Customer lifecycle synchronization across OpCos
• Develop scalable integrations between:
• Reltio MDM (REST APIs)
• CRM platforms (Salesforce/Dynamics)
• ERP (SAP/Oracle)
• Customer Portal
• Data Warehouse / analytics platforms
• Implement reusable ETL flows for ingesting and publishing customer data.

2. Reltio MDM Integration

• Develop Mulesoft APIs to interact with Reltio's:
• Entity APIs
• Relationship APIs
• Match/Merge APIs
• Golden record retrieval
• Crosswalk & lineage management
• Implement transformation logic to map customer structures (Entity/Attributes/Relationships) into Reltio canonical models.
• Support real-time and batch synchronization between Reltio and downstream systems.

3. Multi-OpCo Customer Data Processing

• Implement ETL logic for:
• OpCo-specific customer attributes
• Healthcare/dental practice details
• Dealer/distributor account flows
• DSO hierarchy and approval data
• Build normalization, enrichment, and validation layers for customer data ingestion.
• Implement metadata-driven transformations for multi-region customer models.

4. Performance, Logging & Error Handling

• Build highly performant integration flows capable of handling large customer datasets.
• Implement:
• Retry logic
• Error queues
• Dead-letter handling
• Distributed logging
• Enable observability using Anypoint Monitoring or ELK/Splunk.

5. Collaboration, Design & Documentation

• Work closely with:
• BA teams
• MDM architects
• Full-stack portal team
• CRM/ERP owners
• QA and automation teams
• Prepare technical design documents (TDD), mapping sheets, and sequencing diagrams.
• Participate in code reviews and performance optimization sessions.

6. Testing & Deployment Support

• Support SIT, UAT, and integration testing cycles.
• Assist DevOps teams in setting up CI/CD pipelines for Mulesoft deployments using:
• GitHub/GitLab/Jenkins/Azure DevOps
• Ensure smooth deployment of APIs into different environments.

Required Skills & Experience

• 510 years of experience in integration and ETL development.
• Strong hands-on experience in:
• Mulesoft Anypoint Studio
• API-led architecture (System, Process, Experience)
• DataWeave / transformations
• RAML/OAS
• Experience integrating with:
• Reltio MDM (strongly preferred)
• CRM platforms (Salesforce, Dynamics)
• ERP systems (SAP/Oracle)
• Portals and data warehouses
• Strong understanding of customer data domains:
• Healthcare/dental/medical device accounts
• DSO structures
• Dealer/distributor models
• Multi-site and multi-address handling
• Experience with real-time & batch integrations.

Good to Have

• Experience with:
• Address verification services
• Event streaming (Kafka)
• Cloud platforms (AWS/Azure/GCP)
• CI/CD pipelines for Mulesoft deployments
• Understanding of MDM concepts (match/merge, survivorship, hierarchy).