Area(s) of responsibility
- Test strategy and planning: Design and develop comprehensive test strategies, test plans, and test cases for ETL workflows and data pipelines.
- Team leadership: Lead and mentor the ETL testing team, allocating tasks, and providing technical guidance.
- Collaboration: Work closely with business analysts, data engineers, and developers to understand requirements and resolve issues.
- Quality Metrices: Monitor and analyse data quality metrics, identifying and resolving data issues.
- Data validation: Perform data validation, reconciliation, and verification between source and target systems using SQL and other tools to ensure data accuracy and completeness.
- Test execution: Oversee the execution of test cases and automation scripts.
- Defect management: Identify, document, and track defects, working with developers to ensure timely resolution.
- Reporting: Monitor and report on testing progress, quality metrics, and defect summaries to stakeholders.
- Documentation: Create and maintain documentation for test plans, results, and process maps.