ETL Test Architect

Virtusa

10 - 15 years

12 - 17 Lacs

chennai

Posted:2 days ago| Platform:

Apply

Skills Required

sql snowflake etl tools python data validation datastage version control talend data warehousing databricks azure data factory warehouse sql server git data modeling selenium devops jenkins etl informatica azure

Work Mode

Work from Office

Job Type

Full Time

Job Description

Lead the end to end testing process for ETL workflows, data pipelines, and data warehouse solutions.
Collaborate with business analysts, developers, and data engineers to understand data requirements and transformation logic.
Design and develop comprehensive test strategies, test cases, and test data to validate ETL processes.
Perform data validation, reconciliation, and verification between source and target systems.
Implement test automation frameworks for ETL and data validation using tools like Python, PySpark , or SQL based automation.
Analyze test results, identify defects, and work closely with the development team to ensure timely resolution.
Monitor and report test progress, metrics, and quality indicators to stakeholders.
Ensure adherence to best practices, data governance, and compliance standards.
Mentor and guide team members on ETL testing methodologies and tools.
Lead and manage an ETL testing team, providing technical guidance, task allocation, and feedback.Proven experience in ETL and DWH testing including leading testing teams.
Strong expertise in SQL for data validation and complex query writing.
Hands on experience with ETL tools such as Informatica, Talend, DataStage, Azure Data Factory, or similar.
Proficiency with databases like Oracle, SQL Server, Snowflake, Teradata, or BigQuery .
Experience with automation frameworks for data testing such as PyTest , Selenium, QuerySurge , and Databricks Notebooks.
Solid understanding of data warehousing concepts, data modeling, and ETL workflows.
Familiarity with CI CD pipelines and integration with version control systems such as Git, Jenkins, and Azure DevOps.
Excellent analytical, communication, and leadership skills.

More Jobs at Virtusa

Servicenow QA

Bengaluru, Karnataka

3 - 3 yrs

Salary: Not disclosed

React T3

Bengaluru, Karnataka

Experience: Not specified

Salary: Not disclosed

Java-Pankaj

Bengaluru, Karnataka

Experience: Not specified

Salary: Not disclosed

C ++

Bengaluru, Karnataka

Experience: Not specified

Salary: Not disclosed

Java Architect (ATC)

Bengaluru, Karnataka

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.