Saanvi Technologies

Compensation

Full Description

Job Title: Test Lead Data & AI QA Location: Dearborn, MI Job Summary Seeking a highly technical Test Lead to drive end-to-end testing of data-centric and AI-driven products. The role focuses on validating ETL pipelines, dashboard metrics, and AI prompt outputs while building automated data validation frameworks. The ideal candidate is strong in SQL, Python/PySpark, and Databricks with hands-on QA automation experience. Key Responsibilities • Validate dashboards by reconciling UI metrics with backend data • Test AI/chat prompt outputs for accuracy and consistency • Perform ETL and data pipeline testing in Azure Databricks and Azure Data Factory • Write complex SQL queries to verify data transformations and aggregations • Execute API testing and validate JSON/XML responses • Build and maintain automation frameworks using PyTest, Python, or PySpark • Validate source-to-target data across multiple databases • Create manual test cases, log defects in Jira, and manage TestRail artifacts • Lead testing efforts and coordinate with developers, product owners, and offshore teams • Ensure code quality using Git workflows and SonarQube • Participate in Agile ceremonies and drive defect triage Required Skills • Strong SQL (3+ years, complex queries) • Python or PySpark automation (3+ years) • Databricks/Delta Lake experience (2+ years) • AI prompt/chat testing exposure (1+ year) • ETL/data validation testing experience • API testing (JSON/XML) • PyTest automation framework • Jira, TestRail, Git, SonarQube • Strong analytical and problem-solving skills Nice To Have • Azure ecosystem experience • Java for automation • Experience leading onshore/offshore QA teams