LIMS–ERP Integration Validation Specialist (Oracle)

JC Automation Corp • US, PR

7h • Hybrid

About The Position

JC Automation Corp. (JCA) is seeking a LIMS–ERP Integration Validation Specialist to ensure that a bidirectional, API-based interface between a validated LabWare LIMS and a client’s Oracle ERP is included in validation lifecycle documentation, requirements traceability, and qualification testing. The specialist will help verify that information exchanged between the systems is accurate, complete, secure, and compliant with 21 CFR Part 11, GAMP 5, data integrity requirements, and client and JCA quality standards.

This is a hybrid role supporting a client in the life sciences industry. Requirements work, design review, test development, and coordination with Oracle integration resources may be performed remotely. Formal qualification testing must be performed onsite at the client facility in Rancho Cordova, California. The position is expected to be a part-time allocation, with greater demand during the Design phase and interface qualification, currently forecast for Q3–Q4 2027. Occasional extended hours may be required during qualification execution and go-live activities. Candidates must be legally authorized to work in the United States.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related scientific or technical field; an equivalent combination of education and directly related GMP computerized-system validation or integration experience may be considered.
• At least five years of experience in Computer System Validation or regulated IT in the pharmaceutical, biotechnology, or another GMP-regulated industry.
• At least three years of experience validating or implementing system interfaces, such as LIMS–ERP, MES–ERP, LIMS–MES, or LIMS–CDS.
• Experience developing and executing interface or integration test scripts.
• Experience with data migration verification or data reconciliation between systems.
• Understanding of system integration concepts, including APIs and web services (REST/SOAP), data formats (JSON/XML), middleware, message queues, and error handling.
• Understanding of ERP material and quality processes, including material master, lot management, sample receipt, and material disposition.
• Ability to verify data between systems using SQL queries, reports, and field-level comparisons.
• Working knowledge of 21 CFR Part 11, GAMP 5, and data integrity requirements (ALCOA+) as they apply to interfaced data.
• Ability to design interface test cases and write clear test steps with objective acceptance criteria.
• Familiarity with API testing and log analysis tools such as Postman and SoapUI.
• Proficiency in Microsoft Office applications, including Word, Excel, and Visio.
• Excellent oral and written communication skills in English.
• Collaborative approach and ability to coordinate effectively with IT, integration, and Quality personnel.
• Strong attention to detail and commitment to documentation accuracy.
• Clear and proactive communication across multidisciplinary teams.
• Ability to work independently in a structured field environment.
• Organized, methodical, and adaptable under project timelines.
• Team-oriented approach to problem solving.
• Willingness to work onsite during testing, startup, and qualification phases.
• Legally authorized to work in the United States.

Nice To Haves

• Experience with LIMS–Oracle (e.g., Oracle E-Business Suite or Oracle Cloud) or LIMS–SAP QM integrations.
• Experience with LabWare LIMS interfaces or web services.
• Experience with integrations involving quality management systems, such as investigation status.
• Experience applying Computer Software Assurance (CSA) principles to interface testing.
• ISPE GAMP training or equivalent.
• Spanish language skills.

Responsibilities

• Review interface mappings, business rules, system-of-record definitions, and technical design information for the LIMS–Oracle interface.
• Develop interface requirements for the User Requirements Specification and interface content for the Application and Infrastructure System Design Specifications, including message content, direction, triggers, error handling, security, and monitoring.
• Assess interface data risks, including critical data elements, data flows, and failure modes such as lost, duplicate, or partial transactions, timeouts, and reconciliation, as input to the Data Risk Assessment and Data Integrity Assessment.
• Define the interface test strategy, including positive, negative, boundary, error-handling, retry, reconciliation, security, and audit trail scenarios; coordinate test environments and Oracle test data with integration resources.
• Develop interface test scripts verifying bidirectional exchange of material master data, lot and manufacturing information, sample receipt, material disposition, and investigation status.
• Perform interface dry runs with Oracle integration and LabWare resources, and execute interface tests onsite, verifying data at source and target and capturing objective evidence such as transaction records, logs, and screen captures.
• Document interface test discrepancies and support their resolution with integration developers, including retesting and closure.
• Ensure interface requirements are traced to design and test in the Requirements Traceability Matrix.
• Verify interface configuration as part of Configuration Qualification in the Production environment, and support cutover and go-live monitoring.
• Provide input to the LIMS Administration Procedure on interface monitoring, error handling, and reprocessing.
• Comply with client and JCA Quality Management System (ISO 9001) requirements, including training, document control, and confidentiality obligations.

What This Job Offers

• Job Type: Part-time
• Career Level: Mid Level