Microsoft SQL Customer Data Entry

I need a detail-oriented specialist to take charge of a large batch of customer information currently sitting in Microsoft SQL Server database files. The work is twofold: first, bring new test records into the existing schema without breaking referential integrity; second, audit what is already there, flag inconsistencies, and correct them so the dataset is ready for stress-testing upcoming features.

You will be working directly inside SQL Server, so fluency with T-SQL, bulk insert methods, and data validation queries is essential. Accuracy matters more than speed; I want every imported row, every updated field, and every deleted duplicate backed by a quick note or script so I can trace changes later.

Deliverables (all discrete and specific):
• Clean, de-duplicated customer tables reflecting the latest test data
• The T-SQL scripts or SSIS packages you used for import, update, and validation
• A brief validation report summarising row counts, fixes applied, and any anomalies I should review

I am ready to provide the current .bak files and the schema documentation as soon as we start.