ETL / Data Automation/ Selenium Python QA Engineer

SE Mentor; Ernakulam; Hybrid; INR 1,200,000 - 2,200,000; Full time

Job summary

SE Mentor is seeking an experienced ETL / Data Automation / Selenium Python QA Engineer with 4+ years of hands-on experience validating complex data pipelines and building scalable test automation frameworks using Python and Pytest. You will ensure data accuracy, integrity, and performance across large-scale data warehouses and ETL layers.

Responsibilities include designing and executing end-to-end ETL tests, writing advanced SQL to audit datasets, and integrating automated tests into CI/CD

Qualifications

• 4+ years in Data QA, ETL Testing, or Data Automation.
• Proficient in SQL (window functions, joins) and data validation techniques.
• Strong Python scripting and Pytest for test automation.
• Experience with ETL/data warehousing concepts and schema testing.
• Familiar with Git and Jira for versioning and issue tracking.

Responsibilities

• Design, execute, and maintain end-to-end ETL test cases for data pipelines.
• Write advanced SQL queries to audit and reconcile large datasets.
• Build scalable data testing frameworks using Python and Pytest.
• Identify data anomalies and track schema changes with engineers.
• Integrate automated tests into CI/CD for continuous data quality.

Skills

Advanced SQL

Python

ETL Testing

Data Warehousing

Data Quality Assurance

Tools

Git

Jira

Pytest

Job description

We are seeking an experienced ETL / Data Automation/ Selenium Python QA Engineer with 4+ years of hands-on experience in validating complex data pipelines, writing advanced SQL queries, and building scalable test automation frameworks using Python and Pytest. In this role, you will ensure data accuracy, integrity, and performance across large-scale data warehouses and ETL processing layers.

Key Responsibilities

• ETL & Data Testing: Design, execute, and maintain end-to-end test cases for ETL processes, data integration, data pipelines, and data migration projects.
• Complex SQL Validation: Write advanced, highly optimized SQL queries to audit, reconcile, and validate large datasets across source and target systems.
• Automation Engineering: Build and scale data testing automation frameworks using Python and Pytest to automate repetitive data validation and pipeline checks.
• Defect & Data Quality Management: Identify, log, and track data anomalies, schema changes, and pipeline failures, collaborating closely with Data Engineers and Analytics teams.
• Data Verification: Validate data transformations, business logic, null checks, duplicate checks, boundary conditions, and schema integrity.
• CI/CD Integration: Integrate data automated tests into modern CI/CD pipelines to ensure continuous data quality monitoring.

Required Skills & Qualifications

• Experience: Minimum 4+ years in Data Quality Assurance, ETL Testing, or Data Automation.
• Advanced SQL: Expertise in writing complex SQL queries (window functions, subqueries, CTEs, heavy JOINs, performance tuning, and set operations).
• Programming & Frameworks: Strong proficiency in Python and hands-on experience with Pytest for creating data testing scripts.
• ETL & Data Warehousing: Deep understanding of ETL concepts, data warehousing principles (Star/Snowflake schemas), and source-to-target mapping.
• Database Systems: Experience working with relational databases (PostgreSQL, MySQL, MS SQL) or cloud data warehouses (Snowflake, Databricks, Redshift, BigQuery).
• Tools: Proficiency with version control systems (Git) and bug-tracking platforms (Jira).

Nice to Have

• Experience testing big data architectures (Apache Spark, PySpark, AWS S3).
• Familiarity with orchestration tools (Apache Airflow, Prefect).
• Basic exposure to cloud platforms (AWS, Azure, or GCP).

Work Location & Selection Process

• Primary Work Location: Kochi (Hybrid work environment).
• Final F2F Interview at the Kochi Office.