Country/Region:
IN
Requisition ID:
38649
Work Model:
Position Type:
Salary Range:
Location:
INDIA - BENGALURU - AUTOMOTIVE
Title: ETL Technical Specialist-Testing Services
Description:
Area(s) of responsibility
Experience: 6 -8 Years
Role Summary
We are seeking a highly motivated QA/Test Engineer with good expertise in ETL Testing, SQL-based Data Validation. The candidate will be responsible for validating end-to-end data flows, business rules, data transformations, and reconciliation processes across multiple source systems and SPM platforms.
Key Responsibilities :
- Validate data extraction, transformation, and loading processes. Review source-to-target mappings and transformation logic.
- Perform full load, incremental load, delta load, and historical load testing. Validate insert, update, delete, cancel, and effective-dated transactions.
- Ensure correctness of data movement across source, staging, warehouse, and target systems. Write SQL queries for backend validation.
- Perform table-level, column-level, and record-level validations.Conduct data reconciliation between source and target systems.
- Investigate data anomalies, duplicates, and missing records. Validate:
- Execute data quality checks and identify defects proactively. Log, track, and validate defects throughout the testing lifecycle.
- Participate in defect triage meetings. Work closely with Development, ETL, Product, and Business teams for issue resolution.
- repare test evidence and support release sign-off activities.