ETL Technical Specialist-Testing Services (INDIA - BENGALURU - AUTOMOTIVE, IN)

Birlasoft
Bengaluru
Workplace: OnsiteFull timeFunction: Solutions Engineering & Sales EngineeringExperience: 6-8 yearsSkills: ["Defect triage","Data quality focus","Problem investigation","Cross-functional collaboration"]

Validate end-to-end ETL data flows by testing extraction, transformation, and loading across source, staging, warehouse, and target systems. Review source-to-target mappings and transformation logic, run full/incremental/delta/historical load tests, and verify insert/update/delete and effective-dated transactions. Write SQL for backend validation, perform data reconciliation, and proactively run data quality checks. Investigate anomalies and collaborate with development and business teams to triage defects and support release sign-off.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Birlasoft
Birlasoft
1 day ago

ETL Technical Specialist-Testing Services (INDIA - BENGALURU - AUTOMOTIVE, IN)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 15 hours agoStatus: Live

Job Summary

Validate end-to-end ETL data flows by testing extraction, transformation, and loading across source, staging, warehouse, and target systems. Review source-to-target mappings and transformation logic, run full/incremental/delta/historical load tests, and verify insert/update/delete and effective-dated transactions. Write SQL for backend validation, perform data reconciliation, and proactively run data quality checks. Investigate anomalies and collaborate with development and business teams to triage defects and support release sign-off.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

Key Responsibilities

  • •Validate data extraction, transformation, and loading processes, including review of source-to-target mappings and transformation logic.
  • •Execute full load, incremental load, delta load, and historical load testing and validate transactional behaviors such as insert/update/delete and effective-dated records.
  • •Ensure correctness of data movement across source, staging, warehouse, and target systems.
  • •Perform table-level, column-level, and record-level validations and conduct reconciliation between source and target systems.
  • •Investigate data anomalies and proactively run data quality checks; log, track, and validate defects and support release sign-off activities.

Key Requirements

  • •6-8 years of experience in QA/Test with ETL testing.
  • •Strong expertise in SQL-based data validation and writing SQL queries for backend validation.
  • •Experience validating end-to-end data flows, transformations, business rules, and reconciliation processes.
  • •Experience testing full load, incremental load, delta load, and historical load scenarios, including insert/update/delete and effective-dated transactions.
  • •Ability to investigate data anomalies, duplicates, and missing records; log, track, and validate defects throughout the testing lifecycle.
Experience:6-8 years
Skills:Defect triageData quality focusProblem investigationCross-functional collaboration
Tech Stack:ETLSQLData validationData reconciliation

Company Brief

Birlasoft
Birlasoft is a global IT services and digital solutions provider delivering consulting, enterprise applications, cloud, and infrastructure services to enterprises across industries, helping accelerate digital transformation and business modernization.
Industry: Professional Services
Company Size: Enterprise (1,001+ employees)
Revenue: USD 500M to 1B
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Noida, India
WebsiteLinkedIn