ETL Tester

Blanc Labs is a premier partner for global enterprises, leading the way in digitization, automation, and the development of next-generation digital products and services. Our expertise in digital transformation powers businesses to accelerate service delivery, drive customer engagement, and foster growth.

We are seeking an experienced ETL Tester with a strong background in data integration and data conversion test automation, particularly within an Azure cloud environment. The successful candidate will play a crucial role in ensuring the accuracy, reliability, and performance of complex ETL processes and data transformations, which are vital for our banking client's operations.

Key Responsibilities:

• Design, develop, and execute test plans and test cases for ETL processes focused on data integration and data conversion within an Azure cloud environment.

• Automate test scripts and processes using industry-standard tools and frameworks to validate ETL pipelines, ensuring they meet business and technical requirements.

• Perform comprehensive testing of data extraction, transformation, and loading (ETL) processes to ensure data accuracy, completeness, and integrity across different data sources.

• Collaborate closely with data engineers, developers, and business analysts to understand data requirements and translate them into effective test strategies.

• Validate data conversion processes during migrations and integrations, ensuring that data is accurately transformed and loaded into target systems.

• Monitor and validate data flows and transformations within Azure services, including Azure Data Factory, Azure SQL Database, and other related technologies.

• Identify, document, and track defects, working closely with the development team to ensure timely resolution.

• Produce detailed test reports, including defect summaries and recommendations for improving data quality and ETL processes.

• Stay current with the latest developments in ETL testing, data integration technologies, and Azure cloud services, continuously improving testing methodologies.

What will it take to succeed:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• 5+ years of experience in ETL testing, with a strong emphasis on data integration, validation, conversion, and test automation.

• Hands-on experience with Azure cloud services, particularly Azure Data Factory, Azure SQL Database, Microsoft Fabric and related technologies.

• Proficiency in SQL and experience with database testing in a data warehouse environment.

• Experience with test automation tools such as Selenium, JUnit, or similar, and scripting languages like Python, Java, or Shell.

• Familiarity with CI/CD pipelines and version control systems, such as Git, in an Azure environment.

• Strong analytical skills and attention to detail, with the ability to identify and troubleshoot issues effectively.

• Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.

• Knowledge of banking industry standards and practices, particularly in data management and regulatory compliance, is an advantage.

Blanc Labs is enabling a digital future. Headquartered in Toronto, we partner with clients in North & South America to digitize and automate their operations and build their next generation of digital products and services. We empower clients to enhance their digital offerings and bring creative solutions to the market faster. Learn more at www.blanclabs.com. 

Blanc Labs is an equal opportunity employer and is committed to providing employment in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. Accommodations within reason due to a disability or medical need are available on request for candidates taking part in the recruitment process.