Job Title: UI & ETL Automation Tester
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
- 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.
