Requisition ID: 249316
Join a purpose driven winning team committed to results in an inclusive and high-performing culture.
We are seeking a highly skilled Technical QA Specialist with strong hands-on coding experience in Python advanced ETL and data validation expertise and the ability to work across both functional and technical quality assurance streams. The ideal candidate brings deep analytical skills strong problem-solving capability and experience validating complex data workflows including string based ETL transformations. Experience with cloud platforms is considered an asset.
This role requires someone who can independently design test strategies build automation where applicable validate data pipelines and ensure delivery of high quality software solutions.
Is this role right for you In this role you will:
- Design develop and execute comprehensive test plans test cases and test strategies for largescale data processing and application workflows.
- Validate ETL pipelines including string parsing data transformations and endtoend data movement across systems.
- Perform functional regression integration and endtoend testing for data and application components.
- Conduct detailed data quality checks including completeness accuracy consistency referential integrity and transformation correctness.
- Analyze complex datasets and identify defects anomalies and edgecase behavior early in the lifecycle.
- Work closely with developers data engineers and product owners to ensure requirements are clearly understood and test coverage is complete.
- Support CI/CD pipeline testing practices and shiftleft quality initiatives.
- Build Pythonbased automation scripts to streamline validation data transformation checks and regression activities.
- Develop reusable utilities for string manipulation file parsing (CSV PSV fixedwidth JSON XML) and ETL verification.
- Implement automated data comparison and validation tools using Python pandas or PySpark.
- Participate in improving QA automation frameworks and contributing new components.
- Utilize Git/GitHub/GitLab for version control branch strategy and code reviews.
- Support testing of APIs backend services and data workflows as required.
Do you have the skills that will enable you to succeed in this role Wed love to work with you if you have:
- 58 years of QA experience in datadriven or applicationbased environments.
- Strong handson proficiency with Python (modular reusable optimized code).
- Mandatory Big Data experience including testing pipelines in distributed environments using: PySpark Spark SQL Distributed data validation at scale
- Deep experience with ETL testing including stringbased transformations and largevolume data validations.
- Advanced SQL skills for multisource data validation.
- Strong understanding of QA methodologies Agile/Scrum and defect lifecycle management.
- Experience validating structured and semistructured data (CSV JSON XML).
- Strong analytical debugging and problemsolving abilities.
- Experience with cloud platforms (Azure AWS or GCP) for storage orchestration or distributed computing is an asset.
- Familiarity with CI/CD and DevOps tooling (Jenkins GitHub Actions Azure DevOps) is an asset.
- Knowledge of data masking synthetic data techniques or privacyfocused validation is an asset.
Whats in it for you
- Diversity Equity Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential respected for who they are and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities ethnicity race age ability & veterans.
- Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
- Upskilling through online courses cross-functional development opportunities and tuition assistance.
- Competitive Rewards program including bonus flexible vacation personal sick days and benefits will start on day one.
- Dynamic Ecosystem - Free tea & coffee universal washrooms and lots of space for team collaboration.
- Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs.
Location(s): Canada : Ontario : Toronto
Scotiabank is a leading bank in the Americas. Guided by our purpose: for every future we help our customers their families and their communities achieve success through a broad range of advice products and services including personal and commercial banking wealth management and private banking corporate and investment banking and capital markets.
At Scotiabank we value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including but not limited to an accessible interview site alternate format documents ASL Interpreter or Assistive Technology) during the recruitment and selection process please let our Recruitment team know. If you require technical assistance please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however only those candidates who are selected for an interview will be contacted.
Required Experience:
IC
Requisition ID: 249316Join a purpose driven winning team committed to results in an inclusive and high-performing culture.We are seeking a highly skilled Technical QA Specialist with strong hands-on coding experience in Python advanced ETL and data validation expertise and the ability to work across...
Requisition ID: 249316
Join a purpose driven winning team committed to results in an inclusive and high-performing culture.
We are seeking a highly skilled Technical QA Specialist with strong hands-on coding experience in Python advanced ETL and data validation expertise and the ability to work across both functional and technical quality assurance streams. The ideal candidate brings deep analytical skills strong problem-solving capability and experience validating complex data workflows including string based ETL transformations. Experience with cloud platforms is considered an asset.
This role requires someone who can independently design test strategies build automation where applicable validate data pipelines and ensure delivery of high quality software solutions.
Is this role right for you In this role you will:
- Design develop and execute comprehensive test plans test cases and test strategies for largescale data processing and application workflows.
- Validate ETL pipelines including string parsing data transformations and endtoend data movement across systems.
- Perform functional regression integration and endtoend testing for data and application components.
- Conduct detailed data quality checks including completeness accuracy consistency referential integrity and transformation correctness.
- Analyze complex datasets and identify defects anomalies and edgecase behavior early in the lifecycle.
- Work closely with developers data engineers and product owners to ensure requirements are clearly understood and test coverage is complete.
- Support CI/CD pipeline testing practices and shiftleft quality initiatives.
- Build Pythonbased automation scripts to streamline validation data transformation checks and regression activities.
- Develop reusable utilities for string manipulation file parsing (CSV PSV fixedwidth JSON XML) and ETL verification.
- Implement automated data comparison and validation tools using Python pandas or PySpark.
- Participate in improving QA automation frameworks and contributing new components.
- Utilize Git/GitHub/GitLab for version control branch strategy and code reviews.
- Support testing of APIs backend services and data workflows as required.
Do you have the skills that will enable you to succeed in this role Wed love to work with you if you have:
- 58 years of QA experience in datadriven or applicationbased environments.
- Strong handson proficiency with Python (modular reusable optimized code).
- Mandatory Big Data experience including testing pipelines in distributed environments using: PySpark Spark SQL Distributed data validation at scale
- Deep experience with ETL testing including stringbased transformations and largevolume data validations.
- Advanced SQL skills for multisource data validation.
- Strong understanding of QA methodologies Agile/Scrum and defect lifecycle management.
- Experience validating structured and semistructured data (CSV JSON XML).
- Strong analytical debugging and problemsolving abilities.
- Experience with cloud platforms (Azure AWS or GCP) for storage orchestration or distributed computing is an asset.
- Familiarity with CI/CD and DevOps tooling (Jenkins GitHub Actions Azure DevOps) is an asset.
- Knowledge of data masking synthetic data techniques or privacyfocused validation is an asset.
Whats in it for you
- Diversity Equity Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential respected for who they are and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities ethnicity race age ability & veterans.
- Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
- Upskilling through online courses cross-functional development opportunities and tuition assistance.
- Competitive Rewards program including bonus flexible vacation personal sick days and benefits will start on day one.
- Dynamic Ecosystem - Free tea & coffee universal washrooms and lots of space for team collaboration.
- Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs.
Location(s): Canada : Ontario : Toronto
Scotiabank is a leading bank in the Americas. Guided by our purpose: for every future we help our customers their families and their communities achieve success through a broad range of advice products and services including personal and commercial banking wealth management and private banking corporate and investment banking and capital markets.
At Scotiabank we value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including but not limited to an accessible interview site alternate format documents ASL Interpreter or Assistive Technology) during the recruitment and selection process please let our Recruitment team know. If you require technical assistance please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however only those candidates who are selected for an interview will be contacted.
Required Experience:
IC
View more
View less