Specialist II-IC Quality Assurance

BMO • Tempe, AZ

6d • $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 across applications, 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 detailed test cases, scenarios, and scripts for finance and compliance data, and validates transformations, aggregations, calculations, quality, accuracy, completeness, and consistency. The role also conducts data profiling and analysis to identify patterns, anomalies, and data quality issues, while collaborating with business analysts, data engineers, and architects to gather requirements and validate transformation logic and ETL mappings.

The Specialist develops test automation suites and frameworks, defines standards, oversees test projects, and supports operational scheduling. It reviews requirements for testability, executes and verifies functional test cases, reports defects and results to stakeholders, and communicates deliverable quality using metrics to guide delivery and identify concerns. The role also helps strengthen QA 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 and recording test results, test coverage, test metrics, and tracking defects using HP ALM/Quality Center or JIRA to ensure applications, products, or 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 life cycle and following test-driven iterative development.

Responsibilities

• Ensure the quality of technology products across applications, common services/middleware, and infrastructure throughout the development and engineering lifecycle.
• 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 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, data 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, 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.
• Identify opportunities to strengthen QA capabilities by sharing expertise, promoting technical development, mentoring employees, and building communities of practice and networks.

Benefits

• Health insurance
• Tuition reimbursement
• Accident and life insurance
• Retirement savings plans
• Performance-based incentives and discretionary bonuses may be included in the total compensation package, depending on pay type.

What This Job Offers

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