LIMS–ERP Integration Validation Specialist; Oracle

Contractor - 3rd Party PR, PR

3 days ago Requisition

About Company:

JC Automation Corp. (JCA) was founded in 1997 with the mission of filling a gap between technology and regulatory requirements in the life science manufacturing industry. The company offers highly capable resources at an affordable cost to build solutions and execute projects in:
Automation, Control Systems Integration, Information Technology, System Integration and Regulatory Compliance.

JCA is a HUBZone Certified Small Business Firm, NMSDC Certified Minority Business Enterprise, and Certified Critical Industry Supplier. It’s mission is to add value by delivering quality services & solutions on time all the time by transforming processes & technology into business advantages.

ABOUT THE ROLE

Ensure that the bidirectional, API-based interface between the validated Lab Ware Laboratory Information Management System (LIMS) and the client’s Oracle ERP is incorporated into validation lifecycle documentation, requirements traceability, and qualification testing, so that information exchanged between both systems is accurate, complete, secure, and compliant with 21 CFR Part 11, GAMP 5, data integrity requirements, and client and JCA quality standards.

The LIMS–ERP Integration Validation Specialist will work in a hybrid model supporting a client in the life sciences industry. Requirements, design review, test development, and coordination with Oracle integration resources may be performed remotely, while the execution of formal qualification testing must be performed onsite at the client facility in Rancho Cordova, California. The role is expected to be a part-time allocation, with higher demand during the Design phase and during 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.

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 (e.g., message content, direction, triggers, error handling, security, and monitoring).
• Assess interface data risks, including critical data elements, data flows, and failure modes (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, and 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 Lab Ware resources, and execute interface tests onsite, verifying data at source and target and capturing objective evidence (e.g., 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 the 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…