ETL Test Engineer – Data Warehouse, SQL, Database Testing & Python

About this role

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

Associate Consultant - Databricks AWS

KPMG Global Services

In OfficeBengaluru

Apply

Software Engineer - PCP Platform(AWS Cloud) - IaC

Airbus

In OfficeBengaluru

Apply

Site Reliability Engineer - Devops, AWS, Python/GO - 4 to 8 years

Cisco

In OfficeBengaluru

Apply

FullStack Developer (React,AWS & Python)

Airbus

In OfficeBengaluru

Apply

Skills you'll use

What you'll do

• Validate ETL workflows, data migrations, data transformations, and data loading processes across source, staging, warehouse, and target systems.
• Perform source-to-target data validation and reconciliation to verify data accuracy, completeness, consistency, and integrity.
• Design, develop, and execute ETL test cases, test scenarios, test scripts, and test data based on business and technical requirements.
• Conduct database testing using complex SQL queries, joins, stored procedures, and validation logic.
• Analyze business and technical requirements and prepare test plans, test strategies, traceability records, and execution approaches.
• Validate large data volumes and transformation logic across fact tables, dimension tables, star schemas, snowflake schemas, and related data structures.
• Perform regression, integration, system, migration, and data quality testing throughout the delivery lifecycle.
• Identify, document, prioritize, track, and report defects, and work with development and data engineering teams to support timely resolution.
• Use basic Python scripts for test automation support, data validation, data comparison, reconciliation, and repetitive testing activities.
• Create and maintain test execution reports, defect reports, test evidence, validation results, and other testing documentation.

Who can apply

• ETL Testing Tools: Hands-on experience with at least one ETL tool, such as Informatica, Talend, SSIS, DataStage, or a similar platform.
• SQL: Strong experience writing complex queries, joins, subqueries, stored procedures, reconciliation queries, and data validation scripts.
• Python: Basic practical knowledge for scripting, test automation support, data validation, comparison activities, and test utilities.
• Database Testing Tools: Experience using database query and validation tools relevant to the project environment.
• Defect Tracking and Test Management Tools: Experience with JIRA, ALM, Azure DevOps, or equivalent tools.
• Data Warehouse Testing: Experience validating data extraction, transformation, loading, migration, and source-to-target processing.
• Testing Documentation Tools: Experience preparing test plans, test strategies, test cases, test scenarios, test scripts, execution reports, and defect documentation.

About Synechron

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