🌎
This job posting isn't available in all website languages
📁
Zions Bancorp/ZMSC Job Titles
💼
Enterprise Technology Operations
📅
053070 Requisition #

Zions Bancorporation’s Enterprise Technology and Operations (ETO) team is transforming what it means to work for a financial institution. We operate in a fast-paced, information-driven environment, which means we need people who bring diverse experiences, perspectives, and expertise to meet the ever-changing demands of a technology-driven world. We are grounded in the belief that “improving the work is the work” as we drive to create simple, easy, and fast solutions for our customers. Your ability to adapt, learn, and innovate helps increase revenue, reduce operational costs, and mitigates risk.

 

ETO provides opportunities for you to own your career growth through Diversity, Equity, and Inclusion, Women in Technology, and Workforce of the Future initiatives that allow you to network across the organization, volunteer in our community, and build your technical and soft skills. Together we are building a culture that values diversity and creates a space of belonging for all our team members. We believe that investing in your success is an investment in our customers and our business. Our people are what sets us apart and make us great.

 

Zions is currently seeking an ETL Test Engineer to review design and data flow documentation, and verify target system structure and its schema, the constraints applied in the system.  Will perform data completeness and reconciliation, data quality validation and verify ETL load strategies.  This position requires strong QA experience with a focus on data, knowledge of data pipelines from raw data to reporting, and demonstrable SQL expertise. The ETL Test Engineer will work closely with the offshore Data Test Lead, work with Scrum teams and Product Manager to address how to provide better quality coverage for the applications supported.

 

Ideally this position will be in Salt Lake City, UT but there is a possibility of working remotely.  This individual will also have the following responsibilities:

 

  • Develop and execute interface test scenarios and test scripts for complex business rules using available ETL tools
  • Review interface design documents, analyze requirements and work with flat files, database dumps, XML/XSD to achieve expected results
  • Perform root cause analysis, database validation, and data defect identification using SQL
  • Create/Identify test data to validate functional and technical requirements
  • Trace requirements to test cases to ensure coverage for full system integration test
  • Coordinate the resolution of problem inhibiting test progress
  • Monitor and lead testing efforts of offshore testers
  • Define, execute, and track status of test cases
  • Execute and analyze results of automated tests
  • Detect, communicate, and track defects through the utilization of effective trend analysis
  • Escalate risks and progress reporting to Scrum team and QA management
  • Continuously assess and enhance overall testing effectiveness and efficiency
  • Perform all other duties as requested or assigned

 

Qualifications

 

  • 4+ years of software testing experience.  A combination of education and experience may meet qualifications.
  • Hands on experience with Data Warehouse & ETL Testing
  • Hands on experience of testing of Informatica jobs; Prefer experience with IBM DataStage
  • Advanced SQL skills for creating complex queries to compare data between Source & Target
  • Analytical approach to identify data mismatch issues
  • Ability to perform source system analysis
  • Understands Data Warehouse implementation, design test approach/test cases & test data creation
  • Understands existing system data flow & queries
  • Minimum of intermediate level automation tool experience required
  • Expert knowledge of test planning, test case development, execution, and reporting
  • Recent experience testing in Agile teams
  • Experienced working remote and in geographically distributed teams
  • Successful experience working with offshore teams
  • Excellent communication and analytical skills
  • Experience with XML, JSON, SOAP and REST APIs.
  • A Bachelor’s Degree in Computer Science, Electrical Engineer, or Information Systems preferred

 

 

Pay Range: $90,000-$115,000

To review our Benefits Summary click here.

 

Zions Bancorporation and its affiliates and divisions (“Zions”) is an equal opportunity employer which prohibits all forms of discrimination and harassment. Zions is committed to the principle of equal employment opportunity for all employees and employment candidates and to providing a work environment free of discrimination and harassment. All employment decisions at Zions are based on business needs, job requirements and individual qualifications, without regard to race, color, religion, ethnicity, sex, sexual orientation, gender identification, age, national origin, pregnancy, veteran status, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. Zions will not tolerate discrimination or harassment based on any of these characteristics. Zions encourages applicants of all ages.

 

It is Zions’ policy not to discriminate because of a person’s relationship or association with a protected veteran. This includes spouses and other family members. Also, Zions will safeguard the fair and equitable treatment of protected veteran spouses and family members with regard to all employment actions and prohibit harassment of applicants and employees because of their relationship or association with a protected veteran.

 

Applicants Requesting Accommodations: If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access our career site.  You can request reasonable accommodations by contacting us at careers@zionsbancorp.com or 801/844-7628.  Please email your resume/cover letter, indicate what position you are interested in and include "Accommodation needed" in the subject line to ensure your information is routed to the appropriate contact.

 

Click here to view our EEO Statement.

 

Click here to view applicable Federal, State and/or local employment law posters.

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

Enterprise Services

Salt Lake City, Utah, United States

📁 Zions Bancorp/ZMSC Job Titles

Requisition #: 053094

Enterprise Services

Salt Lake City, Utah, United States

📁 Zions Bancorp/ZMSC Job Titles

Requisition #: 052203

Enterprise Technology Operations

Salt Lake City, Utah, United States

📁 Zions Bancorp/ZMSC Job Titles

Requisition #: 053095