Job Description

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

Application Development & Support Specialist