Sr Quality Analyst - ETL Tester

Beghou; Hyderabad; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Beghou Consulting in Hyderabad, India seeks an ETL Tester with 3–5 years in ETL/Data Warehouse testing to ensure data accuracy across pipelines. You will design test scenarios, write advanced SQL, validate transformations, and collaborate with data engineers and business analysts in an Agile team.

Qualifications include strong SQL, DW concepts, experience with Databricks or Snowflake, Unix/Linux, and defect tracking tools like Jira/Azure DevOps/GitHub; familiarity with APIs and automation is a

Qualifications

• 3–5 years in ETL/Data Warehouse testing and validation.
• Strong SQL skills including joins, subqueries, and window functions.
• Experience with DW concepts and data quality testing.
• Familiarity with Databricks or Snowflake and Unix/Linux commands.
• Proficient in defect tracking tools (Jira/Azure DevOps/GitHub) and Agile/Scrum.
• Knowledge of APIs and automation is a plus.

Responsibilities

• Validate ETL workflows from extraction to loading into the data warehouse.
• Design test scenarios and execute source-to-target data validations.
• Write complex SQL to verify data accuracy and transformations.
• Test data transformation rules and business logic.
• Perform functional, regression, integration, and data quality testing.
• Log and track defects using Jira, Azure DevOps, or GitHub and collaborate with engineers.

Skills

SQL

ETL Testing

DW Concepts

Unix/Linux

Jira

Azure DevOps

GitHub

Agile/Scrum

APIs

Automation

Tools

Databricks

Snowflake

Job description

Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and building foundational data analytics infrastructures to leveraging artificial intelligence to improve customer insights and engagement, Beghou helps life sciences companies maximize performance across their portfolios. Beghou also deploys proprietary and third-party technology solutions to help companies forecast performance, design territories, manage customer data, organize, and report on medical and commercial data, and more. Headquartered in Evanston, Illinois, we have 10 global offices.
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

Nice-to-Have Skills

• Python or PySpark
• Cloud platforms (Azure, AWS, GCP)
• CI/CD tools (Jenkins, Git)
• Big Data testing (Hive, Hadoop, Spark)

At Beghou Consulting, you'll join a highly collaborative, values-driven team where technical excellence, analytical rigor, and personal growth converge. Whether you're passionate about AI innovation, building commercialization strategies, or shaping the next generation of data-first solutions in life sciences, this is a place to make an impact!
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.