Software Quality Team Lead, Data Warehouse & ETL - Eden Prairie, MN & Rocky Hill, CT

Company Name:
UnitedHealth Group
Position Type:
As a
Software Quality Team Lead
, you will work as a part of a dynamic team involved in testing for new systems and enhancements of existing Data Warehouse and ETL applications. This role will involve the use of both manual and automated testing tools, test script and test plan creation and maintenance, and defect tracking and reporting.
The Software Quality Team Lead will be responsible for both leading a team and performing hands on testing of 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.
Work concurrently on several projects, each with specific instructions that may differ from project to project
Ensure that quality processes are carried out through all phases of the Software Development Lifecycle
Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ensures that quality assurance processes are incorporated
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 walkthrough, 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
Apply solid 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
Minimum of 5 years of Quality Assurance/Software Testing experience
Minimum of 3 years of testing experience with BOTH Data Warehouse and ETL applications
Minimum of 3 years of experience as a QA team lead
Minimum of 2 years of experience leading a QA team in an onshore/offshore model environment
Minimum of 3 years of experience with Quality Center/ALM
Minimum of 3 years of experience working with full Software Development Life Cycle within a formal development methodology
Minimum of 3 years of relational database experience (ie, Oracle, SQL Server, Teradata, DB2, etc.)
Experience working with multiple data sources and variety of data source formats
Experience validating data sources via various methods
Experience working with databases or data warehouses consisting of at least 20 tables
Bachelor's degree or equivalent professional experience
Proficiency in MS Office (Word, Excel, Outlook)
Outstanding verbal and written communication skills
Experience validating data utilizing SAS
Experience with UNIX
Agile methodology experience strongly preferred
Service Oriented Architecture (SOA) experience
Proficiency with MS Visio and MS PowerPoint
Healthcare industry experience strongly preferred
UnitedHealth Group is a company that's on the rise. We're expanding in multiple directions, across borders and, most of all, in the way we think. Here, innovation isn't about another gadget, it's about transforming the health care industry. Ready to make a difference? Make yourself at home with us and start doing
your life's best work.(sm)
OptumInsight is part of the family of companies that make UnitedHealth Group one of the leaders across most major segments of the US health care system.
OptumInsight is one of the largest and fastest growing health information companies. We specialize in improving the performance of the health system by providing analytics, technology and consulting services that enable better decisions and results. We integrate workflow solutions that deliver data in realtime, and create actionable insights processing health information that relates directly to and affects one in four patients in the U.S, one in every three Medicaid dollars and one in every five emergency room visits. And we do it all with every action focused on our shared values of Integrity, Compassion, Relationships, Innovation & Performance.
What can YOU do with the right information? At OptumInsight, the possibilities and the impact are limitless. No matter what your role is at OptumInsight, you'll be empowered to ask more questions, develop better solutions and help make the health care system greater than ever. It's always fresh. It's always exciting. And it's never been more important.
Diversity creates a healthier atmosphere: equal opportunity employer M/F/D/
UnitedHealth Group is a drugfree workplace. Candidates are required to pass a drug test before beginning employment. In addition, employees in certain positions are subject to random drug testing.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.