Specialist II-IC Quality Assurance

Bank of Montreal•Tempe, AZ

4d•$129,290 - $129,290

About The Position

BMO Bank N.A. seeks a Specialist II-IC Quality Assurance professional 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 involves testing ETL processes and finance and compliance data, documenting results, analyzing issues, and helping ensure that technology products and releases meet quality standards. The successful candidate will develop and maintain test strategies, plans, cases, scenarios, scripts, and automation; validate data transformations and integrations; and report defects, test outcomes, and quality metrics to stakeholders. The role also supports test project scheduling and strengthens the organization’s quality assurance capability through expertise sharing, mentoring, and communities of practice.

Requirements

Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or a related field, or foreign educational equivalent, plus four years of experience as a Software Engineer, QA professional, or in a related occupation testing ETL processes, writing SQL to validate data transformations in enterprise data warehouses and data marts, and performing QA automation; alternatively, a master’s degree in one of those fields or foreign equivalent, plus two years of such experience.
Experience defining test plan processes and recording test results, test coverage, and test metrics, and tracking defects using HP ALM/Quality Center or JIRA to ensure applications, products, and releases follow 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, 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

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 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.
Work 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, evaluate, and drive requirements for testability.
Execute and verify test cases as part of functional testing of IT products, and report defects and test results to stakeholders.
Communicate the overall quality of deliverables and use metrics to drive delivery and identify areas of concern.
Identify opportunities to strengthen quality assurance capabilities by sharing expertise, mentoring employees, and building communities of practice and networks.