Position Overview: QA Engineer - The Standardized Encounter Data Project (SENDPRO is the State's Medicaid IT initiative to transition encounter data submissions from a MassHealth-specific(custom) format to 837 EDI standard (Industry Standard).
- QA Engineer will be responsible for designing, implementing and executing testcases to validate the functionality, performance, and data integrity of the SENDPRO project. You will collaborate with cross-functional teams, including data engineers, developers, and project managers, to ensure Successful implementation. The ideal candidate should possess a strong understanding of EDI concepts, Datawarehouse concepts, testing methodologies, and expertise in Snowflake. The individual should work in compliance with HIPAA requirements.
Detailed List of Duties and Responsibilities: - Collaborate with stakeholders to gather and understand SendPro project requirements, shaping comprehensive and tailored test plans.
- Design detailed test strategies, scenarios, and test cases to validate data warehouse and reporting processes within the SendPro environment.
- Execute manual and, where applicable, automated test cases to ensure data integrity, accuracy, and consistency across development, staging, and production environments.
- Identified, documented, and tracked defects using standardized tools, working closely with the development team to ensure timely resolution and verification.
- Perform end-to-end testing of ETL pipelines and data workflows to validate the correct movement and transformation of data within the SendPro ecosystem.
- Ensure consistency and integrity of data between source systems and target destinations, maintaining adherence to SendPro's business logic and transformation rules.
- Collaborate with data engineers, developers, and cross-functional teams to understand complex technical components and ensure robust test coverage.
- Regularly communicate testing status, identified risks, and flagged issues to project managers and team leads for informed decision-making.
- Maintain detailed documentation of all test artifacts including test plans, test cases, execution results, and defect logs specific to SendPro.
- Produce comprehensive testing reports summarizing key findings, defect trends, and recommendations for quality improvements.
- Actively contributed to process improvements by recommending best practices and enhancements to testing workflows in the context of the SendPro project.
Required Skills and Abilities: - Demonstrated expertise in testing Snowflake data warehouses and ETL processes.
- Proficient in SQL for data validation and querying, with experience in both Oracle SQL and Snow SQL scripts.
- Familiarity with scripting languages for test automation, such as Python or Java.
- Understanding data modeling concepts and principles.
- Experience with testing tools and frameworks related to Snowflake, including Snowflake Data Cloud, is advantageous.
- Hands-on experience working with Cloud Platforms such as AWS.
- Proficiency in Informatica Intelligent Cloud Services (IICS) and relevant tools.
- Competence in Automation Tools such as Selenium and Apache AirFlow.
- Familiarity with GIT Version Control.
- Experience with Jira for tracking and managing testing tasks, as well as collaborating with development and other testing teams.
- Familiarity with Agile and DevOps methodologies.
- Strong analytical and problem-solving skills with meticulous attention to detail.
- Effective communication and collaboration skills, demonstrating the ability to work in a team-oriented environment.
Education and Experience: - Bachelor's degree in computer science, Information Technology, or a related field.
- 5 years of experience in ETL processes and testing tools.
- 3 years of experience in designing and maintaining testing frameworks for Snowflake.
- Ability to take high-level requirements and/or scope and drive to successful execution.
- Proficiency in MS Office, i.e., Word, Excel, PowerPoint, Access, and Visio.
- Government and/or Healthcare prior experience desired.
Employee Benefits: At LanceSoft, full-time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits. (To be bought)
- Four options of Medical Insurance
- Dental and Vision Insurance
- 401k Contributions
- Critical Illness Insurance
- Voluntary Permanent Life Insurance
- Accident Insurance
- Other Employee Perks
About LanceSoft LanceSoft is rated as one of the largest staffing firms in the US by SIA. Our mission is to establish global cross-culture human connections that further the careers of our employees and strengthen the businesses of our clients. We are driven to use the power of our global network to connect businesses with the right people, and people with the right businesses without bias. We provide Global Workforce Solutions with a human touch.
EEO Employer LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.