Position Overview
The Integration Developer is a solid, independent contributor who builds and supports integrations between the MDM platform and enterprise systems end-to-end. Owns integration pipelines from development through production support under the “you build it, you support it” model. Works with moderate guidance from senior team members on complex integration design but independently delivers sprint commitments and resolves production issues within their domain.
Integration Development & Enhancement
- Build and maintain ETL/ELT pipelines for data ingestion, transformation, and publishing between MDM and connected systems
- Design and implement API-based integrations (REST, SOAP) for real-time and near-real-time data exchange
- Implement event-driven integration patterns using message queues and streaming platforms
- Design and configure job scheduling and orchestration for batch processing
- Implement region-specific integration logic including conditional mappings, regional routing rules, and geography-based transformation
- Build data mapping and transformation logic for source-to-target scenarios
- Develop error handling, retry logic, and dead-letter queue patterns for resilient integrations
- Onboard new data sources and systems to the MDM integration layer
- Participate in design discussions with the MDM Architect and raise technical concerns on integration feasibility
- Implement BPM/workflow orchestration for cross-system business processes (e.g., Camunda, Temporal, or platform-native)
- Implement lifecycle status tracking and contribute to cross-system observability
- Support integration consolidation by migrating pipelines from legacy patterns to target-state architecture
- Implement integration enhancements and optimizations
Platform Modernization
- Execute integration modernization tasks — rebuild, reroute, or redesign integration pipelines per modernization plans
- Implement new integration patterns and validate end-to-end data flow integrity during modernization phases
- Implement data mapping per specifications during modernization phases
- Perform regression testing and report discrepancies during modernization
Production Support, Troubleshooting & Incident Resolution
- Own production support for integrations you built — resolve incidents within SLAs
- Debug end-to-end data flows: source extraction, transformation, delivery, and acknowledgment
- Analyze application, middleware, and database logs to isolate root cause of integration failures
- Resolve defects involving data format mismatches, connectivity failures, timeout issues, and message delivery problems
- Troubleshoot job scheduling failures — missed triggers, dependency chains, resource contention
- Identify patterns in recurring integration failures and implement permanent fixes
- Collaborate with data lake, ERP, CRM, and MDM teams to resolve cross-system data flow issues
- Handle data reconciliation between source systems and MDM platform
- Share knowledge on resolved issues through documentation and team sessions
CI/CD, Deployment & DevOps
- Use CI/CD pipelines for integration deployments and troubleshoot pipeline failures
- Manage deployment processes across dev, test, staging, and production environments
- Implement and maintain monitoring and alerting for integration pipelines
- Perform post-production validation for integration releases; execute rollback procedures when needed
- Participate in DR testing and validate recovery procedures
- Manage environment configurations, secrets, and connection parameters across environments
Testing & Quality
- Develop and execute test cases for integration SIT and UAT — validate data accuracy, completeness, and timeliness
- Perform load and performance testing for high-volume integration pipelines
- Participate in code reviews and incorporate feedback
- Refactor integration code to improve performance, readability, and maintainability
- Address technical debt in integration layer — eliminate redundant pipelines, consolidate logic, improve error handling
Security & Compliance
- Working knowledge of data security, information security practices, and SOX compliance procedures for integration changes
Required Qualifications
- 6+ years hands-on experience building data integrations and ETL/ELT pipelines (e.g., Informatica PowerCenter, IICS, Talend, MuleSoft, Azure Data Factory)
- 6+ years advanced SQL experience — complex queries, stored procedures, performance tuning (e.g., Oracle, SQL Server, PostgreSQL)
- 4+ years hands-on coding — write, debug, and refactor code (e.g., Java, Python, PL/SQL, shell scripting)
- 4+ years experience with API development and integration (REST, SOAP, webhooks)
- 3+ years experience with event-driven architecture and messaging platforms (e.g., Kafka, RabbitMQ, IBM MQ, AWS EventBridge)
- 3+ years experience with job scheduling and orchestration tools (e.g., Autosys, Control-M, Apache Airflow, cron)
- 3+ years experience with CI/CD tools and deployment automation (e.g., Jenkins, GitLab CI, Azure DevOps, Ansible)
- 3+ years experience with log analysis and monitoring tools (e.g., Splunk, ELK Stack, Datadog, CloudWatch)
- 2+ years experience with process orchestration or BPM platforms (e.g., Camunda, Temporal, Appian)
- 2+ years experience with cloud platforms and services (e.g., AWS, Azure, GCP)
- 2+ years experience with incident management using ticketing systems (e.g., ServiceNow, Jira)
- Experience integrating with MDM platforms and understanding of MDM data flows (match, merge, publish)
- Strong knowledge of SDLC: requirements, development, testing (unit, SIT, UAT), CI/CD, change management, release management
Preferred Qualifications
- Manufacturing industry experience
- Informatica MDM or Reltio integration experience
- Experience with iPaaS platforms (e.g., Workato, Boomi, Celigo) for integration orchestration
- Familiarity with graph database concepts
- Experience with data lake architectures and integration patterns (e.g., Snowflake, Databricks, S3)
- Experience with containerization (e.g., Docker, Kubernetes)
- Experience collaborating with adjacent data teams on cross-system data flows
- Agile/Scrum delivery experience
