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