ETL QA

ETL QA (Data/Validation Testing) 12-24 month contract with potential to convert full time Hybrid in Oakland, CA Responsibilities: Develop efficient and effective qualitative methods, measures, and guidelines to continuously improve quality processes and practices. Perform extensive backend (preferably SQL server or other RDBMS) testing, writing medium to complex SQL scripts to validate data between multiple sources. Hands on experience with backend database testing along with ability to analyze and test different DB objects (Stored procedures, functions, views) that are used by web applications. Management and execution of test scenarios and test cases and, where possible, develop and execute automated test scripts to verify software functionality and adherence to business requirements. Experience with reports testing (ex - Tableau) to ensure data credibility and accuracy of insights derived from the BI reports. Provide accurate report of test progress to the management team and follow up with development team on defects; participate in root cause analysis discussions for all defects Work with members of Business Analysis, Application Development, and Product/Project Management to assure timely completion of testing plans. Meet aggressive deadlines while also ensuring quality changes are released into production Efficient in performing data analysis with large datasets and capable of solving loosely defined problems Perform various types of testing, including functional, Load, Regression, and Integration Ability to extract insights from data, which involves a level of analytical comprehension and manipulation Manage and execute the creation and distribution of data quality reports. Work with development team to correct data quality errors. Determine root cause for data quality errors and make recommendations for long-term solutions. Resolve all internal data exceptions in timely and accurate manner. Manage priorities in a highly dynamic environment by working closely with your supervisor and the team’s Project Manager. Working experience in HealthCare industry is highly desirable. Qualifications: Bachelor’s degree in Computer Science, MIS or similar required (minimum). A minimum of 10 years’ QA experience, including 5 or more years of manual testing Extensive backend (SQL server or other databases) testing and data analysis experience Strong proficiency with writing SQL queries and analyzing datasets. Demonstrated experience with Tableau reports testing, Tableau Desktop, Server, Prep/Conductor, data connectors, and other Tableau add-ons. Good to have hands on experience of using data analytics, data visualization tools such as Tableau. Experience testing standalone, web, backend systems and/or mobile applications. Expertise in testing methodologies, test plans and test case development. Working experience in a data science with strong knowledge of Statistics/Heuristics. Well versed with defect reporting process. Expectations: Adaptable and able to pick up new technologies and techniques quickly. Self-motivated, detail oriented and organized Must be a team player, a leader and proven ability to influence and collaborate. Excellent communication (oral and written), interpersonal, and organizational skills. Applicants must be passionate about delivering a high-quality solution to our customer base.