Data Warehouse Selenium QA Tester

Position Summary:

The MassHealth Systems Teams unit seeks a highly motivated individual as a Quality Assurance Tester to join its Data Warehouse Systems Quality Assurance (SQA) team. The Quality Assurance Tester will be responsible to work on complex projects within the Healthcare Domain and applies a knowledge of software testing and analysis concepts, practices, and procedures. Requires experience in all phases of software development life cycle and testing methodologies. Experience should include testing of functional/non-functional scenarios in support of integrated multi-platform systems. The individual should work in compliance with HIPAA requirements.

Detailed List of Duties and Responsibilities:

• Create test models for release testing (plans, data, and scripts) including the identification, collection and/or creation of test data
• Lead coordination and execution of release testing as appropriate
• Determine and meet time estimates and schedules for testing efforts
• Define Release Test Plans and criteria for user acceptance including entry/exit criteria
• Develop, update, and maintain quality testing standards and procedures
• Communicate effectively with customers and software vendors as appropriate
• Assist in the planning, creation, and control of the test environment(s)
• Follow standard testing methodology frameworks, testing processes as a standard
• Coordinate testing specific release activities
• Determine and meet time estimates and schedules for testing efforts
• Create test models for release testing (plans, data, and scripts), participate in structured walk-through and peer reviews
• Participate in the coordination and execution of release testing
• Participate in Lessons Learned as appropriate
• Identify defects and questionable functionality; manage defects through to closure
• Resolve issues with unclear requirements and achieve a successful result
• Triage and solve complex problems using structured troubleshooting methodologies
• Work independently as well as work collaboratively in a team environment
• Ability to design and develop a scalable and reliable automation test scripts.
• Identify areas of optimization and improvement in the testing process.
• Document test automation framework design.
• Responsible for System testing of Ad-Hoc Query Packages in Cognos which involves execution of Ad-hoc reports and corresponding test SQLs based on various join conditions and filters and calculations.

Required Skills and Abilities:

• Hands on experience of end-to-end integration testing, Ability to Come up with the End-to-end test scenarios and test cases.
• Understanding of companion and implementation guides of Health care EDI format.
• Strong experience in Test Automation and EDI, HIPAA, PHI and NCPDP Testing.
• Should have good experience in Claims, Eligibility, Membership, Enrollment process, diagnosis, and procedure codes.
• Database knowledge to run DDL, DML, and other SQL commands.
• Ability to review scenarios with Business and get sign off on Testing scenarios/strategies.
• Experience with participating in daily Scrum, Sprint Planning and Status reports.
• Must have Tools: Selenium, HP Load Runner, TOAD for Oracle 12.6, Python, Oracle SQL Developer 18.2, PL/SQL, UNIX, AWS, FileZilla, Microsoft Visio, WinSCP, Java, MS Office, Atlassian JIRA, Putty, COGNOS.
• Prior experience working in healthcare or government setting with a strong knowledge base in healthcare insurance principles, eligibility, and Medicaid Management Information System (MMIS).
• Ability to independently query transactional and Data Warehouse databases.
• Experience with data quality and remediation, data flows and mapping, or comparable experience (system or Data conversions, for example).
• Test automation framework development using Selenium, Junit/TestNG, REST Assured tools.
• Programming language, preferably JAVA and good understanding of object-oriented design techniques.
• Proficient using XPath and CSS Selectors. Able to derive customized Xpaths.
• Experience in Jenkins, Maven, SVN, Git, and XL Deploy.
• Experience using Version controller tools like SVN / GIT
• Experience in test management, Build and CI/CD tools like ALM, Maven, Jenkins and XL Deploy as preferred.
• Must possess excellent verbal and written communication skills.
• Familiarity of testing types: black-box, white-box, functional, smoke, and regression.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to deliver on time, while working in a semi-autonomous environment.

Education and Experience:

• Bachelor of Science in Computer Science, related degree, or equivalent work experience.
• Knowledge of QA Methodologies and the software development lifecycle.
• 5 years of experience black-box, white-box, functional, smoke, and regression testing.
• 5 years of experience designing and maintaining test automation frameworks for web-based applications.
• 3 years of experience designing and maintaining web service automation test suites and frameworks.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong verbal, written and presentation skills.
• Proficiency in MS Office, i.e., Word, Excel, PowerPoint, Access, and Visio.
• Government and or Healthcare prior experience desired.