InfoBeans Technologies - ETL Quality Assurance Engineer - Databricks/Python

InfoBeans Inc.; Indore District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

InfoBeans Inc. is seeking a meticulous ETL QA Engineer to ensure data integrity across our Databricks platform. You will validate complex data pipelines using SQL and Python, with a focus on end-to-end data quality across Bronze, Silver and Gold layers.

Flexibility to overlap with US EST hours is required for real-time coordination. Key responsibilities include designing ETL test cases, executing advanced SQL queries, validating large datasets, and collaborating with global teams to deliver

Qualifications

• Proficiency in SQL for complex data validation and data quality checks.
• Python skills for data manipulation and test automation (PySpark, Pandas).
• Understanding ETL testing and data warehouse concepts is required.

Responsibilities

• Design, develop and execute ETL test cases for data pipelines.
• Run complex SQL queries to validate data across stages and layers.
• Test Bronze, Silver and Gold layers in Databricks architectures.
• Create and execute Python scripts for large-scale data validation.
• Design UI frontend test cases to verify software functionality.
• Identify, document and track defects; coordinate with developers for fixes.
• Participate in meetings and be available for US EST hours as needed.

Skills

SQL

Python

ETL testing

Data validation

Window functions

Tools

Databricks

Git

Job description

Job Title : ETL QA Tester with Python and Databricks experience

Summary

We are seeking a meticulous ETL QA Engineer to ensure data integrity across our Databricks platform. You will validate complex data pipelines using SQL and Python, working closely with global teams to deliver high-quality data solutions. This role requires flexibility to ensure overlap with US EST working hours for real-time coordination and team collaboration.

Key Responsibilities

• Design, develop, and execute ETL test cases to validate data extraction, transformation, and loading processes.
• Write and execute complex SQL queries to perform data validation between multiple hops.
• Medallion Architecture Testing: Validate data integrity as it moves through the Bronze, Silver, and Gold layers within Databricks.
• Write and execute advanced SQL and Python scripts to validate large datasets and identify defects.
• Design, develop, and execute UI Front end manual test cases to validate the functionalities of the software.
• Identify, document, and track defects, collaborate with developers to ensure timely resolution.
• Participate in project meetings and be available for discussions in US EST working hours as needed.

Required Skills & Advanced SQL: Proficiency in windows functions, complex joins and CTEs for deep data validation.

• ETL & DWH: Deep understanding of ETL and Data Warehouse concepts.

Good To Have

• Databricks Experience: Hands-on experience with Databricks Notebooks and cluster management.
• Programming: Strong skills in Python, specifically PySpark and Pandas for large-scale data manipulation.
• Cloud Platform Familiarity: Experience working within Azure or AWS environments.
• Agile Methodologies and Defect Tracking Tools: Experience with Jira for defect tracking and working with Agile/Scrum framework.
• CI/CD (Additional Plus): Familiarity with automated deployment pipelines and version control (Git).

(ref:hirist.tech)