Quality Assurance Data Integration Engineer

Overview

Required Skills and Experience 1. Bachelor's Degree Business Administration, Information Science, Computer Science, Computer Engineering, Information Technology or relevant field required. 2. Master's Degree Business Administration, Information Science, Computer Science, Computer Engineering, Information Technology or relevant field preferred. 3. 3 years of experience working as a Quality Assurance Engineer with at least 2 years of recent experience developing complicated SQL scripts needed to validate database ETL results required. 4. 1 year of experience working in a healthcare or related field preferred. 5. Experience with Quality Assurance testing methodologies and procedures. 6. Experience using HP Quality Center and UFT or equivalent Quality Assurance software. 7. Experience with database testing using SQL to query, create tables, views, indexes, joins, user defined functions, and stored procedures. 8. Knowledge of the SDLC, ITSM and privacy and security concepts. 9. Able to take on multiple projects concurrently and manage changes in scope along the way. 10. Strong communication and interpersonal skills. What You Need to Know - Develop complex SQL scripts to test results of database ETL processes using SQL commands including: JOIN, WHERE, CREATE, MINUS, UNION, functions such as: MAX, MIN, AVG. Ability to join 5-7 tables with numerous filter criteria to validate ETL results. Create temporary tables for comparing data or excluding duplicates. - Collaborate with business, analysts, BI team, ETL team, and SMEs to design efficient testing strategies to support development of data integration solutions using HP Quality Center, UFT, FastTrack, SQL, or other technologies. Execute on automating testing processes. - With minimal guidance, work with business sponsors, SMES and application teams to understand the business requirements; review business and technical specifications; design and document testing strategies, plans, cases, and validation scripts needed to confirm proper availability and quality of source system data. Design and develop testing solutions that confirm the business needs are met. - Collaborate with business, analysts, BI team, application teams and other stakeholders to design testing strategies to support development of data integration solutions that are fully integrated into the Enterprise Data Warehouse and support Business Intelligence testing needs.

Benefits

Company

This health system is one of the largest faith-based, nonprofit health care delivery systems in the United States. It has 29 hospital locations including 19 acute-care hospital locations, five short-stay hospitals, two behavioral health hospitals, two rehabilitation hospitals and one transitional care hospital, all owned, operated, joint-ventured or affiliated with the system. It has more than 3,900 licensed beds, employs more than 24,000 people, and counts more than 6,000 physicians* with active staff privileges at its hospitals.