Role : Senior Test Analyst Quality Engineering / QA ETL

Location : Gurugram, India

Experience : 710 Years

Mode of Interview : Virtual + In-person

Employment Type : Full-time

Key Responsibilities :

1. ETL & Data Testing :

- Design and execute comprehensive test strategies for ETL pipelines, data migration, data transformation, and data integration processes.

- Validate data movement across source, staging, transformation, and target systems.

- Verify data completeness, accuracy, consistency, integrity, and transformation rules.

- Develop source-to-target mapping validation scenarios.

- Perform data reconciliation between upstream and downstream systems.

- Validate transformation logic, business rules, calculations, aggregations, and derived fields.

- Identify data anomalies, missing records, duplicate records, truncation issues, and transformation discrepancies.

- Validate incremental and full data loads.

- Test ETL workflows for positive, negative, boundary, and exception scenarios.

- Perform regression testing whenever ETL mappings, business rules, schemas, or data pipelines are modified.

- Analyze failed ETL jobs and work with Data Engineers and Developers for resolution.

2. SQL & Database Testing :

- Demonstrate strong hands-on expertise in SQL for database and ETL validation.

- Write complex SQL queries involving joins, subqueries, CTEs, aggregations, window functions, and data comparison techniques.

- Validate data across multiple database tables and schemas.

- Perform backend data validation independently without relying solely on UI validation.

- Compare source and target datasets to identify data mismatches.

- Validate record counts, null values, duplicate records, referential integrity, and data quality.

- Develop reusable SQL queries for regression and data validation.

- Perform database testing across different stages of the data pipeline.

- Support root-cause analysis of data-related defects using database queries and logs.

3. Snowflake Testing :

- Perform hands-on testing and validation of data stored in Snowflake.

- Validate Snowflake tables, views, schemas, and data transformation processes.

- Execute SQL queries in Snowflake for data reconciliation and validation.

- Validate data ingestion into Snowflake from upstream systems.

- Verify transformation and business rules implemented within Snowflake.

- Perform source-to-target data comparison between legacy/upstream databases and Snowflake.

- Validate incremental loads, historical data, and data refresh processes.

- Identify data quality issues and provide actionable findings to development/data engineering teams.

- Support regression testing for Snowflake-based data pipelines.

4. API Testing :

- Design and execute API test scenarios for REST-based integrations.

- Perform API testing using Postman and similar tools.

- Validate REST APIs using JSON and XML request/response payloads.

- Verify HTTP methods, status codes, headers, authentication, request parameters, and response structures.

- Validate positive, negative, boundary, and error-handling scenarios.

- Perform API integration testing between internal applications and external invoicing/tax platforms.

- Validate data consistency between API responses and backend databases.

- Perform end-to-end validation across API, application, database, and downstream systems.

- Analyze API logs and integration failures for root-cause identification.

5. Invoice & Financial Transaction Testing :

- Validate end-to-end invoice ingestion, processing, transformation, and transmission workflows.

- Verify invoice data across upstream applications, middleware/API layers, databases, and downstream systems.

- Validate invoice fields, calculations, tax information, currencies, dates, customer/vendor details, and transaction attributes.

- Validate country-specific invoice formats and regulatory requirements.

- Test different invoice types, transaction scenarios, and exception conditions.

- Perform reconciliation between source invoices and processed/transmitted invoices.

- Validate failed, rejected, duplicate, and partially processed transactions.

- Work with business teams and vendors to resolve invoice-processing discrepancies.

- Support testing for financial transaction processing and integration programs.

6. Automation Testing :

- Develop and maintain automated test scripts for functional, API, ETL, database, and regression testing.

- Identify suitable test scenarios for automation based on risk, frequency, and business criticality.

- Contribute to the development and enhancement of automation frameworks.

- Integrate automated tests into CI/CD pipelines wherever applicable.

- Execute automated regression suites and analyze failures.

- Maintain reusable automation components and test utilities.

- Improve regression coverage through automation.

- Generate execution reports and quality metrics.

- Collaborate with developers and QA engineers to improve automation reliability and maintainability.

7. Python :

- Utilize Python for test automation, data validation, test utilities, and scripting.

- Develop Python scripts for database validation and data comparison.

- Automate repetitive data-quality and reconciliation activities.

- Develop reusable utilities for API and ETL testing.

- Use Python to analyze large datasets and identify anomalies.

- Support automation framework development and maintenance.