ETL Tester

We are looking for an experienced and detail-oriented ETL Tester to join our team. The ideal candidate will be responsible for testing data integration processes and ensuring the accuracy, completeness, and quality of data across various systems. You will work closely with the ETL development team to verify that the ETL processes are functioning as expected and that the data is accurately extracted, transformed, and loaded into the target systems.
Key Responsibilities:
Collaborate with the ETL development team and business stakeholders to understand the ETL workflows and data requirements.
Create and execute test plans, test cases, and test scripts for ETL processes and data pipelines.
Perform data validation and verification to ensure that the data extracted, transformed, and loaded by the ETL process is accurate, complete, and consistent with business rules.
Verify the correct transformation logic of data based on requirements, ensuring that the data is properly mapped between source and target systems.
Perform functional, regression, integration, and performance testing for ETL jobs and data integration solutions.
Identify and document defects, track them through resolution, and ensure that they are resolved promptly.
Conduct data quality checks to ensure that data meets the required standards before it is loaded into the target systems.
Test data for correctness, completeness, consistency, and reliability across different environments.
Monitor and evaluate ETL processes, identifying potential performance issues and recommending improvements.
Review and validate the performance and scalability of ETL jobs, particularly with large datasets.
Work with automation tools to automate repetitive ETL testing tasks, improving efficiency and coverage.
Provide detailed reports on test results, issues, and progress to stakeholders.
Ensure that testing is conducted in accordance with the project's defined timelines and quality standards.
Assist in creating and maintaining documentation related to ETL testing processes, test cases, and best practices.
Required Skills and Qualifications:
Proven experience as an ETL Tester or in a similar role focusing on testing data integration processes.
Strong knowledge of ETL tools (e.g., Informatica, Talend, Microsoft SSIS, etc.) and testing techniques for data pipelines.
Proficiency in SQL for validating and querying large datasets, writing complex queries to verify data integrity.
Experience with data validation, data mapping, and data transformation testing.
Understanding of database technologies (e.g., Oracle, SQL Server, MySQL, or similar databases).
Familiarity with different testing methodologies such as functional, regression, integration, and performance testing.
Experience in writing detailed test plans, test cases, and defect reports.
Knowledge of data warehousing concepts, ETL processes, and data modeling.
Familiarity with test automation tools and scripts for ETL testing is a plus.
Strong attention to detail, analytical thinking, and problem-solving skills.