- Lead ETL/Data Warehouse testing activities for large-scale data transformation and migration projects.
- Design, develop, and execute comprehensive test strategies, test plans, and test cases.
- Validate source-to-target data mappings, transformation rules, and business logic.
- Perform end-to-end testing of data pipelines in Databricks and Data Warehouse environments.
- Conduct data reconciliation, data integrity, and data quality testing.
- Develop and execute complex SQL queries for data validation and analysis.
- Validate fact and dimension tables, star and snowflake schemas.
- Collaborate with Data Engineers, Architects, Business Analysts, and Product Owners to ensure data accuracy.
- Identify, track, and manage defects through to resolution.
- Participate in Agile ceremonies and contribute to continuous improvement initiatives.
- Mentor junior testers and provide technical guidance on ETL testing best practices.