Closed listing
Oracle DB Manual & Automation Tester
- Toronto, ON, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Experience
- 7+ years of QA/testing experience with strong Oracle Database Testing expertise.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Oracle DB Manual & Automation Tester
Location: Toronto, Canada
Job Overview
We are seeking an experienced Oracle Database Tester with strong expertise in manual and automation testing, Oracle SQL, database validation, backend/API testing, and data reconciliation. The candidate will support enterprise banking applications and data platforms in an Agile environment.
Key Responsibilities
- Perform end-to-end Oracle database testing covering tables, views, stored procedures, functions, triggers, packages, and data validation.
- Develop complex Oracle SQL queries for data validation, reconciliation, transformation, and business-rule testing.
- Execute functional, regression, integration, system, UAT, and database testing.
- Perform ETL and source-to-target data validation.
- Create and maintain database test cases, test scripts, and automation frameworks.
- Automate database/API test scenarios using Selenium, Java/Python, REST Assured, Postman, or Tosca.
- Perform backend and API testing across upstream and downstream systems.
- Identify defects, perform root-cause analysis, and coordinate resolution with development teams.
- Integrate automation testing with CI/CD pipelines using Jenkins, GitLab, Azure DevOps, or similar tools.
- Collaborate with BAs, Developers, Data Engineers, and QA teams in an Agile/Scrum environment.
Mandatory Skills
- 7+ years of QA/testing experience with strong Oracle Database Testing expertise.
- Strong hands-on Oracle SQL and database validation skills.
- Expertise in tables, views, stored procedures, functions, triggers, joins, complex queries, and data reconciliation.
- Strong experience in both Manual and Automation Testing.
- Hands-on API and backend testing experience.
- Experience with Selenium, Java/Python, Tosca, REST Assured, or Postman.
- Strong knowledge of STLC, SDLC, defect lifecycle, regression, integration, and UAT testing.
- Banking/Financial Services experience, preferably with Canadian banking clients.
- Strong analytical, troubleshooting, communication, and stakeholder-management skills.
Good to Have
- ETL/Data Warehouse Testing experience.
- Knowledge of Unix/Linux, Jenkins, Git, Jira, and CI/CD.
- Experience with Oracle data migration and reconciliation testing.
- Experience testing large-scale enterprise banking applications.
More about this job
Responsibilities
The candidate will perform end-to-end Oracle database testing, including data validation, reconciliation, and backend/API testing. They will also develop automation frameworks and integrate testing processes into CI/CD pipelines within an Agile environment.
Requirements
The role requires over 7 years of QA experience with deep expertise in Oracle SQL, database validation, and automation tools like Selenium or Tosca. Candidates should have a strong background in banking or financial services and proficiency in STLC and SDLC methodologies.
Skills
- Oracle SQL
- Manual Testing
- Automation Testing
- Database Validation
- API Testing
- Data Reconciliation
- Selenium
- Java
- Python
- REST Assured
- Postman
- Tosca
- ETL Testing
- CI/CD
- Agile
- Banking Domain
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Finance & Accounting
- Software
- Data & Analytics
Keywords
- Oracle Database
- SQL
- Manual Testing
- Automation Testing
- API Testing
- Data Reconciliation
- ETL
- Selenium
- Java
- Python
- REST Assured
- Postman
- Tosca
- CI/CD
- Jenkins
- GitLab
- Azure DevOps
- Agile
- Scrum
- Banking
- Financial Services
- Data Validation
- Stored Procedures
- Regression Testing
- UAT
- Unix
- Linux
- Jira
- Data Warehouse
- Backend Testing