InfoBeans Technologies - Python Automation Engineer - ETL/Datawarehouse Testing

InfoBeans; Indore; On-site; INR 1,700,000 - 2,300,000; Full time

Job summary

InfoBeans is seeking an experienced Python Automation Engineer to validate application functionality, ETL pipelines, and data integrity across databases and platforms. You will design automated and manual tests, develop Python scripts (Playwright), and perform complex SQL-based data validation.

The role requires 6–10 years in testing, strong Python skills, and experience with data warehousing concepts and modern data platforms. Collaboration with global teams and ET-hour support are expected.

Qualifications

• 6–10 years of software testing, test automation, data testing, or quality engineering.
• Strong hands-on Python programming and automation scripting.
• Experience with Python-based test automation frameworks, preferably Playwright.
• Strong SQL skills with complex queries, joins, subqueries, aggregations and optimization.
• Hands-on data testing, backend testing and ETL validation.
• Knowledge of data extraction, transformation, loading, and source-to-target validation.
• Familiarity with data warehousing concepts and data processing workflows.
• Experience with Oracle, Denodo, Azure Databricks, or SQL Server.

Responsibilities

• Design, develop, and execute automated and manual test cases to validate functionality and requirements.
• Develop and maintain Python automation scripts and frameworks (Playwright preferred).
• Create test cases to validate ETL processes and data transformations.
• Execute backend and data validation using complex SQL queries.
• Validate data pipelines and source-to-target mappings across platforms.
• Document, report, and track defects; coordinate with dev and data teams for fixes.
• Collaborate with distributed teams and participate in EST/ET working hours.

Skills

Python programming

Test automation

Data testing

SQL

ETL validation

Data warehousing

Dimensional modeling

Analytical thinking

Communication

Tools

Playwright

Oracle

Denodo

Azure Databricks

SQL Server

Job description

About The Role

We are looking for an experienced Python Automation Engineer with strong expertise in Python scripting, SQL, test automation, and data validation. The role involves validating application functionality, testing ETL pipelines and data transformations, and ensuring data accuracy across enterprise databases and data platforms.

Key Responsibilities

• Design, develop, and execute automated and manual test cases to validate application functionality and business requirements.
• Develop and maintain Python-based automation scripts and frameworks, preferably using Playwright.
• Design and execute test cases to validate data extraction, transformation, and loading (ETL) processes.
• Perform backend and data validation using complex SQL queries to verify data accuracy, completeness, consistency, and integrity.
• Write, optimize, and execute SQL queries for data reconciliation, transformation validation, and database testing.
• Validate data pipelines, source-to-target mappings, business rules, and data transformation logic.
• Test applications and data workflows across relational databases, data warehouses, and modern data platforms.
• Identify, document, report, and track defects through their lifecycle, coordinating with development and data engineering teams for resolution.
• Analyze test failures, perform root-cause investigation, and support defect resolution and regression testing.
• Clarify requirements with business analysts, developers, and stakeholders to ensure comprehensive test coverage.
• Participate in project meetings, test planning, requirement discussions, and quality reviews.
• Maintain test documentation, test data, execution results, defect reports, and automation scripts.
• Collaborate with distributed teams and be available for discussions during US Eastern Time (EST/ET) working hours, as required.

Required Skills & Experience

• 6 - 10 years of experience in software testing, test automation, data testing, or quality engineering.
• Strong hands-on experience with Python programming and automation scripting.
• Experience with Python-based test automation frameworks, preferably Playwright.
• Strong SQL skills, including complex queries, joins, subqueries, aggregations, and query optimization.
• Hands-on experience in data testing, backend testing, and ETL validation.
• Good understanding of data extraction, transformation, loading, data reconciliation, and source-to-target validation.
• Familiarity with data warehousing concepts, dimensional modelling, and data processing workflows.
• Experience working with one or more database or data platforms such as Oracle, Denodo, Azure Databricks, or SQL Server.
• Experience designing test scenarios, executing test cases, managing defects, and performing regression testing.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills and the ability to collaborate with cross-functional and geographically distributed teams.
• Flexibility to support discussions during US Eastern Time working hours, as required.

(ref:hirist.tech)