Conduct end-to-end Testing of ETL processes to ensure Data accuracy and Integrity.
Develop and execute SQL queries to validate ETL transformations.
Utilize BI tools such as Pentaho or Power BI for Data visualization and Business needs.
Collaborate with cross-functional teams to understand data requirements and ensure ETL solutions meet business needs.
Conduct Performance testing of ETL processes to optimize ETL transformation steps, resource utilization.
Collaborate closely with Product owner, developers, and BA to understand project requirements and translate them into effective test scenarios.
Perform root cause analysis of data discrepancies and anomalies, working collaboratively with development teams to address and resolve issues promptly.
Execute regression testing to validate data transformations and ensure seamless integration with existing BI Tool.
Demonstrate leadership qualities by providing mentorship to junior team members, fostering a collaborative team environment.
Document test results, defects, and findings comprehensively, and communicate them effectively to stakeholders.