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

Birlasoft
Bengaluru
Workplace: OnsiteFull timeFunction: Solutions Engineering & Sales EngineeringExperience: 6-8 yearsSkills: ["Attention to detail","Problem-solving","Defect management","Collaboration","Investigating data anomalies"]

Validate end-to-end ETL data flows, business rules, transformations, and reconciliation processes across multiple source systems and platforms. Execute full, incremental, delta, and historical load testing, including insert/update/delete and effective-dated transactions. Ensure data movement is correct from source through staging, warehouse, and targets using SQL-based validations at table, column, and record levels. Investigate anomalies and defects, log and track issues, and support release sign-off with test evidence.

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, business rules, transformations, and reconciliation processes across multiple source systems and platforms. Execute full, incremental, delta, and historical load testing, including insert/update/delete and effective-dated transactions. Ensure data movement is correct from source through staging, warehouse, and targets using SQL-based validations at table, column, and record levels. Investigate anomalies and defects, log and track issues, and support release sign-off with test evidence.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

Key Responsibilities

  • •Validate ETL extraction, transformation, and loading processes; review source-to-target mappings and transformation logic
  • •Test full load, incremental load, delta load, and historical load data movements
  • •Validate insert, update, delete, cancel, and effective-dated transactions for correctness across systems
  • •Write SQL queries to perform table-level, column-level, and record-level validations and data reconciliation
  • •Investigate data anomalies, duplicates, and missing records; log, track, and validate defects and support release sign-off with test evidence

Key Requirements

  • •6–8 years of experience
  • •Expertise in ETL testing and SQL-based data validation
  • •Validate end-to-end data flows, business rules, data transformations, and reconciliation across source systems
  • •Experience testing full load, incremental load, delta load, and historical load scenarios including effective-dated transactions
  • •Ability to write SQL queries for backend validation and perform table-, column-, and record-level checks
Experience:6-8 years
Skills:Attention to detailProblem-solvingDefect managementCollaborationInvestigating data anomalies
Tech Stack:ETLSQL

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