Quality Assurance Lead - Data Warehouse - Eden Prairie, MN or Rocky Hill, CT - Full-time / Part-time

As a Quality Assurance Lead – Data Warehouse, you will be involved in testing for new systems and enhancements of existing Data Warehouse and ETL applications.  Database technologies utilized may include a variety of Oracle, Teradata, DB2, SQL Server or other enterprise relational databases.  Testing of these applications will also involve performing Extract/Transform/Load of data to the Data Warehouse. Data files will be validated with UNIX and SAS.

Your primary responsibilities in this role will include:

• Analyze and dissect system requirements and technical specifications to create and execute test cases for large business initiatives


• Ability to write test cases and execute testing within a web service environment 


• Product test and driving defect resolution 


• Assist business users in defining User Acceptance Testing, test cases and plans 


• Establish and maintain test cases and test data 


• Create and maintain test cases in Quality Center and/or Test Director 


• Actively participate in walk-through, inspection, review and user group meetings for quality assurance 


• Work with business users, system analysts, designers and programmers to create and analyze various required project documents 


• Participate in production implementation verification and being accountable for validating system quality 


• Plan, document, evaluate and track testing results to ensure system applications are free from defects 


• Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and /or functionality within Information Technology software 


• Comply with standards of the software development life cycle and follow strategies, plans and procedures within information Technology software 


• Comply with standards and strategies of the software development life cycle


• Good understanding of the Software Development Life Cycle, Data Warehouse ETL and QA process. 


• Participate in Requirements and Design reviews, plan and estimate the QA effort. 


• Plan test strategies in accordance with project scope and develop schedules to meet delivery dates. 


• Design test plans, scenarios, scripts, or procedures. 


• Develop testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or defect retests, or usability 


• Develop process for Data Analysis and testing Data flow. 


• Test system modifications to prepare for implementation. 


• Document defects, using a HP Quality Center, and report defects to Project teams 


• Identify, analyze, and document problems with functionality , output files or tables. 


• Monitor defect resolution efforts and track successes. 


• Create Metrics and status reports for projects. 


• Support QA management with information for issues escalation or concerns.


• Reviews the work of others.


• Develops innovative approaches.


• Sought out as expert.


• Serves as a leader/ mentor.

• High School Diploma/GED


• 2+ years of experience with Quality Assurance testing


• 1+ years of experience with ETL (Extract, Transform, Load)


• 1+ years of experience testing in a Data Warehouse environment


• 1+ year of experience with the Agile Methodology


• 1+ years of experience with a relational database


• 1+ years of experience with the Software Development Life Cycle (SDLC)

• Experience with Service Oriented Architecture (SOA)


• Experience with Microsoft Project or Microsoft Visio


• Experience in the healthcare industry


• Experience leading a team


• Experience with SAS Scripting


• Experience working with 5 or more data sources


• Experience testing in a large, complex data warehouse environment

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world?s large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.SM

Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.

UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment. In addition, employees in certain positions are subject to random drug testing.