SR Automation TOSCA DI Lead

Job Summary

We are looking for an experienced Test Automation Engineer with strong hands-on expertise in Tricentis TOSCA Data Integrity (TOSCA DI) along with UI test automation using Playwright.

The ideal candidate will have experience in ETL/Data Warehouse testing, backend/database validation, complex SQL queries, and end-to-end test automation. The candidate should be comfortable validating data across source and target systems while also developing and maintaining UI automation tests.

Key Responsibilities

• Design, develop, and execute automated tests using TOSCA Data Integrity (DI).
• Perform ETL, Data Warehouse, backend, and data validation testing.
• Build and maintain UI automation tests using Playwright.
• Perform source-to-target validation, data reconciliation, transformation testing, and data-quality testing.
• Write complex SQL queries for database testing and validation.
• Validate data across databases such as Oracle, Snowflake, SQL Server, or PostgreSQL.
• Develop reusable and maintainable automation test scripts and frameworks.
• Perform API testing using tools such as Postman or Bruno.
• Execute backend processes and ETL jobs using Unix/Linux commands, PuTTY, and WinSCP, where required.
• Integrate automated testing into CI/CD pipelines and support continuous testing.
• Analyze business and technical requirements and create test scenarios, test cases, and automation coverage.
• Manage defects using JIRA and work closely with developers and business teams through resolution.
• Participate in Agile ceremonies and provide clear testing status and quality updates.
• Identify opportunities to increase automation coverage and reduce manual testing.

These responsibilities align closely with the prior Nationwide requirements for TOSCA DI, ETL testing, SQL, database validation and automation

Required Skills

• Strong hands-on experience with Tricentis TOSCA
• Strong hands-on experience with TOSCA Data Integrity (DI)
• Playwright UI Automation
• ETL / Data Warehouse Testing
• Backend Testing
• Advanced SQL and database validation
• Source-to-target data validation
• Data reconciliation and transformation testing
• Oracle, Snowflake, SQL Server, PostgreSQL, or similar databases
• API Testing using Postman, Bruno, or similar tools
• Test planning and defect management
• JIRA
• CI/CD and continuous testing
• Agile/Scrum experience
• Strong communication and customer-facing skills

Good to Have

• Python / PyTest
• JavaScript or TypeScript for Playwright
• Selenium or other UI automation frameworks
• AWS or other cloud platforms
• Harness, Jenkins, Azure DevOps, or GitHub Actions
• Unix/Linux
• PuTTY and WinSCP
• AI-assisted testing or experience testing AI applications
• Insurance or financial services domain experience