Specialist II-IC Quality Assurance

Bank of Montreal•Tempe, AZ

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 applications, common services and middleware, and infrastructure teams throughout the development and engineering lifecycle. It records and documents test results, compares them with expected results, and conducts independent analysis to resolve strategic issues. The position designs, develops, executes, and maintains test plans and strategies for ETL processes, including loading data into data warehouses, data marts, and reporting systems. It performs extensive validation of data transformations, aggregations, calculations, quality, accuracy, completeness, and consistency; profiles and analyzes data to identify patterns, anomalies, and quality issues; and collaborates with business analysts, data engineers, and architects to gather testing requirements and validate transformation logic and ETL mappings. The role also develops test automation suites, frameworks, and standards; oversees test projects and provides scheduling support to operations; reviews requirements for testability; executes and verifies functional test cases; reports defects and results to stakeholders; and communicates deliverable quality through metrics. It identifies opportunities to improve quality assurance capability 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 equivalent), plus four years of experience as a Software Engineer, QA professional, or in a related occupation; alternatively, a master's degree in one of these fields (or foreign equivalent), plus 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 and recording test results, test coverage, test metrics, and 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 data analysis, profiling, cleansing, reconciliation, and integrity checks 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 in collaboration with application, common services/middleware, and infrastructure teams.
Record and document test 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 into target data warehouses, data marts, and reporting systems.
Develop detailed test cases, scenarios, and scripts for finance and compliance data.
Validate ETL transformations, aggregations, calculations, data quality, accuracy, completeness, and consistency.
Conduct data profiling and analysis to understand data patterns, detect anomalies, and identify data quality issues.
Work with business analysts, data engineers, and architects to gather testing requirements, understand transformation logic, and validate ETL mappings.
Develop test automation suites and design frameworks and 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, and report defects and test results to stakeholders.
Communicate the overall quality of deliverables and use metrics to guide delivery and identify concerns.
Strengthen quality assurance capabilities by sharing expertise, mentoring employees, and building communities of practice and networks.