Lancesoft logo

Data Warehouse QA Tester

Lancesoft
  • Quincy, MA
  • $55
  • Quick Apply
30+ days ago

Job Description

Job Title: Data Warehouse QA Tester
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 for working on complex projects within the Healthcare Domain and applying 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, and 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), and 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 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 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, Client 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.

Numbers & Facts

LocationQuincy, MA
IndustryStaffing/Employment Agencies
Salary$55
Company Size2,000 to 2,499 employees
Year Founded2000
Websitehttp://www.lancesoft.com/

About Company

We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc). 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.

Skills

  • Amazon Web Services (AWS)unmatched
  • Analysis Skillsunmatched
  • Atlassian JIRAunmatched
  • Black Box Testingunmatched
  • Bug Tracking/Defect Managementunmatched
  • CSS (Cascading Style Sheet)unmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Data Description Language (DDL)unmatched
  • Data Mappingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Debugging Skillsunmatched
  • Electronic Data Interchange (EDI)unmatched
  • Financial Controlunmatched
  • Financial Reportingunmatched
  • Functional Testingunmatched
  • Gitunmatched
  • Governmentunmatched
  • HIPAA (Health Insurance Portability and Accountability Act)unmatched
  • Health Insuranceunmatched
  • Healthcareunmatched
  • IBM Cognosunmatched
  • Identify Issuesunmatched
  • Integration Testingunmatched
  • Internet Applicationunmatched
  • JUnitunmatched
  • Javaunmatched
  • Jenkinsunmatched
  • Knowledge Baseunmatched
  • LoadRunnerunmatched
  • Management of Information Systems/Technology (MIS)unmatched
  • Mavenunmatched
  • Medicaidunmatched
  • Microsoft Access Databaseunmatched
  • Microsoft Excelunmatched
  • Microsoft Officeunmatched
  • Microsoft PowerPointunmatched
  • Microsoft Visiounmatched
  • Microsoft Wordunmatched
  • Multiplatform/Cross-Platformunmatched
  • Object Oriented Design (OOD)unmatched
  • Object Oriented Programming Methodologiesunmatched
  • Oracle Databaseunmatched
  • Oracle PL-SQLunmatched
  • Presentation/Verbal Skillsunmatched
  • Problem Solving Skillsunmatched
  • Process Improvementunmatched
  • Programming Languagesunmatched
  • Python Programming/Scripting Languageunmatched
  • Quality Assuranceunmatched
  • Quality Assurance Methodologyunmatched
  • Quality Managementunmatched
  • Quality Metricsunmatched
  • Quest Software TOADunmatched
  • REST (Representational State Transfer)unmatched
  • Regression Testingunmatched
  • Regulatory Complianceunmatched
  • SQL (Structured Query Language)unmatched
  • Scalable System Developmentunmatched
  • Scripting (Scripting Languages)unmatched
  • Scrum Project Management and Software Developmentunmatched
  • Seleniumunmatched
  • Smoke Testingunmatched
  • Software Development Lifecycle (SDLC)unmatched
  • Software Engineeringunmatched
  • Software Testingunmatched
  • Sprint Planningunmatched
  • Status Reportsunmatched
  • Subversionunmatched
  • System Testunmatched
  • Team Playerunmatched
  • Test Automationunmatched
  • Test Caseunmatched
  • Test Dataunmatched
  • Test Designunmatched
  • Test Harnessunmatched
  • Test Plan/Scheduleunmatched
  • Test Scenariounmatched
  • Test Scriptsunmatched
  • Test Strategyunmatched
  • Test Suiteunmatched
  • Testingunmatched
  • Time Managementunmatched
  • Unix Operating Systemsunmatched
  • Web Designunmatched
  • Web Servicesunmatched
  • White Box Testingunmatched
  • Writing Skillsunmatched
  • XPathunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder