Job Details

Job Title: Quality Analyst (Backend / Database / EDW / ETL Testing)

Location: Primarily Remote

Duration: 12 Months

Functional Description:

We are seeking a skilled and experienced Quality Analyst (QA) supporting a large-scale data warehouse project. The QA role ensures software quality and reliability through active participation in quality assurance activities, including walk-throughs, inspections, and reviews. Responsibilities include developing and prioritizing test cases, executing them, and reporting defects. The QA professional performs regression testing, develops system knowledge, and implements automated tests using Behavior-Driven Development (BDD) and TestNG approaches. They execute automated tests with tools like Selenium, Cucumber, and Java, and implement quality engineering practices within a Continuous Integration/Continuous Delivery (CI/CD) pipeline.

The role involves end-to-end testing, collaborating with the scrum team, and documenting test results. The QA professional ensures compatibility with existing product features and interfaces, understands data architecture in modern platforms, and utilizes AI-based tools for testing. They employ generative AI for efficient testing, including generating test case requirements and user stories.

Key Responsibilities:

• Actively participate in quality assurance activities such as walk-throughs, inspections, reviews, and user group meetings.
• Develop, prioritize, and execute test cases, reporting defects with defined severity and priority.
• Perform regression testing whenever code changes are made to fix defects.
• Acquire in-depth system and application knowledge to enhance test quality and coverage.
• Develop and implement automated tests using a Behavior-Driven Development (BDD) and TestNG approach, and execute these tests using Selenium, Cucumber, and Java.
• Implement quality engineering practices within a Continuous Integration/Continuous Delivery (CI/CD) pipeline, including version control, test management, and automation framework integration.
• Conduct end-to-end testing of the application, including functional, integration, and regression testing.
• Collaborate with the scrum team to groom user stories and develop acceptance criteria.
• Take ownership of tasks and communicate ideas clearly to staff, business sponsors, managers, and technical resources.
• Document and review test results with the project team to ensure all business and technical requirements are met.
• Ensure compatibility with existing product features and interfaces with other product lines.
• Possess a strong understanding of Bronze/Silver/Gold data architecture in modern data platforms such as Databricks, Snowflake, and Azure Synapse.
• Utilize AI-based tools to create test data, auto-generate test cases from requirements or user stories, and conduct API testing with AI-enhanced tools like Postman.
• Employ generative artificial intelligence (GenAI) for efficient testing, including generating test case requirements and user stories.

• 5+ years of accomplished experience in software testing,
• 5+ years of prior experience working as Backend / Database / EDW / ETL tester
• 4+ years of excellent SQL skills and experience working with any one RDBMS (Teradata, SQL, etc.)
• 4+ years of experience in user-interface, smoke, end-to-end (E2E) and integration testing
• 4+ years of strong troubleshooting and reasoning skills; the ability to debug and resolve difficult technical problems
• 4+ years of excellent test design skills and experience working with any one Test Management tool

• Healthcare domain experience (commercial, Medicaid and Medicare claims data, EDI X12 transactions in the healthcare industry (999, 837, 834, 277) or HL7)
• Experience with DevOps, Informatica PowerCenter
• Tools Knowledge: Selenium with java, Cucumber (BDD), SOAP UI, Postman, RestAssured, HP ALM, Jira, GitHub
• Experience working in a CI/CD environment like Jenkins for executing automated tests, application deployment
• Experience working with complex XML/JSON, EDI X12, SQL transactions
• Good knowledge on Automation framework preparation / usage