ETL Tester

Mandatory Skills & Experience

• Lead and manage teams in an Onsite-Offshore model.
• Ensure adherence to QA processes and best practices.
• Leverage AI for automation in testing workflows is Must
• Perform database testing with strong expertise in ETL concepts and ETL testing.
• Work extensively on end-to-end flows within retail domain marketing systems
• Strong QA process knowledge.
• Hands-on experience with database testing and ETL testing.
• Recent project experience with retail clients (back-end systems).
• Deep understanding of retail domain marketing systems and end-to-end flows.
  Review requirements and prepare the Test Plan

Develop and execute ETL test plans, test cases, and test scripts to validate the
accuracy and integrity of data throughout the ETL process
Verify data mappings, transformations, and data loading processes to ensure they
meet business requirements
Should have various types of ETL testing experiences include Metadata Testing, Data
Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data
Quality Testing, Initial/Incremental load testing
Validates data by running queries in the database and verifying that the results match
the expectations
Perform data reconciliations between source and target systems
Demonstrate strong knowledge of dimensional modelling and data warehouse
concepts, including star schemas, snowflakes, dimensions, and facts
Collaborate with data architects and development team / engineers to design and
implement efficient data structures to ensure the quality of testing by providing data
validation expertise