2+ ETL QA Jobs in Delhi, NCR and Gurgaon | ETL QA Job openings in Delhi, NCR and Gurgaon

Responsibilities

Design and execute ETL test scenarios, test cases and test scripts based on business and technical requirements.

Validate source-to-target data mapping, transformation rules, business rules and data flows.

Perform ETL, Data Warehouse and Database Testing across multiple data sources and target systems.

Validate data extraction, transformation, loading and reconciliation processes.

Perform data validation, data completeness, data accuracy and data integrity testing.

Write complex SQL queries for backend data validation, reconciliation and defect analysis.

Validate source-to-target mappings and identify data discrepancies. Perform database testing involving joins, stored procedures, views, functions, indexes and constraints.

Test incremental loads, full loads, CDC and batch processing where applicable.

Validate ETL workflows, schedules, dependencies and error-handling mechanisms.

Perform data reconciliation between source and target systems and investigate mismatches.

Validate duplicate records, missing records, null values, data truncation and transformation errors.

Execute regression, integration, system and end-to-end testing for ETL/data pipelines.

Validate large-volume datasets and perform data quality and consistency checks.

Work with developers, data engineers, business analysts and product teams to resolve data-related issues.

Analyze ETL job failures and assist development teams with root-cause analysis (RCA). Log, track and manage defects using tools such as Jira, Azure DevOps or similar.

Prepare test execution reports, defect reports and testing status updates.

Participate in requirement analysis, test planning, estimation and defect triage meetings.

Support UAT, production validation and post-release data verification.

Ensure testing complies with enterprise data governance, security, privacy and quality standards.

Work in an Agile/Scrum environment and participate in sprint planning, daily stand-ups, reviews and retrospectives.

Collaborate with globally distributed teams and stakeholders across business and technology functions.

Understand insurance-domain data such as policy, customer, claims, billing, premium and financial data is an advantage.

Requirements

4–6 years of hands-on experience in ETL Testing / Data Warehouse Testing / Database Testing.

Strong understanding of ETL concepts, data warehousing and data integration processes.

Strong hands-on SQL skills including complex joins, subqueries, CTEs, aggregations and data reconciliation queries.

Experience with ETL tools such as Informatica, IBM DataStage, SSIS, Talend, Azure Data Factory or similar.

Experience testing large-volume data and enterprise data pipelines. Good understanding of Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension tables.

Strong knowledge of source-to-target mapping and transformation validation.

Experience with Oracle, SQL Server, DB2, PostgreSQL or other relational databases.

Knowledge of batch processing, scheduling, incremental/full loads and data migration testing.

Experience with API, web service or downstream application data validation is preferred.

Good understanding of SDLC, STLC, defect lifecycle and Agile methodologies.

Experience with Jira, Azure DevOps, ALM or similar test/defect management tools.

Exposure to cloud data platforms such as Azure/AWS is an added advantage.

Exposure to Python or scripting for test-data validation/automation is desirable.

Knowledge of data quality, reconciliation, data lineage and data governance.

Strong analytical and problem-solving skills with the ability to investigate complex data issues.

Excellent communication and stakeholder-management skills.

Prior experience in Insurance, BFSI or other regulated enterprise environments will be highly preferred.

Review Criteria:

Mandatory:

• Strong UAT / Functional Test Lead Profiles
• Must have minimum 7 years of overall testing experience, with at least 3 years of recent UAT experience, primarily in manual testing for large enterprise or government project
• Must have worked on minimum 2 national-level e-Governance, public sector, enterprise, or marketplace projects in a UAT lead or ownership role
• Must have 3+ years of team handling experience, leading 7–8 QA/UAT members, including task assignment, review, mentoring, and delivery ownership
• Must have complete ownership of UAT activities, including UAT planning, execution, acceptance sign-off, defect management, retesting, and regression cycles.
• Must have strong hands-on manual testing experience, with the ability to create test scenarios and test cases from BRDs, user stories, functional documents, and Figma/UI screens.
• Must be able to understand HLD/LLD documents and API specifications and perform manual API testing based on business logic.
• Must have BE/BTech/MTech/MBA (BSc/BCA alone is not acceptable; with Bsc/BCA candidates must have a relevant postgraduate degree MCA/MTech)

Preferred:

• ISTQB Advanced Test Manager or equivalent is preferred

Ideal Candidate:

• 8 + years’ experience in UAT, with at least 2 National-level e-Governance solutions / Enterprise platforms / Marketplace projects.
• Proficiency in test planning, execution oversight, acceptance criteria definition, defect triage, regression cycle management.
• Proficient in understanding business requirements by going through BRDs, User Stories, Figma screens to define test scenarios and test cases.
• Ability to analyze high level and low-level design documents, API specifications to identify the business logic developed and create test cases to test the APIs.
• Hands-on experience of defining high quality test scenarios, test cases with ability to review and guide the test team members in doing the same.
• Education/Certifications: B.E./ B.Tech. / MTech/ MCA/ MS (Computer Science/IT)/ISTQB Advanced Test Manager or equivalent required.