When your phone is set to show all contacts in the contacts management app and to sync contacts across accounts, this is what generally happens. You will not see duplicate contacts if you set the contact app to only show contacts from one source, such as Google, your phone, or your SIM card.