Location: Mumbai / Hybrid
Experience: 4–7 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 Databricks–based 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.
ETL & Data Testing
-
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
-
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.
-
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.
Automation, Scripting & Integration
-
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.
Required Skills & Experience
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
ETL & Data Testing
-
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
Cloud & Platform Exposure
-
Experience working with AWS-based data platforms
-
Hands-on exposure to Databricks for data validation and testing
-
Understanding of cloud data processing workflows
Scripting & QA Practices
-
Proficiency in Python for automation and data testing
-
Experience working in Agile/Scrum environments
-
Familiarity with Git and version control workflows
Preferred (Nice to Have)
-
Cloud experience on AWS, Azure, or GCP.
-
Experience with test automation in CI/CD pipelines.
-
Prior experience in data-intensive or analytics-driven projects.
