- Company Name
- Atlantis IT Group
- Job Title
- Senior Automation Engineer – SQL - Banking Domain
- Job Description
-
Job title: Senior Automation Engineer – SQL – Banking Domain
Role Summary: Lead the design, development, and maintenance of automated test frameworks for banking applications, focusing on UI, API, and backend SQL validation, while integrating with CI/CD pipelines and supporting continuous improvement.
Expactations: Deliver robust, scalable automation solutions; ensure data integrity of financial transactions; collaborate with product, dev, and ops teams; maintain high defect detection rates; contribute to process and tooling enhancements.
Key Responsibilities:
- Design and implement automation frameworks using Selenium, Playwright, Cypress, and Rest Assured.
- Develop and execute UI, API, and backend test scripts covering banking transactions, payments, lending, and wealth systems.
- Write complex SQL queries for data validation: finding second highest values, employee–manager hierarchy, table reconciliation, conditional matching, and ledger verification.
- Integrate tests with Jenkins, Azure DevOps, or GitLab CI for continuous testing.
- Participate in Agile ceremonies and collaborate closely with development, business analysis, and QA teams.
- Provide defect analysis, root‑cause investigations, and recommend improvements.
- Maintain documentation of test cases, procedures, and results.
Required Skills:
- 7+ years of QA Automation experience in Banking/Financial Services.
- Proficiency in SQL (joins, subqueries, window functions, advanced data comparison).
- Expertise in Selenium, Playwright, Cypress, and Rest Assured for UI and API automation.
- Hands‑on experience with CI/CD pipelines and version control (Git).
- Familiarity with JIRA, Zephyr, and ALM tools.
- Knowledge of relational database concepts, data integrity rules, and financial transaction flows.
Required Education & Certifications:
- Bachelor’s degree in Computer Science, Software Engineering, or related field.
- Professional certifications such as ISTQB Advanced Test Automation Engineer, Certified Selenium Professional, or equivalent are advantageous.