Etl technical specialist-testing services

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.
• Prepare test evidence and support release sign-off activities.