Specialist II-IC Quality Assurance

BMO • Tempe, AZ

1d • $55,000 - $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 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 from source systems into data warehouses, data marts, and reporting systems. It creates finance- and compliance-focused test cases, scenarios, and scripts; validates transformations, aggregations, calculations, and data quality; and profiles and analyzes data to identify patterns, anomalies, and quality issues. The role collaborates with business analysts, data engineers, and architects to gather requirements, understand transformation logic, and validate ETL mappings.

The Specialist develops test automation suites, frameworks, and standards; oversees test projects and supports scheduling for operations; reviews requirements for testability; executes and verifies functional test cases; and reports defects and results to stakeholders. The role communicates deliverable quality, uses metrics to guide delivery and identify concerns, and helps strengthen QA capabilities through knowledge sharing, employee mentoring, and communities of practice and networks.

Requirements

• Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or a related field (foreign education equivalent accepted), 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 (foreign education equivalent accepted) 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; recording test results, test coverage, and test metrics; and tracking defects with 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, data profiling, data cleansing, data reconciliation, and data integrity work using SQL, Shell scripts, Pandas (Python), and Informatica IDQ.
• Experience validating transformation business rules and 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 products delivered by technology teams throughout the development and engineering lifecycle.
• 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 to finance and compliance data.
• Validate ETL transformations, aggregations, calculations, data quality, accuracy, completeness, and consistency.
• 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, 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 guide delivery and identify areas of concern.
• Strengthen QA capabilities by sharing expertise, promoting technical development, mentoring employees, and building communities of practice and networks.

Benefits

• Health insurance
• Tuition reimbursement
• Accident insurance
• Life insurance
• Retirement savings plans
• Performance-based incentives and discretionary bonuses may be part of the total compensation package.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level