Oracle QA Automation Engineer
Indexed description
Location: Addison, Texas (Hybrid)
Employment Type: Contract
Contract Duration: 12 Months
Role Overview
We are seeking an Onshore Database Developer to contribute to a significant MCL Upgrade project. This role focuses on Oracle SQL/PLSQL development, automation testing, and ETL/database testing. The position requires a candidate with strong technical skills in database development and quality assurance to ensure the performance, reliability, and integrity of our database systems.
Key Responsibilities
- Develop complex queries, stored procedures, packages, functions, and triggers using Oracle SQL and PL/SQL.
- Troubleshoot and resolve database performance issues through SQL tuning, query optimization, and indexing strategies.
- Create and maintain database objects, including tables, views, indexes, sequences, and materialized views.
- Develop and maintain automated test scripts for functional, regression, integration, and end-to-end testing.
- Execute test plans, design test cases, track defects, and manage the test execution process.
- Perform ETL and database testing, including data validation, data reconciliation, and source-to-target mapping verification.
- Validate ETL processes, data transformations, and data integrity across multiple systems.
- Collaborate with business, development, and QA teams within an Agile/Scrum environment.
- 5+ years of experience in Oracle SQL and PL/SQL development and performance tuning.
- 3+ years of experience in automation testing using industry-standard tools and frameworks.
- 3+ years of experience in ETL and database testing, including data validation and reconciliation.
- Strong understanding of relational database concepts, data modeling, and Oracle database architecture.
- Experience with test planning, test case design, and defect tracking.
- Proficiency in backend testing using SQL queries on large datasets.
- Familiarity with ETL tools such as Informatica, DataStage, or SSIS.
- Experience working in Agile/Scrum environments and with the software development lifecycle (SDLC).
- Strong analytical, troubleshooting, and problem-solving skills.
- Experience with API testing tools such as Postman, ReadyAPI, or REST Assured.
- Familiarity with CI/CD tools like Jenkins, GitHub, or Azure DevOps.
- Knowledge of data migration, data governance, and data quality frameworks.
- Experience with version control tools such as Git or Bitbucket.
- Ability to work independently and manage multiple priorities to meet project timelines.
Everforth Apex Systems is part of the Commercial Segment of Everforth, Inc.
NYSE: EFOR
4400 Cox Road
Suite 200
Glen Allen, Virginia 23060
Everforth Apex is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at [email protected] or 804-523-8228. (Do not submit resumes or solicit consultants to this email address). UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search