Utah IT Jobs

Mobile utah department of workforce services Logo

Job Information

Zions Bancorporation ETL Test Engineer in Salt Lake City, Utah

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

Req ID: 053070

Equal Opportunity Employer It is the policy of this corporation to provide equal employment and advancement opportunities to all employees and applicants for employment, without regard to race, color, religion, age (40 and over), sex, pregnancy, gender, disability, national origin, ethnic background, citizenship, veteran status, sexual orientation, gender identity and expression or any other characteristic protected by applicable law. This policy is established and administered in accordance with all applicable federal, state, and local laws. If you are an individual with disabilities who needs accommodation, or you are having difficulty using our website to apply for employment, please contact us at (801) 844-7628, Mon.-Fri. between 9 a.m. - 5 p.m. MST. Click here to view applicable Federal, State and/or local employment law posters.

DirectEmployers