This dynamic role involves working on multiple projects, focusing on ETL testing and thorough validation between source and target systems. The responsibilities include developing and executing test plans, cases, and scripts to ensure data accuracy, completeness, and integrity. The role requires performing functional, integration, regression, and performance testing of data pipelines, ETL processes, and databases. Additionally, you will identify and resolve data anomalies, conduct data profiling, and collaborate with stakeholders to ensure data quality standards are met. Documenting test plans, results, and issues, while recommending and implementing improvements, is essential. Automation of data validation processes is encouraged to enhance efficiency and accuracy.
Job Description
Job Responsibilities
Multi-Project Involvement: Engage in multiple projects, focusing on ETL testing and ensuring thorough validation between source and target systems.
Test Plan Development: Develop and execute comprehensive test plans, test cases, and scripts to validate data accuracy, completeness, and integrity.
Testing Execution: Perform functional, integration, regression, and performance testing of data pipelines, ETL processes, and databases.
Data Quality Assurance: Identify, investigate, and troubleshoot data anomalies, inconsistencies, and discrepancies; resolve data quality issues promptly.
Data Profiling & Analysis: Conduct data profiling and analysis to uncover data quality issues, patterns, and trends.
Stakeholder Collaboration: Work closely with data engineers, data scientists, business analysts, and other stakeholders to understand data requirements and ensure adherence to data quality standards.
Documentation & Communication: Document test plans, results, and data quality issues; effectively communicate findings and recommendations to both technical and non-technical stakeholders.
Process Improvement: Recommend and implement improvements to data quality processes, tools, and methodologies.
Automation: Automate data validation and testing processes where possible to enhance efficiency and accuracy.