Description

You will own data integrity validation across ETL pipelines using Python automation and advanced SQL.

This role is hybrid.

Responsibilities

• Design, develop, and execute ETL test cases for data extraction, transformation, and loading.
• Write and optimize complex SQL queries for backend data validation and reconciliation.
• Identify, report, and track defects systematically using JIRA.
• Clarify requirements and ensure comprehensive test coverage for all data processes.
• Align with US EST working hours for project meetings and collaboration.

Required Skills

• 8+ years of professional experience in software testing.
• Strong Advanced SQL skills, including query optimization.
• Hands-on ETL testing experience covering data extraction, transformation, and loading.
• Proficiency in Python and Pytest for automation.
• Experience with UI Automation (Playwright) and API Automation (Rest Assured).
• Familiarity with SQL DBMS tools: Oracle, Denodo, Azure Databricks, or SQL Server.
• Knowledge of data warehouses, data lakes, and Agile methodologies.

Preferred Skills

• Experience performing data validation across large-scale datasets.

Key Skills

Education

Any Graduate