ETL/SQL QA Test Analyst

Job Description:

• Extensive hands-on experience with Snowflake, including data modeling, source-to-target mapping, and testing of ETL pipelines.
• Strong ETL testing capabilities, particularly using data validation and comparison tools to ensure data integrity across systems.
• Familiarity with BI and analytics platforms such as Power BI or Tableau, with the ability to validate dashboards against business rules and logic to ensure accurate, actionable insights.
• Domain expertise in healthcare, especially with clinical, claims, member, and provider data, is highly preferred.
• Currently, they have many vendors providing data feeds into them on prem SQL Server data warehouse. These data transfers are usually in either emails or simple file formats. This is how the current on prem data warehouse is populated. These are called "data extracts”.
  This work will roll up under Steven Wiley, the Data Engineering Manager. He said there are 200 data extracts they are evaluating now (reviewing all the business requirements) and expect probably half of those to go away or be repurposed, with an eventual goal of moving approx. 100 data extracts from the on prem system to the Snowflake data warehouse. This is a bit of a manual process and will require very strong SQL skills, along with ETL and data warehouse concepts and/or migration experience/knowledge.
  They have BRD (business requirement documents) for these extracts, but it's in old in Excel and needs to be migrated into Confluence, which will be part of what is expected from this consultant.
• • Testing Activities: Design, develop, and execute manual and automated test cases for ETL processes, data extracts, dashboards, and File Ingestions
  • Test Planning: Create and maintain test plans, test cases, and defect tracking reports. Ensure compliance with deployment testing standards.
  • Collaboration: Work closely with QA Manager, developers, and business analysts to review requirements and estimate testing efforts.
  • Agile Participation: Actively engage in Agile/Lean SDLC processes, including sprint planning and retrospectives.
  Technical Skills & Tools
  • ETL & Data Testing: Strong experience with SQL Server, Snowflake, SSIS, and SSRS
  • Data Integration tools like ETL Works
  • Automation & Scripting: Familiarity with Python, C#, .NET, and cloud-based testing frameworks.
  • Test Management: Proficiency in tools like Jira, Xray, DevOps, and ALM.
  • Data Analysis: Ability to write advanced SQL queries for validation and backend testing.
  Qualifications
  • Education: Bachelor's degree or equivalent experience in a related field.
  • Experience: 3–5 years in QA with a focus on ETL and data warehouse testing.
  • Healthcare domain experience is a plus.
  Soft Skills
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration abilities