ETL Tester

Data Warehouse QA Analyst/EngineerHybrid (50% onsite in Wilmington, MA)12+ monthsOverview :Skilled and experienced

Data Warehouse QA Analyst/Engineer

with a strong background in manual and automation testing, and a proven track record in leading QA initiatives. The ideal candidate will have in-depth experience with Microsoft technologies, ETL processes, and data warehouse testing.The ideal DW QA engineer

comes with relevant manufacturing, supply chain

(invoice, billing, revenue, product, customer, route) data set QA experience.Key Responsibilities:Data & ETL Testing :Conduct extensive data testing, validating ETL processes, and ensuring data accuracy/reconciliation, integrity, and consistency across data warehouses and server upgrade project.Write and execute complex SQL queries to validate data across databases, ensuring correct data extraction, transformation, and loading (ETL) operations.Design, develop, and implement comprehensive test plans, test strategies, test scenarios, and test cases.Experience:7-10 years

of experience in software testing, including both manual and automation testing.Experience working on SQL server versions 2017,2019, 2022Proven experience with

Microsoft technologies

(SSMS) or Toad IDE

and testing of ETL processes and data warehouses.Extensive experience with

T-SQL

for database testing and data validation.Strong SQL skills for data validation, especially with

supply chain datasets (invoice, billing, revenue, product, customer, route, contracts, inventory, logistics, procurement).