ETL Automation Testing

Digitrix Software LLP; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Digitrix Software LLP is seeking an experienced ETL Automation Tester in Bengaluru with strong Python and SQL skills. The role focuses on validating data pipelines, ensuring data accuracy, and building automation frameworks for ETL processes.

Responsibilities include designing automated tests, validating data integrity, optimizing SQL queries, and collaborating with stakeholders. Leadership will be considered for senior roles, with client-facing interactions as part of the job.

Qualifications

• Experience in ETL testing and database testing.
• Proficient in SQL including joins and subqueries.
• Hands-on Python for automation and scripting.
• Experience with Selenium for UI automation testing.
• Strong understanding of data warehousing and ETL workflows.
• Analytical and problem-solving capabilities; able to debug data issues.

Responsibilities

• Design, develop, and execute automated test scripts for ETL processes using Python.
• Perform ETL/Database testing to validate data integrity and transformation logic.
• Write and optimize SQL queries for data validation.
• Collaborate with developers and analysts to define test strategies.
• Log, track, and help resolve defects in a timely manner.
• Monitor and improve test automation frameworks for performance and scalability.
• Lead testing efforts for senior/lead roles, including planning and reporting.
• Engage with clients to provide updates and handle queries.

Skills

ETL Testing

SQL proficiency

Python automation

Selenium Automation

Data warehousing concepts

Analytical thinking

Leadership (Lead role)

Tools

Selenium Automation

CI/CD tools

Git

AWS/Azure

Job description

We are looking for a skilled ETL Automation Tester with strong expertise in Python and database testing. The ideal candidate will be responsible for validating data pipelines, ensuring data accuracy, and building automation frameworks for ETL processes. This role requires strong technical capabilities along with excellent communication and client-facing skills.

Key Responsibilities

• Design, develop, and execute automated test scripts for ETL processes using Python
• Perform ETL/Database testing to validate data integrity, transformation logic, and data migration.
• Write and optimize complex SQL queries for data validation and analysis.
• Collaborate with developers, business analysts, and stakeholders to understand requirements and define test strategies.
• Identify, log, and track defects, ensuring timely resolution.
• Monitor and improve test automation frameworks for performance and scalability.
• Lead testing efforts (for senior/lead roles), including planning, execution, and reporting.
• Participate in client interactions, providing updates and handling queries effectively.

Required Skills

• Strong experience in ETL Testing / Database Testing
• Proficiency in SQL (joins, subqueries, data validation)
• Hands-on experience in Python for automation
• Experience with Selenium Automation
• Good understanding of data warehousing concepts and ETL workflows
• Strong analytical and problem-solving skills

Preferred Skills

• Exposure to CI/CD tools and version control (Git)
• Knowledge of cloud platforms (AWS/Azure) is a plus

Soft Skills

• Strong client-facing experience
• Leadership abilities (for Lead role)
• Ability to work in a fast-paced environment