Merging customer data from disparate sources to create a master customer dimension

Looking for guidance in regards to merging disparate sources of customer data into one master customer table - which will be modeled into a conformed customer dimension down the road.

Problem is the data sources have the typical issues - SSN exists in some sources, not in others. Names and addresses are not consistent, DOBs are available in some, but not others - etc.

Any ideas on what is typically done in this scenario? My initial thought is to use some combination of SSN, Name, and DOB to create a user facing unique ID via a hash function in SQL Server (do not want to show users the actual SSN, obviously) and leverage the fuzzy lookup tasks in my ETL tool to ID merge customers that exist in multiple source systems.

Anyone done anything like this before? Thanks in advance!!!

Great forum, BTW!
Matt

Purchase data quality software. Profile the data, identify merge attributes, develop data quality plans. Strive for 97-98% match rate. Hand coding will reduce match rates significantly.