The Reform movement, to which most American Jews belong, does not have an official stance on tattoos and is to the left of the American mainstream on social and religious issues.
.
You do realize that the vast majority of Jews in the United States, for example, belong to two movements who have very different views of modernity than the ultra-Orthodox, right? However, those who violate this prohibition may be buried in a Jewish cemetery and participate fully in all synagogue ritual.