ETL Tester

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.

·       Excellent communication skills, both verbal and written, to collaborate with technical and business teams.

·       Ability to work in an Agile Scrum environment and meet tight deadlines.

Preferred Skills:

·       Experience with cloud based ETL tools and platforms (e.g., AWS Glue, Azure Data Factory, Google Cloud Dataflow).

·       Familiarity with data visualization and reporting tools like Power BI, Qliksense, etc.

·       Experience with version control systems such as Git or SVN.

·       Knowledge of performance testing and data load testing tools.

·       Knowledge snowflake added advantage.