ETL Technical Specialist-Testing Services

Job description

Country/Region: IN Requisition ID: 38650 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.