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
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.
- Zions Bancorporation Jobs