ETL Tester (Healthcare)

Description

Primary Responsibilities This role will be responsible for planning and creating productionlike datasets for testing needs. You will participate in discovering, designing, extracting, masking/deidentifying existing data, developing, and maintaining test data using appropriate test data management tools and techniques. To accomplish this work candidate will provide the rightsized, productionlike, reusable test data for development and QA testing requirements/needs. Focus specifically on maximizing test data reuse, data safety, initial state repeatability with any profiling, cataloging and versioning needed.A solid knowledge of databases (particularly Oracle/DB2/SQL), and deidentifying PHI data is necessary for this role. Working with QA and developers and understanding their data needs for development and testing will be a key activity. The QA Analyst will develop, publish, and implement test plans and is responsible jointly developers and analysts for the quality of data and software created for business intelligence applications.This position defines and tracks quality assurance metrics and works with the development team closely to meet quality goals. With little direct supervision, the selfmotivated tester will research new technologies, develop test strategies and documentation, and help developers identify potential issues in data products. Experience with SQL queries and database testing is a must. QA analyst will have a working knowledge of quality assurance methodologies and tools. Experience with and knowledge of healthcare data and software is an essential component of success in this role. This position reports to the QA Manager, Web Services. Qualifications 810 years minimum experience in software testing with a majority of this experience working on ETL testing and tasks like creating test cases/plans, executing test cases, reporting, generating matrices, debugging and defect management.Excellent working knowledge of manual validations on applications built using Microsoft .Net, C#, ASP.Net and SQL Server, SharePointDevelop and implement SQL Scripts, Stored ProceduresValidating SQL Server Reporting, Analysis and Integration Services (SSRS, SSAS and SSIS)Experience with manual ETL processes.Visual Studio with Team Foundation ServerConsistently exhibits behavior and communication skills that demonstrate commitment to superior customer service, including quality, care and concern with each and every internal and external customer.Work as team lead for back end quality assurance of applications.Develops documentation to support ongoing testing and specific problem resolution.Assists in the successful completion of IT projects and tasks.Collaborates with endusers to improve ability to utilize system capabilities by determining problems and developing appropriate solutions.Follows Quality Assurance standards.Communicate all key project plans, commitments, and changes including requirements, QA plans, schedule, and scope changesCoordinate the GoLive activities including the execution of the deployment Plans and checklists.Well versed in software engineering principles, frameworks and technologies.Uses, protects, and discloses HCP patients protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards.