Previous Job
Previous
Principal Quality Engineer
Ref No.: 18-00499
Location: San Francisco, California
Position Type:Contract
Start Date: 09/10/2018
Role: Pricipal Quality Engineer
Location: San Franscisco, CA
Interview Mode: Skype
Duration: 9 Months+
Experience: 11+ Years



Responsible for helping ensure product quality, through the planning and execution of: 1) product testing, and/or 2) process/product standards compliance. This person may have direct involvement in manual or automated test efforts or in developing and managing compliance to standards for process or product quality. Provides team and management with objective insight into processes and associated work products. Depending on the need and skill level, there may be more technical and/or planning and leadership dimensions to this role.
Financial responsibilities
Where applicable, participates in process improvement project according to an approved business case and budget. 
May be involved in defining scope or process for audit or compliance certification with external vendor.
Participates in identifying requirements for and procuring necessary test and defect management tools.
Accountabilities 
• Develop automated and manual SQL test scripts to test ETL loads, data aggregations, data conversions, data extracts and the data warehouse
• Identify test data requirements and create test data as needed
• Execute tests, document and publish test results
• Communicate issues to the team and assist in root cause analysis
• Provide a critical role in a highly-agile Scrum environment working against light requirements
• Must be comfortable working in time-sensitive, mission-critical situations with end-users
• Provide leadership and mentoring to other Test Engineers
• Contribute to quality assurance standards and procedures
• If appropriate to role, define comprehensive test or product/process quality strategy and plan aligned with project scope, and quality processes and targets. A test strategy encompasses manual and automated test efforts.
• If appropriate to role, direct and monitor the full range of testing or process auditing activities within team for the project's lifecycle in collaboration with project/program management. 
• If appropriate to role, define and institutionalize testing processes or development methodologies and guidelines across organization. Ensure adherence to all quality processes followed in the team. This responsibility can include establishing and institutionalizing standards for reporting, manual and automated test creation and execution, etc.
• If appropriate to role, keep view to product quality and trends. Develop and leverage an understanding of gaps and how they can be improved by test and/or process efforts to improve product stability and quality. Propose ROI-based approaches to address gaps.
• Assure product quality through the development of 'net-new' manual or automated test scripts. This effort should maximize the ROI while minimizing quality risks. Output consistent with department's guidelines.
• Assure process quality and consistency through development or adherence to guidelines and standards appropriate to product and industry and/or development life cycle.
• Leverage (if necessary, develop) metrics-based governance, relevant reporting and audit mechanisms. Assist project manager in identifying data to maintain, and KPIs to analyze and report against.
• When involved in testing, ensure test design is traceable to requirement and achieves a high level of requirement and test execution coverage. Continuously improve test scripts and product coverage. Complete all updates test cases, test scripts, test harnesses, test guidelines according to schedule.
• Execute all assigned testing, whether manual or automated, according to schedule and any productivity targets committed.
• Support root cause analysis exercises against target areas, propose corrective approaches for measurable improvements, track and report progress; communicate the plans and results effectively to drive change. Collect and analyze data and other findings, according to plans. 
• Produce reports that are clear, effective, insightful, and traceable – whether for defects discovered during test or non-compliance issues found during a process review or audit. Utilize existing tracking systems, report mechanisms, agreed conventions, and metrics when preparing and providing such reports.
• Escalate concerns about project/product/process quality in clear, timely, collaborative, constructive way.
• Knowledgeable and conversant in defect prevention and associated tools and methodologies.
• Participate in improvement initiatives. Develop Quality Assurance plans or Test Plans and embed appropriate activities as part of project/product development plans.
• Objectively evaluate processes and products against applicable standards, and procedures.
• Participate in defect reviews or other project efforts, providing clear status when needed. 

Skill Set Desired: 
• Self starter with excellent communication skills
• 5+ years of experience writing complex SQL, stored procedures and scripts to support test activities
• 5+ years of database centric test experience with at least 2 years in a multi-terabyte Data Warehouse environment
• 2+ years of experience executing as part of a Scrum team
• 2+ years of experience with a script language
• Familiarity with Data Warehouse dimensional modeling concepts
• Experience in an environment that uses ETL tools such as Informatica, Data Stage, AbInitio, Talend, SSIS, or other data integration platform

Bonus
• Healthcare Industry experience knowledge of CCDA and Clinical Quality Measures (CQM) 
• Experience with data warehouse appliances such as Netezza, Greenplum or Teradata 
• Experience in C#, Java, Python, Ruby or Selenium 
• Experience with MS SQL Server and Mongo
• Hands on experience with Informatica
• Experience testing Tableau reports
• Jenkins or similar continuous integration systems 

Specific Requirements: 
Academic and professional qualifications
• Successful completion of a Bachelor's Degree in a relevant Program of study is mandatory. Relevant
post graduate qualifications and professional memberships will be preferred. It is essential that a
person at this level of seniority proactively maintain awareness of test and/or quality tools, processes
and standards in the industry to improve product or process quality to define and lead