Specialist II-IC Quality Assurance

Bank of Montreal•Tempe, AZ

14h•$129,290 - $129,290

About The Position

BMO Bank N.A. seeks a Specialist II-IC Quality Assurance to ensure the quality of products delivered by technology teams. The role works closely with application, common services/middleware, and infrastructure teams throughout the development and engineering lifecycle. It records and documents test results, compares them with expected outcomes, and conducts independent analysis to resolve strategic issues. The position designs, develops, executes, and maintains test plans and strategies for ETL processes, including validating data transformations and integration and loading data from source systems into data warehouses, data marts, and reporting systems. It develops detailed test cases, scenarios, and scripts for finance and compliance data, and performs extensive data validation, profiling, and analysis to detect anomalies and data quality issues. The role collaborates with business analysts, data engineers, and architects to gather testing requirements, understand transformation logic, and validate ETL mappings. It develops test automation suites and frameworks, defines standards, oversees test projects, supports operations scheduling, and reviews requirements for testability. It executes and verifies test cases for functional testing, reports defects and test results to stakeholders, communicates deliverable quality, and uses metrics to guide delivery and identify concerns. It also strengthens quality assurance capabilities by sharing expertise, mentoring employees, and building communities of practice and networks.

Requirements

Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or a related field (or foreign education equivalent) and four years of experience as a Software Engineer, QA professional, or in a related occupation; alternatively, a master's degree in one of those fields (or foreign education equivalent) and two years of such experience.
Experience testing ETL processes, writing SQL to validate data transformations in enterprise data warehouses and data marts, and performing QA automation.
Experience defining test plan processes; recording test results, test coverage, and test metrics; and tracking defects using HP ALM/Quality Center or JIRA to ensure compliance with Enterprise QA standards.
Experience developing automated and manual SQL test scripts for ETL loads, data aggregations, data conversions, data extracts, and data warehouses using database IDE tools such as SQL Developer, TOAD, Oracle, Teradata, and MS SQL Server.
Experience performing detailed data analysis, data profiling, data cleansing, data reconciliation, and data integrity work using SQL, Shell scripts, Pandas (Python), and Informatica IDQ.
Experience validating transformation business rules, reports, and CDC logic in data warehouses using tools such as Informatica, Netezza, OBIEE, or Tableau.
Experience working in an Agile development lifecycle and following test-driven iterative development.

Responsibilities

Ensure the quality of technology products throughout the development and engineering lifecycle, working with application, middleware, and infrastructure teams.
Record and document testing results and compare them with expected results.
Conduct independent analysis and assessment to resolve strategic issues.
Design, develop, execute, and maintain test plans and strategies for ETL processes.
Load data from source systems to target data warehouses, data marts, and reporting systems.
Develop detailed test cases, scenarios, and scripts tailored for finance and compliance data.
Validate data transformations, aggregations, calculations, quality, accuracy, completeness, and consistency during ETL processes.
Conduct data profiling and analysis to understand patterns, detect anomalies, and identify data quality issues.
Collaborate with business analysts, data engineers, and architects to gather testing requirements, understand transformation logic, and validate ETL mappings.
Develop test automation suites and frameworks, and define standards.
Oversee test projects and provide scheduling support to operations.
Review and evaluate requirements and drive requirements for testability.
Execute and verify test cases as part of functional testing of IT products; report defects and test results to stakeholders.
Communicate the overall quality of deliverables and use metrics to guide delivery and identify areas of concern.
Strengthen quality assurance capabilities by sharing expertise, promoting technical development, mentoring employees, and building communities of practice and networks.