EDI Developer

Role Summary

We are looking for a Senior OIC Developer with 5 to 8 years of experience to design, develop, and deliver enterprise integration solutions using Oracle Integration Cloud Gen3. The ideal candidate should have strong hands-on experience in OIC, relational databases, and integrations across Oracle Cloud Warehouse Management System, Oracle Fusion, and Oracle Transportation Management. This role requires someone who can translate business requirements into scalable technical designs, lead project execution, and collaborate effectively with functional and technical stakeholders.

Key Responsibilities

• Design, develop, test, deploy, and support integrations using Oracle Integration Cloud Gen3.

• Convert business and functional requirements into integration designs, technical specifications, mappings, and implementation plans.

• Build and maintain integrations between OIC, OCWMS, Oracle Fusion, OTM, relational databases, and other enterprise systems.

• Work with REST, SOAP, database adapters, file-based integrations, transformations, mappings, lookups, error handling, and monitoring capabilities in OIC.

• Lead small to medium integration work streams, coordinate with cross functional teams, and ensure timely delivery of project milestones.

• Perform troubleshooting, root-cause analysis, performance tuning, and production support for integration issues.

• Follow integration best practices for security, reusability, scalability, observability, documentation, and change management.

• Collaborate with business analysts, functional consultants, architects, developers, and support teams to deliver reliable integration solutions.

Must-Have Skills

 • Strong hands-on experience with Oracle Integration Cloud Gen3.

• Strong hands-on experience with relational databases and SQL.

• Experience integrating OIC with OCWMS, Oracle Fusion.

 • Experience leading a project or integration work stream.

• Ability to convert requirements into clear technical designs and implementation plans.

• Good understanding of integration patterns, data mapping, API-based integrations, error handling, monitoring, and debugging.

• Strong communication, problem-solving, and stakeholder coordination skills.

Good-to-Have Skills

• Functional knowledge of OCWMS, Oracle Transportation Management, and Oracle Fusion applications.

• Awareness of AI capabilities in Oracle Integration Cloud, including natural language-assisted development, AI-assisted troubleshooting, and OCI AI service actions.

• Familiarity with cloud computing concepts and cloud-native integration approaches.

 • Oracle Integration Cloud certification.

• Familiarity with Oracle Cloud Infrastructure, including basic understanding of OCI services, security, connectivity, and deployment concepts.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.

• 5 to 8 years of relevant experience in integration development, preferably with Oracle Integration Cloud.

• Oracle Integration Cloud certification is required.

• Experience in Oracle SCM, logistics, warehouse management, transportation, or enterprise application integration projects will be an advantage.

The EDI QA Analyst works closely with external vendors during implementations to communicate testing expectations, coordinate validation activities, and address vendor feedback. Operating in a production-adjacent environment, the role ensures data accuracy, file integrity, and carrier readiness through structured test planning, test data preparation, scenario validation, defect identification and classification, and thorough documentation within the carrier file/EDI delivery lifecycle.

In addition, the analyst collaborates cross-functionally with requirements, development, and implementation teams to develop comprehensive test plans, manage testing activities, and work through ticketing queues to ensure timely and high-quality file delivery.

Post-production, the EDI QA Analyst is responsible for ongoing monitoring, review, and resolution of carrier error reports, while identifying trends and opportunities for continuous process improvement.

Key Responsibilities and Duties

Carrier/Vendor File Validation

•     Validate outbound carrier/vendor files (ANSI/HIPAA 834 and related formats) for structural integrity, format compliance, eligibility accuracy, and carrier-specific requirements before transmission.

•     Collaborate with external carriers/vendors and internal teams, including development and operations, to validate file behavior and resolve discrepancies.

Scenario-Based Testing

•     Develop and execute structured test scenarios covering eligibility rules, enrollment transactions, life events, and carrier-specific behaviors across internal and external testing phases.

End-to-End Data Reconciliation

•     Trace and reconcile data from upstream systems through platform outputs to final vendor files using SQL, reports, and control totals to ensure data integrity.

•     Test Planning & Requirements Traceability

o  Translate carrier/vendor and business requirements into structured test plans, reusable test cases, and traceable validation scenarios aligned to standardized templates.

•     Test Data Preparation

o  Identify, prepare, and manage representative test populations across systems and reporting environments to support validation cycles.

•     Defect Identification & Routing

o  Analyze validation results, classify defects (requirements, configuration, data, system issues), and manage QA tickets through defined workflows, ensuring proper routing, status tracking, ownership, and timely closure.

•     Documentation & Continuous Improvement

o  Provide regular status updates on QA progress, risks, and dependencies aligned to timelines and release schedules.

o  Maintain QA documentation (test plans, validation evidence, file layouts, queries, defect patterns) while building reusable test assets, vendor test plan libraries, and supporting future automation initiatives.

o  Help establish and maintain a vendor test plan library in support of all vendor relationships.

o  Drive automation and validation improvements.

•     Production Monitoring & Carrier Error Resolution

o  Review carrier acknowledgement and error reports (e.g., 999, rejection reports)

o  Investigate and resolve rejected records.

o  Coordinate corrections and reprocessing.

o  Ensure timely resolution within SLA.

•     Trend Analysis & Continuous Improvement – Post-production

o  Analyze recurring carrier errors and identify patterns.

o  Provide insights into upstream data or configuration issues.

o  Recommend improvements to reduce rework and increase first-pass success.

Required Qualifications

•     Bachelor’s degree in Computer Science or a related technical field (or equivalent experience).

•     Minimum of 2 years of experience in health insurance or Health & Welfare (H&W) benefits administration.

•     Experience working with carrier files, EDI transactions, or HIPAA 834 files in a production or operational environment.

•     Strong understanding of eligibility and enrollment processes, including effective date logic and life event transactions.

•     Hands-on experience with SQL for data validation, reconciliation, and defect analysis.

•     Strong analytical skills with a high level of attention to detail, especially in regulated environments with low tolerance for error.

Preferred Qualifications

•     Familiarity with QA best practices and Quality Management Systems (QMS), including frameworks that ensure consistent compliance with customer and regulatory requirements while driving continuous improvement and efficiency.

•     Experience with EDI testing and carrier integration environments.

•     Exposure to COBRA processes within benefits administration.

•     Experience with test automation and test case management tools.

•     Familiarity with AI-assisted testing or quality engineering practices.

•     Experience in preparing, validating, and analyzing test data across multiple systems.

•     Solid understanding of data models and relational database concepts.

•     Experience using defect tracking and ticketing systems such as JIRA (or similar tools).