UI & ETL Automation Tester

Job Title: UI & ETL Automation Tester

Location: Mumbai / Hybrid

Experience: 47 years

Employment Type: Full-time

Role Overview

We are seeking a UI & ETL Automation Tester with strong experience validating web applications and enterprise data pipelines across on-premise and cloud platforms. The role requires hands-on expertise in UI automation testing, ETL/data validation using SQL, and Python scripting, with exposure to AWS and Databricksbased data platforms.

Key Responsibilities

UI Testing & Automation

• Design, develop, and maintain automated UI test scripts for applications built using Angular (14+) and/or Vue.js.
• Perform functional, regression, and end-to-end testing using automation-first approaches.
• Validate cross-browser compatibility and responsive UI behavior across desktop and mobile devices.
• Analyze UI defects, ensure proper root cause identification, and collaborate with developers for fixes.
• Maintain stable, reusable, and scalable UI automation frameworks.

• Perform ETL testing for data pipelines running on on-premise ETL platforms and cloud-based architectures.
• Validate data movement across source, staging, and target layers.
• Write and execute advanced SQL queries to validate:
• Data transformations and business rules
• Aggregations, joins, and calculations
• Record counts and reconciliation checks
• Test full loads, incremental loads, and data refresh processes.
• Validate data processing and transformations executed on Databricks.

• Use Python to automate data validation, reconciliation, and repetitive ETL testing tasks.
• Perform API testing using tools like Postman to validate backend services and integrations.
• Integrate UI and data validation checks into automated test suites where applicable.
• Support test execution and reporting in Agile delivery cycles.

UI Automation

• Strong experience in UI automation testing
• Hands-on with Cypress, Selenium, Playwright, or Protractor
• Experience testing applications built using Angular (14+) and/or Vue.js

• Strong hands-on experience testing on-premise ETL systems and cloud-based ETL pipelines
• Advanced SQL skills for data validation and reconciliation
• Solid understanding of ETL concepts, data transformations, and data warehousing

• Experience working with AWS-based data platforms
• Hands-on exposure to Databricks for data validation and testing
• Understanding of cloud data processing workflows

• Proficiency in Python for automation and data testing
• Experience working in Agile/Scrum environments
• Familiarity with Git and version control workflows

• Cloud experience on AWS, Azure, or GCP.
• Experience with test automation in CI/CD pipelines.
• Prior experience in data-intensive or analytics-driven projects.