ETL Data QA Specialist

BMO Bank N.A.

Tempe (AZ)

On-site

USD 55,000 - 120,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
Tuition reimbursement
Accident and life insurance
Retirement savings plans

Job summary

BMO Bank N.A. seeks a Specialist II-IC Quality Assurance to ensure quality of technology-delivered products, collaborating with applications, middleware, and infrastructure teams throughout the lifecycle.

You will design, develop, execute, and maintain ETL test plans, and perform extensive data validation across data warehouses and reporting systems. Responsibilities include data profiling, validating transformation rules, and building automated testing frameworks.

Qualifications

  • Bachelor's degree/Master's degree with experience testing ETL processes and QA automation.

Responsibilities

  • Record and document testing results and compare to expected results.
  • Design, develop, execute, and maintain test plans and strategies for ETL processes.
  • Load data from source systems to target data warehouse, data mart and reporting systems.
  • Develop test automation suites, design 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 and report defects to stakeholders.
  • Communicate overall quality and drive metrics to improve delivery.

Skills

SQL
QA automation
ETL testing
Data validation
Agile development

Education

Bachelor's degree in Computer Science, Computer Engineering, Information Systems or related field
Master's degree in Computer Science, Computer Engineering, Information Systems or related field

Tools

HP ALM/Quality Center
JIRA
SQL Developer
TOAD
Oracle
Teradata
MS SQL Server
Informatica IDQ

Job description

BMO Bank N.A. seeks a Specialist II-IC Quality Assurance to ensure quality of technology-delivered products, collaborating with applications, middleware, and infrastructure teams throughout the lifecycle.

You will design, develop, execute, and maintain ETL test plans, and perform extensive data validation across data warehouses and reporting systems. Responsibilities include data profiling, validating transformation rules, and building automated testing frameworks.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL QA Specialist II - Data Quality & Automation
ETL QA Specialist II - Data Quality & Automation

BMO • Tempe (AZ)

On-site
USD 55,000 - 120,000
Health insurance
Tuition reimbursement
Accident and life insurance
+1
ETL QA & Data Integrity Specialist II
ETL QA & Data Integrity Specialist II

Bank N.A. • Tempe (AZ)

On-site
USD 55,000 - 120,000
Health insurance
Tuition reimbursement
Accident and life insurance
+1
Senior QA Specialist (Hybrid) — Automation & Quality
Senior QA Specialist (Hybrid) — Automation & Quality

BMO Bank N.A. • Bay De Noc Township (MI)

Hybrid
USD 116,000 - 152,000
Health insurance
Tuition reimbursement
Retirement savings plans
Automation QA Engineer - ETL/Data Streaming
Automation QA Engineer - ETL/Data Streaming

Bank of America Corporation • Addison (TX)

On-site
USD 120,000 - 180,000
Data Quality Engineer: ETL & Big Data Testing
Data Quality Engineer: ETL & Big Data Testing

International Business Machines Corporation • Durham (NC)

On-site
USD 90,000 - 130,000
Automation QA Engineer – ETL, Data & Streaming
Automation QA Engineer – ETL, Data & Streaming

Bank of America Corporation • Newark (DE)

On-site
USD 120,000 - 160,000
Specialist II-IC Quality Assurance
Specialist II-IC Quality Assurance

Bank N.A. • Tempe (AZ)

On-site
USD 55,000 - 120,000
Health insurance
Tuition reimbursement
Accident and life insurance
+1
Automation QA Engineer – ETL & Real-Time Data
Automation QA Engineer – ETL & Real-Time Data

Bank of America • Vermont

On-site
USD 120,000 - 170,000
ETL QA Engineer
ETL QA Engineer

Groupe Kardol • Princeton (NJ)

On-site
USD 85,000 - 120,000
ETL Tester — Data Quality & Warehousing Expert
ETL Tester — Data Quality & Warehousing Expert

Groupe Kardol • Jersey City (NJ)

On-site
USD 70,000 - 110,000