SQL Data Cleaning Assistance Required

I'm seeking an expert in SQL, specifically with Microsoft SQL Server, to assist with cleaning test data. The data has a couple of significant issues, including missing values and duplicate records. Ideal candidates should have substantial experience with data cleansing and be able to identify and rectify these issues efficiently.