ETL Technical Specialist-Testing Services

Birlasoft; Bengaluru; On-site; INR 1,300,000 - 2,000,000; Full time

Job summary

Birlasoft is seeking a QA/Test Engineer with 6-8 years of experience to validate end-to-end data flows and ETL processes. The role focuses on ETL testing, SQL-based data validation, and ensuring accuracy across source, staging, and warehouse layers.

The candidate will review mappings, perform various load tests, and collaborate with Development, ETL, Product, and Business teams to resolve defects and ensure quality release readiness.

Qualifications

• Experience in QA/testing with data validation and ETL processes.
• Strong ability to validate end-to-end data flows and business rules.
• Experience in validating source-to-target mappings and data quality.

Responsibilities

• Validate data extraction, transformation, and loading processes.
• Review mappings and transformation logic for accuracy.
• Write SQL queries for backend validation and reconciliation.
• Perform data quality checks and log defects through the lifecycle.
• Collaborate with Dev, ETL, Product and Business teams for resolution.

Skills

ETL Testing

Data Validation

Tools

SQL

Job 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.