InfoBeans Technologies - Python Automation Engineer - ETL/Datawarehouse Testing

InfoBeans; Indore District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

InfoBeans is seeking an experienced Python Automation Engineer to validate application functionality, test ETL pipelines, and ensure data accuracy across enterprise databases and data platforms.

You will design automated and manual test cases, develop Python-based automation scripts (Playwright preferred), perform backend and data validation, and coordinate with global teams across EST working hours.

Qualifications

• 6-10 years of software testing or data engineering experience.
• Hands-on Python programming and automation scripting.
• Experience with Python-based test frameworks, preferably Playwright.
• Strong SQL skills with complex queries and optimization.
• Experience in data testing, backend testing, and ETL validation.
• Knowledge of data warehousing concepts and data processing workflows.
• Experience with Oracle, Denodo, Azure Databricks, or SQL Server.
• Ability to design test scenarios, manage defects, and perform regression testing.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration across distributed teams.

Responsibilities

• Design, develop, and execute automated and manual test cases to validate functionality.
• Develop and maintain Python-based automation scripts and frameworks (Playwright preferred).
• Design and execute test cases to validate ETL processes.
• Perform backend and data validation using complex SQL queries.
• Write, optimize, and execute SQL queries for data reconciliation and testing.
• Validate data pipelines and source-to-target mappings.
• Test apps and data workflows across databases and modern platforms.
• Document, report, and track defects and coordinate resolution.
• Analyze failures, perform root-cause investigation, and support regression testing.
• Clarify requirements with stakeholders to ensure test coverage.
• Participate in meetings, test planning, and quality reviews.
• Maintain test data, execution results, defects, and automation scripts.
• Collaborate with distributed teams and support US EST working hours.

Skills

Python programming

Playwright

SQL

Data testing

ETL validation

Test automation

Data validation

Backend testing

Regression testing

Communication

Tools

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.

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)