Senior Consultant - Data lake/ ETL Testing

About this role

Not quite right? These jobs in Bengaluru match the same skills — apply to a few to improve your chances.

Cloud Data Engineer | Snowflake, Spark, dbt, SQL & AWS

Synechron

In OfficeBengaluru

Apply

AWS /Azure/ Databricks + AI + Agentic AI+ Python- Senior Associate

PwC

In OfficeBengaluru

Apply

Associate Consultant - Databricks AWS

KPMG Global Services

In OfficeBengaluru

Apply

GSS - Tech Sourcing Recruiter AWS , WWAS TA C Sourcing

Amazon

In OfficeBengaluru

Apply

Skills you'll use

What you'll do

• Key Responsibilities
• Perform end-to-end ETL testing, including source-to-target data validation, reconciliation, and transformation checks across multiple stages of the pipeline.
• Write and execute complex SQL queries for backend data validation.
• Create detailed test plans, test scenarios, and test cases/scripts based on mapping documents, user stories, and business requirements.
• Design and run reconciliation checks between legacy, staging, target databases, and reporting layers.
• Validate data correctness in target applications to ensure migrated/loaded data supports key business scenarios.
• Log, track, and manage defects to closure using tools such as Jira, including clear steps, SQL evidence, and impact analysis.
• Provide daily/regular test execution and status reports to stakeholders, highlighting progress, defect trends, and risks.
• Collaborate effectively with cross-functional teams (data engineers, migration developers, functional QA, BAs, architects, and customer SMEs) to ensure data quality and timely delivery.
• Contribute to and maintain reusable SQL libraries, reconciliation templates, and best-practice checklists for data testing across projects.

Who can apply

• 6–8 years of overall QA / testing experience, with at least 3–4 years focused on data testing or data migration in enterprise systems.
• Strong SQL skills (joins, aggregations, reconciliation queries) and experience validating large datasets across multiple databases or stages.

About Guidewire

Searching for “Guidewire jobs” or “jobs at Guidewire”? You’re in the right place.