Application Development & Support Specialist

Position Overview

The Associate Integration Developer supports the development, testing, deployment, and operations of integrations between the MDM platform and enterprise systems. This role combines integration development with DevOps responsibilities including CI/CD pipeline management, deployment automation, environment management, and monitoring. Builds foundational integration and DevOps skills through hands-on work under guidance from senior developers.

Integration Development & Enhancement

• Develop and configure ETL/ELT pipelines under guidance from senior developers
• Build API-based integrations per design specifications
• Implement event-driven integrations per established patterns
• Configure and maintain scheduled jobs per established patterns
• Implement data mapping and transformation logic per specifications
• Implement error handling and retry patterns per established designs
• Assist with new data source onboarding and connectivity testing
• Attend design discussions and document integration decisions
• Support workflow configuration and testing
• Execute assigned enhancement tasks

Platform Modernization

• Support integration modernization testing, connectivity validation, and documentation
• Assist with testing new integration patterns and validating data flow
• Test and validate region-specific data flows and flag discrepancies
• Run data validation scripts and document results during modernization
• Execute regression test cases and document results

Production Support, Troubleshooting & Incident Resolution

• Triage incoming integration incidents, perform initial investigation, and escalate when needed
• Trace data through integration flows to identify obvious failure points
• Review logs to gather initial diagnostic information for escalation
• Fix straightforward defects: connectivity issues, job failures, data format errors
• Monitor scheduled jobs, flag failures, and restart jobs per runbook procedures
• Document incident patterns and maintain integration runbooks
• Communicate issue status to team members and update tickets in ServiceNow
• Run reconciliation scripts and flag discrepancies
• Maintain incident logs and knowledge base articles

CI/CD, Deployment & DevOps

• Build, maintain, and optimize CI/CD pipeline configurations for integration and MDM deployments (e.g., Jenkins, GitLab CI, Azure DevOps)
• Manage deployment processes and environment promotions across dev, test, staging, and production
• Configure and maintain monitoring dashboards, alerting rules, and notification channels (e.g., Datadog, CloudWatch, Splunk)
• Execute post-production validation checks and support rollback execution
• Support DR testing execution, validate recovery of integration jobs, and document results
• Maintain environment configurations, manage secrets, and ensure connection parameters are consistent across environments
• Manage infrastructure-as-code and environment provisioning scripts (e.g., Terraform, Ansible, CloudFormation)
• Implement and maintain automated health checks and self-healing mechanisms for integration jobs

Testing & Quality

• Execute regression test cases for integration pipelines and document results
• Support performance testing execution and data collection
• Submit code for review and address feedback promptly
• Write clean code following established standards and patterns
• Flag technical debt encountered during development

Security & Compliance

• Basic understanding of data security, information security, and SOX compliance; follows established procedures

Required Qualifications

• 4+ years experience with data integration tools or ETL/ELT development (e.g., Informatica PowerCenter, IICS, Talend, MuleSoft, Azure Data Factory)
• 4+ years SQL experience — queries, joins, stored procedures, data validation (e.g., Oracle, SQL Server, PostgreSQL)
• 3+ years hands-on coding — write and debug code (e.g., Java, Python, PL/SQL, shell scripting)
• 2+ years experience with API development (REST, SOAP)
• 2+ years exposure to messaging platforms or event-driven concepts (e.g., Kafka, RabbitMQ, IBM MQ)
• 2+ years experience with job scheduling tools (e.g., Autosys, Control-M, Apache Airflow, cron)
• 3+ years hands-on experience building and maintaining CI/CD pipelines (e.g., Jenkins, GitLab CI, Azure DevOps, Ansible, Terraform)
• 2+ years experience with monitoring, alerting, and log analysis tools (e.g., Splunk, ELK Stack, Datadog, CloudWatch)
• 2+ years experience with cloud platforms, infrastructure-as-code, and environment management (e.g., AWS, Azure, Terraform, CloudFormation)
• 2+ years experience using ticketing systems for incident tracking (e.g., ServiceNow, Jira)
• Basic understanding of MDM concepts and how integrations feed/consume MDM data
• Working knowledge of SDLC: development, testing, CI/CD, change management, deployment processes

Preferred Qualifications

• Manufacturing or supply chain exposure
• Informatica or Reltio platform exposure
• Familiarity with workflow orchestration concepts
• Experience with iPaaS platforms (e.g., Workato, Boomi, Celigo)
• Familiarity with data lake concepts and cloud storage (e.g., S3, Snowflake)
• Hands-on experience with containerization and orchestration (e.g., Docker, Kubernetes, ECS)
• Experience with infrastructure-as-code tools (e.g., Terraform, Ansible, CloudFormation)
• Agile/Scrum delivery experience