Sr Quality Analyst - ETL Tester
At a glance
Senior Data Engineering role at Beghou Consulting. Hyderabad.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Check ETL flows from extraction through warehouse loading, validating records against their source data
- Build and run test scenarios that catch duplicates, missing values, and broken relationships
- Use advanced SQL to verify data accuracy and check transformation rules against business logic
- Run functional, regression, integration, and data-quality tests, then record and follow defects
- Work with engineers and analysts on UAT and production checks within an Agile team
What you bring
- You have three to five years of experience testing ETL or data warehouse systems
- You can write SQL using joins, nested queries, window functions, and aggregations
- You understand ETL testing and warehouse structures such as fact and dimension tables or star schemas
- You have used Databricks or Snowflake, along with Unix or Linux commands
- You know Agile or Scrum practices and have worked with a defect-tracking tool such as Jira
Who this fits
This role suits a detail-focused tester who enjoys tracing data issues and wants to develop toward cloud, Big Data, or automated testing. The position is based in Hyderabad and follows a hybrid arrangement.
From the employer
Our mission is to bring together analytical minds and innovative technology to help life sciences companies navigate the complexity of health care and improve patient outcomes.
Purpose of Job:
As an ETL Tester, you will play a critical role in ensuring the accuracy, consistency, and reliability of data as it moves through our ETL pipelines — from extraction and transformation through to loading into the data warehouse. You'll be responsible for designing test scenarios, executing source-to-target validations, and writing advanced SQL queries (joins, subqueries, window functions, aggregations) to catch data quality issues such as duplicates, nulls, and referential integrity gaps before they reach production. Working within an Agile team, you'll partner with data engineers, and business analysts to validate transformation logic and business rules, support UAT and production validation, and track defects through tools like Jira or Azure DevOps or GitHub. This role is ideal for someone with 3–5 years of ETL/DW testing experience who thrives on precision, enjoys solving data puzzles, and wants to grow into cloud, Big Data, or automation-driven testing.
We'll trust you to:
- Validate ETL workflows (Extract, Transform, Load).
- Create and execute test cases and test scenarios.
- Perform source-to-target data validation.
- Write complex SQL queries to verify data accuracy.
- Test data transformation rules and business logic.
- Perform functional, regression, integration, and data quality testing.
- Log and track defects using tools like Jira or Azure DevOps or GitHub.
- Work closely with ETL developers, data engineers, and business analysts.
- Support UAT and production validation.
You'll need to have:
- Strong SQL (joins, subqueries, window functions, aggregations)
- ETL testing concepts
- Data Warehouse concepts (Fact & Dimension tables, Star/Snowflake schema)
- Working experience with Databricks, or Snowflake
- Unix/Linux commands
- Defect tracking tools (Jira, Azure DevOps, GitHub)
- Knowledge of Agile/Scrum methodology
- Basic understanding of APIs and automation is an added advantage.
- 3–5 years in ETL/Data Warehouse testing
- Python or PySpark
- Cloud platforms (Azure, AWS, GCP)
- CI/CD tools (Jenkins, Git)
- Big Data testing (Hive, Hadoop, Spark)
Nice-to-Have Skills