We are seeking an experienced Automation Consultant with robust hands-on expertise in WebdriverIO (WDIO) , TypeScript/JavaScript , API automation , and Oracle database querying . The ideal candidate will be responsible for designing, developing, and maintaining robust automation frameworks with deep integration across UI, API, and database layers , ensuring high-quality, reliable, and scalable test solutions for complex enterprise systems.

Key Responsibilities

Automation & Testing

- Design, develop, and maintain end-to-end automation frameworks using WebdriverIO (WDIO) with TypeScript/JavaScript
- Implement data-driven, reusable, and modular automation components
- Execute automation across UI, API, and Database layers
- Ensure high test coverage, stability, and maintainability of automation suites
- Integrate automation into CI/CD pipelines

API Automation

- Develop and execute API automation tests using Axios, REST clients, or similar libraries
- Validate request/response payloads, headers, authentication, and error handling
- Perform end-to-end validations between API responses and database records
- Test RESTful services using JSON , HTTP methods , and status codes

Database Testing (Oracle)

- Write complex Oracle SQL queries for data validation and backend testing
- Perform data setup, verification,



and cleanup to support automated tests
- Validate business logic by comparing API/UI results with Oracle DB data
- Work closely with backend and ETL teams to ensure data accuracy

Consulting & Collaboration

- Act as a technical consultant , providing automation best practices and guidance
- Collaborate with developers, DevOps, business analysts, and QA teams

Required Skills & Qualifications

Technical Skills (Must Have)

- Strong experience with WebdriverIO (WDIO)
- Proficient in TypeScript and JavaScript
- Solid experience in API automation (Axios or similar tools)
- Strong expertise in Oracle SQL queries (joins, subqueries, performance considerations)
- Hands-on experience with automation involving databases and APIs
- Understanding of REST APIs , JSON, and HTTP protocols
- Experience with Git and source control practices

Additional Skills (Nice to Have)

- Experience with BDD frameworks (Cucumber)
- Familiarity with CI/CD tools (Jenkins, GitHub Actions)
- Knowledge of Node.js

Soft Skills

- Strong analytical and problem-solving skills
- Excellent communication and stakeholder-facing abilities
- Ability to work independently in a consulting environment
- Strong attention to detail and quality mindset

📌 Automation Specialist (Canada)
🏢 Teacup Tech Systems
📍 Canada