Azure ETL Tester

Apex Systems is a global IT services provider and our consulting practice has an opening for a Azure ETL Tester who has experience with in Azure, Azure Data Factory and Databrick to ensure data quality at a Top Five Bank.

Client: Big 5 Canadian Bank

Location: Downtown Toronto - Hybrid (1-2 days a week in office)

Terms: 6 Month Contract, strong possibility of extension

Hours: 37.5 hours/week Monday-Friday

Start: June 2025

Job Summary:

We are looking for an experienced Azure ETL Tester with over 5 years of expertise who will play a pivotal role in ensuring the quality and integrity of our critical data pipelines and transformations. This individual will be responsible for designing, implementing, and maintaining robust testing strategies across our Azure, Databricks, ADF and Salesforce environments. A strong understand of SQL is a must

Requirements:

• 5+ yrs of experience in design and implement comprehensive test plans for data pipelines and transformations in a Microsoft Azure + Databricks and Power BI technology stack.
• In-depth knowledge in functional testing Azure Databricks, Azure Data Factory, Azure PowerBI using SQL Queries
• Excellent analytical and problem-solving skills, communication skills
• Knowledge in Data testing, ETL functional testing, implementation of Automation test frameworks in Data platforms
• Knowledge in Data governance, Data pipeline framework, Data ingestion, Data ops, Data profiling, Unity catalog, etc.
• Conduct data quality assessments, validation, and profiling using tools like Great Expectations.
• Develop and maintain automated testing frameworks integrated into CI/CD pipelines.
• Collaborate with data engineers to ensure adherence to best practices.
• Monitor and assess pipeline performance, scalability, and data integrity.
• Implement and manage DevOps practices using Azure DevOps, Git, and related tools.
• Document test cases, validation rules, and QA processes clearly and consistently.
• Proactive in identifying gaps and raising issues; Self-motivated, possessing initiative to get things done with high quality
• Participate in Agile ceremonies and contribute to sprint planning and retrospectives.
• Experience with various ETL tools and technologies such as: SSIS, Azure Data Factory, Databricks, etc
• Familiarity with data modeling concepts.
• Experience with test management tools e.g: Jira, Azure DevOps, HP ALM