Sr QA Engineer I - ETL / Data Warehouse

company banner
Bank of the West
.Net, Analysis, Analyst, Automated, BI Tools, Data Analysis, Database, Data Warehouse, Defect Management, Developer, Development, HTTP, Informatica, Knowledge Management, Linux, Manager, Management, Metrics, Oracle, PL/SQL, Project, Project Manager, QA, Quality Center, Scripts, Shell Scripting, Shell Scripts, SQL, Testing, Test Plan, Unix
Full Time
Work from home not available Travel not required

Job Description

Sr QA Engineer I - ETL / Data Warehouse - ( 041157 )


At Bank of the West, our people are having a positive impact on the world. We re investing where we feel we can make the most impact, like advancing diversity and women entrepreneurship programs, financing for more small businesses, and promoting programs for sustainable energy. From our locations across the U.S., Bank of the West is taking action to help protect the planet, improve people s lives, and strengthen communities. We are part of BNP Paribas, a global leader supporting the UN Sustainable Development Goals (SDGs). Yes, we re a bank, but as the bank for a changing world, we are continually seeking to improve the ways we help our customers, while contributing to more sustainable and equitable growth.

While Bank of the West considers all applicants, we will not sponsor candidates for work visas at this time.

Job Description Summary

This resource will be part of QA Center of Excellence team for ETL/Data warehouse testing projects. Primary responsibilities would be, understand requirements & data mapping, define test plan, develop test cases & technical test scripts, conduct reviews and execute test cases.

Resource should be primarily interacting with Dev team, BSA, Data Analyst, and Data architects to understand project requirements, Technical design, downstream systems impact and data mapping. Resource should participate in daily status meetings to provide accurate QA status with Project manager. Should be able to understand data mapping and document test cases and test scripts independently and have excellent team player skills to work with cross domain teams in a dynamically changing environment.

Essential Job Functions

  • Create & Execute software test design, test strategies, test cases for Bank s Treasury systems such as ALMT, ILM and FARM.
  • Perform detailed Data Analysis, Data Profiling, Data Cleansing, Data Reconciliation and Data Integrity using SQL, Shell scripts and other approved tools
  • Implement approved test automation framework for functional, regression and E2E testing.
  • Develop complex PL/SQL & SQL scripts using Oracle Toad & SQL Developer tools to validate the ETL process/design implemented in Informatica Power Center, Informatica IDQ and Denodo Platform Control Center from Heterogeneous source systems to Enterprise Data Warehouse and Regulatory data marts.
  • Develop database analytical/aggregation functions and stored procedures to validate different drill down metrics and dashboards in OBIEE Reporting.
  • Schedule and execute TIDAL jobs for end to end ETL process implemented in multiple products/software like Informatica MDM, Informatica Address Doctor, Denodo and ESB using UNIX shell scripting, Workflow Monitor and Workflow Manager tools to perform integration and regression test.
  • Define and document software test plan and perform several phases of testing cycles and record test results, test metrics and track defects using HP ALM/Quality Center and JIRA tools in order to ensure applications, products and/or releases are in compliance with Bank of the West`s QA standards.
  • Partner with test leads at onsite and offshore, architects and senior management to recommend quality improvement best practices and processes based on current and emerging technologies/applications/software.

Other Job Duties

  • High level of personal commitment to each task, a can do attitude and a drive to deliver.
  • Strong communication skills to be able to communicate at all levels.
  • Ability to understand banking financial requirements.
  • High level of responsibility and Ownership from inception through to implementation.
  • The candidate should have a proactive approach to problem solving.
  • Good analysis skills in order to aid in trouble shooting and problem solving.
  • Good testing principles as well as good defect management skills should have experience in handling.
  • Multiple assignments at same time and long with other team members.



  • Bachelor's Degree in Information Technology or Computer Science
Required Experience

  • Overall 8+ years of experience of IT experience with minimum of 6+ years of ETL/ Data Warehouse Testing.
  • Experience in writing complex SQL & PL SQL statements to test ETL code based on the data mapping & requirements provided and perform extensive data analysis to identify the defects.
  • Strong Data ware house and BI concepts.
  • Experience in working testing through Informatica or related ETL tools, Oracle database, BI tools like OBIEE, etc. and has experience working with UNIX/LINUX.
  • Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and upgrade projects.
  • Experience in testing data warehouses systems and have defined test approaches for data warehouse projects.
  • Experience in creating Test plan, test cases and engineering best practices related to software test engineering, both manual and automated testing.
  • Experience coordinating testing activities and optimizing test cycles working with project team.
  • Experience with utilization of appropriate test methodologies and use of test management tool like HP ALM.
  • Experience with conducting and running defect triage meeting with project teams.
  • At least 3 - 5 years experience of working with financial services applications.
  • Strong in STLC process, Test Strategy/Plan, Test Estimation
  • Effective Project & People Management Skills, exposure to Knowledge Management. Solid time management and prioritization skills.
  • Excellent verbal and written communication skills.

Preferred Skills

  • Domain knowledge & previous experience with Banking and Financial service domain knowledge.
  • Passion towards giving technical solutions and using different testing tools.
  • ETL test automation.
  • Experience working with Database upgrades, tool upgrades and Interface testing.
  • Should have experience in handling multiple assignments at same time and long with other team members.
  • Should be best team player.

Equal Employment Opportunity Policy

Bank of the West is an Equal Opportunity employer and proud to provide equal employment opportunity to all job seekers without regard to any status protected by applicable law. Bank of the West is also an Affirmative Action employer - Minority / Female / Disabled / Veteran.

Bank of the West will consider for employment qualified applicants with criminal histories pursuant to the San Francisco Fair Chance Ordinance subject to the requirements of all state and federal laws and regulations.

Primary Location

: United States-Arizona-Tempe


: Technology

Job Posting

: Jul 16, 2019, 7:11:26 PM

Company Information

About Us
At Bank of the West, your money has values as well as value. We know money deposited in a bank has the power to finance positive change. So we are taking action to support activities that help protect the planet, improve people’s lives, and strengthen communities. We are redefining banking for a better future by focusing on areas where we believe we can have a real impact: supporting energy transition, helping enable women entrepreneurs, and financing innovative start-ups. As the bank for a changing world, Bank of the West is committed to sustainable finance along with our parent company BNP Paribas. Through Digital Channels and offices across the U.S., Bank of the West provides financial tools and resources to more than 2 million individuals, families and businesses. © 2019 Bank of the West. Member FDIC. Equal Housing Lender Doing business in South Dakota as Bank of the West California.

Our values
At Bank of the West, we are committed to our employee experience values: We Work Together, We Develop, We Innovate and We Care. The values reflect a 145-year history of caring for customers, communities and each other. They’re about respect and treating everyone as individuals. By defining them we’re making a proud declaration about who we are and what we stand for. Learn more about our commitment to community
Dice Id : 91008860
Position Id : 041157
Originally Posted : 1 month ago

Similar Positions at Bank of the West

**QA Engineer II-ETL Data Warehouse
  • Tempe, AZ
  • 16 hours ago
QA Engineer-ETL / Data Warehouse
  • Tempe, AZ
  • 16 hours ago
Sr QA Engineer I
  • Tempe, AZ
  • 16 hours ago
QA Engineer-Automation
  • Tempe, AZ
  • 16 hours ago
Sr Software Engineer
  • Tempe, AZ
  • 16 hours ago
QA Engineer II
  • Omaha, NE
  • 16 hours ago
AML\SAM Sr. Technical Analyst
  • San Ramon, CA
  • 16 hours ago