Perform QA of ETL/ELT patterns including incremental loads, CDC patterns, and partitioning strategies.
Validate SQL Server objects such as stored procedures, views, tables, indexing strategies, and job schedules where applicable.
Execute performance testing for Databricks jobs and SQL Server queries (query tuning, indexing suggestions, cluster sizing guidance).
Recommend strategies to improve platform performance, cost efficiency, and workload stability.
Provide support for production execution and delivery of BI/analytics solutions.
Support platform upgrades and migrations (Databricks runtime upgrades, cluster policies, SQL Server version changes) in dev/test, including QA sign off and documentation.
Maintain accurate and complete QA documentation: test plans, test evidence, defect logs, reconciliation results.
Ensure adherence to corporate policies, governance, and established practices.
Mentor team members on QA methods, automation, and data validation patterns.