Groovy Azure Devops CCS SQL Microsoft Analyst

Azure DevOps CCS SQL Microsoft Analyst

Analyst: Groovy, Java Development, XML Development, Azure DevOps CCS SQL Microsoft

Start date: 11/24/2025

End date: 06/01/2026

Submission deadline: 12/10/2025

Client Info: City of Richmond

Description: The City of Richmond DPU is implementing a new cloud-based billing system - Oracle CCS. The system has additional configurations outside of base functionality and code. Additionally, the system interfaces and is integrated with other 3rd party applications. The City is responsible for all regression testing and release management activities associated with the non-base functionality of the application as well as the integrated/interfaced 3rd party applications.

Richmond DPU is seeking a resource with experience with regression testing, specifically using the OUTA tool, with Oracle CCS system knowledge. The resource will lead regression testing activities to include, but not limited to, creation and execution of test scripts for regression testing. The resource will be paired with a business SME to assist in the business process scenarios for testing development and execution. The resource will also act in a mentor role for City resources who will be assigned to and shadow during testing preparation and execution to learn how OUTA functions to gain skills and competency in the tool's use. The intent is to have City internal resources learn hands-on with the tool to become comfortable and competent to take over the roles and responsibilities of regression testing at a later date.

Job Duties:

• Develop and maintain automation scripts using Oracle Utilities Testing Accelerator (OUTA) for functional, regression, and end-to-end testing
• Strong experience with OUTA, Groovy, Java, and XML
• Hands-on knowledge of Oracle Utilities Application Framework (OUAF)
• Familiarity with Azure DevOps, CCS Database Actions, SQL
• Hands-on knowledge of OIC
• Hands-on experience with Oracle CCS of Oracle Utilities Customer Cloud Services (CCS)
• Design reusable test assets and templates within the OUTA framework - including XML configuration files, data setup scripts, and test component definitions
• Implement and customize Groovy scripts within OUTA to handle dynamic data, validations, and conditional business logic
• Integrate OUTA with CI/CD pipelines (Azure DevOps), for automated regression execution and continuous delivery
• Perform data-driven testing by parameterizing input datasets to simulate real-world utility scenarios including business process scenarios for billing, payments, meter reads, adjustments, collections etc.
• Develop validation logic for UI screens, REST/SOAP web services, and integration endpoints within Oracle Integration Cloud (OIC)
• Generate and analyze execution reports from OUTA logs, identify failed cases, and provide root cause analysis for failures
• Collaborate with QA leads, functional testers, and developers to align automation scope with deliverables and release timelines
• Maintain test repositories and version control, ensuring proper branching and change tracking for automation assets
• Provide knowledge transfer and training to QA teams and internal resources on OUTA framework usage, best practices, and reporting mechanisms
• Support Oracle patch and upgrade testing (CCS Upgrades) using automation to validate regression stability

Preferred technical skills:

• Strong experience with OUTA, Groovy, Java, and XML
• Hands-on knowledge of Oracle Utilities Application Framework (OUAF)
• Familiarity with Azure DevOps