Sr Tester

Sonata Software; Bengaluru Urban; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading modernization engineering firm is looking for a Senior ETL Tester to join their team in Bengaluru. The role involves performing end-to-end testing of ETL and data pipeline workflows, validating data transformations, and ensuring data accuracy using Azure services. Candidates should have over 5 years of experience in ETL testing, strong SQL skills, and a familiarity with data warehousing concepts. This position offers the opportunity to collaborate closely with ETL developers and support data quality initiatives.

Qualifications

• 5+ years of experience in ETL/Data Warehouse testing.
• Strong SQL skills for data validation and reconciliation.
• Hands-on experience with Azure Data Services.

Responsibilities

• Perform end-to-end testing of ETL and data pipeline workflows.
• Validate data ingestion, transformation, and business rules.
• Execute data validation using SQL and identify defects.

Skills

ETL Testing

Advanced SQL

Azure Data Factory

Data Warehouse Concepts

Power BI Validation

CI/CD Familiarity

Tools

Azure Data Factory

Microsoft Fabric

SQL Server

Jira

Job description

About Sonata Software

In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.

As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook. In addition, we bring agility and systems thinking to accelerate time to market for our clients.

Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in TMT (Telecom, Media, and Technology), Retail & CPG, Manufacturing, BFSI (Banking, Financial Services, and Insurance), and HLS (Healthcare and Lifesciences) space. Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.

JD

5+ years of experience

• Skills: Senior ETL Tester
• Location: Bangalore/Hyderabad/Chennai
• Shifts: 11 AM to 8 PM

Key Responsibilities

• Perform end-to-end testing of ETL and data pipeline workflows from source systems to target data platforms.
• Validate data ingestion, transformation, aggregation, and business rules for accuracy and completeness.
• Execute data reconciliation and validation using SQL to identify mismatches and defects.
• Test full loads, incremental loads, and historical data scenarios.
• Validate data pipelines built using Azure Data Platform services.
• Perform Power BI dataset and report validation to ensure data accuracy.
• Support UAT, regression testing, and post-production data validation.
• Identify root causes of data defects and collaborate with ETL developers for resolution.
• Document test cases, test results, and defect details clearly.

Required Technical Skills

• Strong experience in ETL / Data Warehouse testing.
• Advanced SQL skills (joins, subqueries, CTEs, aggregations, reconciliation queries).
• Hands-on experience with Azure Data Services, including:
• Azure Data Factory (ADF)
• Azure SQL Database / SQL Server
• Microsoft Fabric
• Experience validating data transformations and data models.
• Knowledge of data warehousing concepts (facts, dimensions).
• Experience validating Power BI datasets and reports.
• Familiarity with CI/CD and ticketing tools (Jira).
• Exposure to data quality and validation frameworks.