Engineer, TSG Software Quality Assurance

Department Icon Data Science Analytics & Machine Learning
Posted: 3 weeks ago
4-6 years
Gurugram, Haryana
Data Science Analytics & Machine Learning
work from office
Full Time
Closes 22 Dec 2026

Posted: 3 weeks ago
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Job Description

WHO YOULL WORK WITH

This position sits within an agile data engineering team, owning the quality of end-to-end data pipelines from source ingestion through medallion-layer transformation (Bronze/Silver/Gold) to BI/reporting consumption. The role suits someone who thinks like a data architect and builds/tests like an engineer, equally comfortable with pipeline design and hands-on SQL, PySpark, and automated data quality frameworks.

WHERE YOULL FIT WITHIN THE TEAM

The engineer independently owns the data testing strategy for their workstream, including a reusable SQL validation library usable for both manual and automated checks, and constructively challenges design or process decisions that risk data integrity or delivery quality. Works closely with Data Engineers, the QA Manager, Product/Project Managers, and business stakeholders.

WHAT YOULL DO

Requirement, Project and Business Understanding (20%)

  • Develop deep expertise in the data domain and business context source systems, transformation logic, medallion layers, and downstream BI consumption.
  • Build a thorough understanding of the pipeline lifecycle (ingestion → staging → transformation → curated/BI layer).
  • Review source-to-target mappings and transformation logic before test design begins.
  • Support the team on data QA methodologies and processes, with guidance from QA leadership.

Test Planning, Design, Execution, and Defect Management (35%)

  • Own the data testing strategy across full, incremental, delta, and historical loads, including insert/update/delete/cancel and effective-dated transactions.
  • Design and execute ETL/ELT validation, reconciliation, schema, null/completeness, and transformation test cases across the medallion architecture.
  • Validate pipelines end-to-end source through Databricks/ADF/Spark to final BI output, confirming numbers, aggregations, and business logic tie out.
  • Define and enforce data quality rules and build reusable checks; investigate anomalies and drive root-cause analysis with Data Engineers.
  • Manage the defect lifecycle and prepare test evidence, quality dashboards, and RCA reporting for release sign-off.

SQL Script & Automation Engineering (20%)

  • Build and maintain a structured, version-controlled Databricks/SQL validation queries usable standalone for manual checks and pluggable into automated regression/CI without rework.
  • Own inline maintenance of the library: refactor as schemas evolve, retire obsolete checks, keep naming and parameterization consistent, and document each scripts purpose, inputs, expected output, and edge cases so it stays usable by the wider team.
  • Set up and maintain automated data testing frameworks (e.g., Datagaps, PySpark-based checks) that consume the library for scheduled/CI-triggered runs.
  • Work with Data Engineers to wire validation into CI/CD, ensuring failures surface with actionable, traceable output.

Collaboration (15%)

  • Provide input into the test strategy mix (manual/automated/framework-driven) in partnership with QA leadership and data engineering.
  • Constructively challenge decisions that risk data quality or testability and propose practical alternatives.
  • Participate fully in agile ceremonies; raise risks and quality concerns early and clearly.
  • Partner with the business to understand the wider data system and act as a quality partner for delivery.

Leadership (10%)

  • Own data testing deliverables, including the health of the automation/SQL library, for the workstream.
  • Lead or contribute to QA initiatives that raise the bar on data testing practice across the team.
  • Mentor junior testers on ETL/data testing techniques, SQL standards, and automation tooling

ABOUT YOU

  • Strong understanding of ETL/ELT concepts, dimensional modeling, fact/dimension tables, and medallion architecture (Bronze/Silver/Gold), with the ability to trace a data point end-to-end into its BI report representation.
  • Hands-on proficiency with Azure SQL/Databricks/Apache Spark (PySpark) for large-scale data validation and transformation testing.
  • Working knowledge of Azure Data Factory (pipelines, linked services), Azure Storage (partitioning, Parquet/Delta), and third-party API integrations (e.g., Salesforce, etc.)
  • Advanced SQL for backend validation and reconciliation across SQL Server/PostgreSQL/Databricks, with emphasis on writing maintainable, reusable, parameterized scripts.
  • Working knowledge of Python for test scripting and validation automation.
  • Practical exposure to ETL/data quality tools, Datagaps DataOps Suite (good to have), or equivalent (DQX, QuerySurge, Informatica, Talend, DataStage, SSIS).
  • Ability to define and apply data quality rules systematically (completeness, accuracy, consistency, uniqueness, timeliness).
  • Hands-on experience with AI-assisted test generation or anomaly detection, with the ability to adapt checks for AI-produced and consumed data pipelines.
  • Comfort with Agile/Kanban delivery, CI/CD practices, and defect management tooling (JIRA, Azure Boards, or similar).
  • A curious, quality-first mindset confident to constructively challenge decisions when quality is at risk.
  • Strong written/verbal communication and stakeholder partnership skills; strong critical thinking and independent problem-solving.

Experience:

  • 4-6 years in data testing/automation, with hands-on ETL, Data Warehouse, and/or Big Data testing experience.
  • Proven experience testing pipelines on Databricks/Spark within a medallion or layered Lakehouse architecture.
  • Experience with Azure Data Factory and Azure cloud storage constructs.
  • Experience validating data through to BI/reporting layers (Power BI, Tableau, or similar), not just the warehouse layer.
  • Experience with data quality frameworks/rule design and writing SQL validation scripts reused across both manual testing and automated regression, ideally with exposure to a tool such as Datagaps.
  • Experience with SDLC/STLC, Agile ceremonies, and defect lifecycle management; prior ownership of a test strategy independently is strongly preferred.
  • Familiarity with AI-assisted testing or data validation tools

Skills

Data AnalyticsData ValidationBig DataPythonData IntegrityEtlAnalyticsAiSqlDatabricksQuality Assurance

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

Bain & Company India Careers 2025

Bain & Company is a global management consulting firm known for its deep client partnerships, results-driven approach, and collaborative culture. Founded in 1973 and headquartered in Boston, Bain entered the India market in 2006, with offices in New Delhi, Mumbai, and Bengaluru. It serves clients across private equity, consumer products, technology, financial services, and healthcare. Bain India is led by Karan Singh, and is widely regarded for its entrepreneurial culture, flat hierarchy, and impact-oriented case work.

Business Model – Bain operates as a project-based B2B advisory firm, delivering high-impact strategic consulting to CXOs, boards, and investors. Its revenue model is built on fee-based engagements across strategy, performance improvement, digital transformation, and due diligence. Bain differentiates itself through its Results Delivery® methodology, which ensures that recommendations are implemented, not just presented. The firm also runs Vector, its internal digital innovation engine, and the Bain Capability Network (BCN), which supports global teams from India.

Recent Wins & Recognition –

  • In 2025, Bain India co-published the India Venture Capital Report 2025, highlighting a 1.4x rebound in VC funding to $13.7B and the rise of generative AI investments across SaaS and fintech. (https://www.bain.com/insights/india-venture-capital-report-2025/)
  • Bain advised on multiple quick commerce and consumer tech megadeals, including Zepto and Lenskart, helping shape India’s evolving B2C landscape. (https://www.bain.com/insights/india-private-equity-report-2024/)
  • The firm’s Global M&A Report 2025 spotlighted how AI-driven deal sourcing and ESG filters are transforming investment strategies. (https://www.bain.com/insights/global-ma-report-2024/)
  • Bain India also expanded its BCN footprint, integrating advanced analytics and sustainability diagnostics into global case teams. (https://www.bain.com/about/global-offices/bain-capability-network/)

Culture & Values – Bain’s core values include client results, one-team collaboration, diversity, and integrity. The firm is known for its supportive work environment, global staffing model, and strong mentorship culture. Bain India actively promotes DEI, runs pro bono consulting for NGOs, and offers flexible career paths through programs like ExperienceBain and True North Sabbaticals.


Client-Facing Domains

Strategy Consulting

What it is – Bain’s flagship offering, focused on solving complex strategic problems for CXOs and boards. India-based roles include:

  • Corporate Strategy – Growth, market entry, pricing, and competitive positioning.
  • Business Transformation – Turnaround, cost optimization, and operating model redesign.
  • Customer Strategy – Loyalty, segmentation, and go-to-market planning.

Private Equity & M&A

What it is – Bain is the global leader in PE consulting, advising on 60%+ of major buyouts worldwide. India-based roles include:

  • Commercial Due Diligence – Pre-deal market and competitor analysis.
  • Post-Acquisition Strategy – Value creation plans and synergy realization.
  • Exit Planning – Strategic reviews and IPO readiness.

Digital & Innovation (Vector)

What it is – Bain’s tech-forward practice combining strategy with digital tools, AI, and design. India-based roles include:

  • Digital Transformation – Tech-enabled business model shifts.
  • Advanced Analytics – Predictive modeling, machine learning, and data strategy.
  • Innovation & Design – Product strategy, UX, and agile delivery.

Bain Capability Network (BCN)

What it is – Bain’s global support hub based in India, powering case teams with research, analytics, and diagnostics. India-based roles include:

  • Industry & Competitor Research – Market sizing, benchmarking, and trend analysis.
  • Data & Analytics – Excel modeling, Tableau dashboards, and KPI tracking.
  • Sustainability & ESG Diagnostics – Carbon footprint analysis and ESG scoring.


Internal Services

What it is – Bain’s enabling functions that support global operations and talent. India-based roles include:

  • Talent & HR – Recruiting, onboarding, and career development.
  • IT & Knowledge Management – Tech support, database access, and IP protection.
  • Finance & Operations – Budgeting, vendor management, and compliance.


Read More

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New Data Science Analytics & Machine Learning roles in Gurugram.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.