ERP Test Engineer

Arcticom LLC provides network and systems administration, enterprise architecture and resource planning, certification and accreditation, software design, programming, maintenance of telecommunications and land mobile radio equipment and systems, help desk support and IT transformation services among other services.

Arcticom LLC provides network and systems administration, enterprise architecture and resource planning, certification and accreditation, software design, programming, maintenance of telecommunications and land mobile radio equipment and systems, help desk support and IT transformation services among other services.

The Essential Duties and Responsibilities are intended to present a descriptive list of the range of duties performed for this position and are not intended to reflect all duties performed within the job. Other duties may be assigned. To perform this job successfully, an individual must be able to satisfactorily perform each essential duty. The requirements listed below are representative of the knowledge, skill and/or ability required.

Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position.

• Serve as the primary technical authority for evaluating contractor-delivered MilPDS Oracle database code, PL/SQL packages, stored procedures, triggers, views, and schema updates.
• Analyze legacy, non-TDD contractor code deliverables and design a technical roadmap to transition the program to a Test-Driven Development model at the database layer (covering both outer-loop acceptance and inner-loop unit test strategies).
• Architect strategies to extract embedded business rules out of legacy user interface layers and triggers into modular, independently testable database APIs.
• Write production-grade database test routines and automated unit/integration test suites (e.g., using utPLSQL or database-native frameworks) to independently validate contractor deliverables and maintain transactional isolation.
• Architect patterns to isolate component-divergent business rules (e.g., Active, Reserve, Guard variants) and prevent cross-component rule regression.
• Develop automated scripts and data factory utilities for synthetic test data generation, database state resets, and environment staging to ensure repeatable, isolated, and fully unattended test execution.

• Architect, build, and integrate automated database test suites and database version control (Schema-as-Code) directly into the program's emerging CI/CD pipeline.
• Establish automated Cross-System Traceability Daemons within the pipeline to programmatically scan for and reconcile developer-found defects (siloed as JIRA Spikes) with the authoritative system of record (ALM Octane) before code promotion, securing CPAR data hygiene metrics.
• Integrate background execution recorders to capture API transaction traffic, clickstreams, and database queries during unscripted/exploratory testing runs, programmatically converting them into structured, repeatable test assets and code templates.
• Establish automated Test Readiness Review (TRR) technical gates within the pipeline, preventing code migration unless automated database checks, least-privilege security validation, and compliance evidence requirements are met.

• Design and implement data schemas, metadata catalogs (Collibra), and Python-based Retrieval-Augmented Generation (RAG) databases on WDP Databricks to sustain a persistent, multi-session context model.
• Engineer a secure conversational interface using GenAI.mil hooks, enabling senior leadership to query live release readiness (e.g., 'Is Release 7.1 ready?') and receive real-time, mathematically proven quality validations.
• Research, architect, and deploy autonomous or semi-autonomous agentic workflows to automate test case generation, failure log analysis, continuous database test monitoring, and test asset generation.
• Design and implement an automated feedback loop that ingests production anomaly logs, executes rapid root-cause analysis, and programmatically feeds findings back to the database test-suite generation engine to continuously harden pre-release…