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

synechron; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Synechron in Bengaluru is seeking an ETL Tester with 5-8 years of experience to validate data pipelines, transformations, migrations, and loading processes across end-to-end data solutions. You will ensure data accuracy, completeness, and integrity to support reliable reporting and analytics, with hands-on exposure to Informatica / Talend / SSIS, SQL, and basic Python scripting.

This role collaborates with data engineers and business analysts to identify data issues early and improve confidence

Qualifications

• Hands-on ETL testing experience essential.
• Strong SQL and data validation scripting required.
• Basic Python scripting for validation and test utilities.
• Experience with database testing tools and data warehouse testing.
• Familiarity with defect tracking and test management tools (JIRA, ALM, Azure DevOps).

Responsibilities

• Validate ETL workflows, migrations, transformations, and loading 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.
• Participate in requirement discussions, test planning, defect triage, review meetings, release activities, and post-deployment validation.
• Ensure testing activities follow approved quality, security, data handling, and delivery standards.
• Support efficient test execution by reusing test assets, automating suitable validation tasks, and considering responsible use of compute, storage, and processing resources.

Skills

SQL

Python

ETL Testing

Tools

ETL Tools (Informatica/Talend/SSIS)

Database Query Tools

JIRA/ALM/Azure DevOps

Test Management Tools

Job description

Job Summary

Synechron is seeking an ETL Tester - Data Warehouse, Database Testing and Basic Python for its Bangalore team. The role requires 5-8 years of experience in ETL testing, data warehouse testing, database testing, and basic Python scripting. The successful candidate will validate data pipelines, transformations, migrations, and loading processes to ensure data accuracy, completeness, consistency, and integrity across end-to-end data solutions. This role contributes to business objectives by identifying data issues early, improving confidence in reporting and analytics, and supporting reliable data delivery.

Software Requirements (Required and Preferred)

Required

• 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.

Preferred

• Agile/Scrum Tools and Practices: Experience working with sprint planning, backlog management, daily stand‑ups, reviews, retrospectives, and delivery tracking.
• Cloud Data Platforms: Exposure to cloud‑based data platforms, including AWS, Azure, GCP, or equivalent environments.
• BI Reporting Tools: Knowledge of validating reports and dashboards using Power BI, Tableau, or similar business intelligence tools.
• Test Automation Frameworks: Basic understanding of frameworks and utilities used for test automation, data comparison, and regression testing.
• Data Quality Tools: Exposure to tools used for data profiling, data quality monitoring, reconciliation, or data governance.

Overall Responsibilities

• 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.
• Participate in requirement discussions, test planning, defect triage, review meetings, release activities, and post‑deployment validation.
• Ensure testing activities follow approved quality, security, data handling, and delivery standards.
• Support efficient test execution by reusing test assets, automating suitable validation tasks, and considering responsible use of compute, storage, and processing resources.

Technical Skills (By Category)

Programming Languages

Essential

• Strong SQL skills, including complex queries, joins, subqueries, aggregations, stored procedures, and data validation logic.
• Basic Python knowledge for scripting, data comparison, validation, test automation support, and repetitive testing activities.
• Ability to interpret transformation logic and validate expected outcomes across ETL processes.

Preferred

• Additional scripting experience for test utilities, reporting, log analysis, or automation.
• Experience using Python libraries for file comparison, data analysis, database connectivity, or test support.

Databases and Data Management

Essential

• Strong experience in database testing and data warehouse testing.
• Experience validating large data volumes across source, staging, warehouse, and target environments.
• Understanding of fact tables, dimension tables, star schema, snowflake schema, data marts, and