end to end test the sign up process

How do I do end to end testing with something like a sign up process. The user cannot use an existing username so therefore the test would need to use a unique username every time.

On top of that, should I remove the user from the database after the test runs? since every time the test is ran, a new user is created.