Senior ETL Tester (5-7 yrs)

Job Description :

- Responsible for testing and validating the accuracy and completeness of data being extracted, transformed, and loaded (ETL) from various sources into the target systems. These target systems can be On Cloud or on Premise.

- Work closely with ETL developers, Data engineers, data analysts, and other stakeholders to ensure the quality of data and the reliability of the ETL processes.

- Understand Cloud architecture and design test strategies for data moving in and out of Cloud systems.

- Strong in Data warehouse testing ETL and BI.

- Strong Database Knowledge - Oracle/ SQL Server/ Teradata / Snowflake.

- Strong SQL skills with experience in writing complex data validation SQL's.

- Experience working in Agile environment Experience creating test strategy, release level test plan and test cases.

- Develop and Maintain test data for ETL testing.

- Design and Execute test cases for ETL processes and data integration.

- Good Knowledge of Rally, Jira and HP ALM.

- Experience in Automation testing and data validation using Python.

- Document test results and communicate with stakeholders on the status of ETL testing.

Requirements :

- Strong expertise in testing data warehouse ETL processes and Business Intelligence (BI) reporting.

- Validate data accuracy and consistency within the data warehouse.

- Ensure the integrity of data used for reporting and analysis.

- In-depth knowledge of relational databases (Oracle, SQL Server, Teradata, Snowflake).

- Strong SQL skills with the ability to write complex data validation queries.

- Experience with database administration tasks (if applicable).

- Experience working in Agile development environments (Scrum, Kanban).

- Participate in agile ceremonies (sprint planning, daily stand-ups, sprint reviews, retrospectives).

- Create and maintain comprehensive test plans, test cases, and test scripts.

- Document test results, defects, and resolutions. Communicate test progress and status to stakeholders effectively.

- Experience with automation testing tools and frameworks.

- Develop and maintain automated test scripts for data validation using Python or other scripting languages.