Strategy and Planning: Develop comprehensive test strategies, test plans, and test cases tailored for data warehousing, ETL processes, and analytics reporting.
Data Validation (ETL/BI): Verify data accuracy, completeness, and consistency across source systems, ETL layers, and target data warehouses.
Automation and Technical Leadership: Implement automation frameworks for testing ETL jobs and data validation, using SQL and scripting languages.
Team Leadership: Guide a team of analysts/testers, prioritize testing efforts, and ensure project milestones are met.
Defect Management: Identify, document, and track bugs to closure, conducting root cause analysis for data discrepancies.
Stakeholder Collaboration: Collaborate with developers and business analysts to define functional requirements and validate UAT (User Acceptance Testing).
Required Skills and Qualifications
Technical Expertise: Strong proficiency in SQL (queries, procedures, views), ETL tools (Informatica, Talend, etc.), and data warehouse concepts.
Test Methodologies: Proven experience in data integration testing, regression testing, and data quality testing.
Analytical Skills: Ability to analyze large datasets to identify patterns or inconsistencies.
Experience: Several years of experience in data testing or QA, with previous experience leading teams.
Qualifications
Bachelor’s degree in computer science, IT, or a related field.
Experience with cloud platforms (AWS, Azure, GCP) and BI tools (Tableau, Power BI) is highly valued