Test Automation Engineer - ETL
Wipro · Toronto · CA$57,000–CA$90,000 (stated in the posting)
Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.Job Description
We are looking for a highly motivated 6-8 years of ETL Test Automation Engineer with strong expertise in Azure Data Factory (ADF), Azure Databricks, Python, SQL, and ETL Testing.
Key Responsibilities:
• Support ETL/ELT pipelines using Azure Data Factory and Azure Databricks.
• Optimize data ingestion frameworks and Data Lake processing pipelines.
• Implement data quality checks, data reconciliation, and validation frameworks.
• Monitor and troubleshoot data pipeline failures, performance bottlenecks, and production issues.
• Perform end-to-end ETL testing across source and target systems.
• Execute source-to-target validation, reconciliation, schema validation, and data integrity checks.
• Create and execute SQL-based validation scripts for large datasets.
• Validate transformation logic, business rules, and incremental data loads.
• Identify, track, and support closure of ETL and data quality defects.
• Support SIT, UAT, Regression, and Production validation activities.
• Automate regression and reconciliation activities to reduce manual effort.
• Integrate automated validation scripts into CI/CD pipelines.
• Drive continuous improvement through automation and AI-assisted testing practices.
Required Technical Skills:
• Azure Databricks
• Azure Data Factory (ADF)
• Python
• PySpark
• SQL / Azure SQL
• ETL Testing
• Bitbucket / Git