Birlasoft—ETL Technical Specialist-Testing Services

Job description

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.