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.