Yes, All the Indian nationals require German national visa for work long term in Germany. Visa is mandatory doesn't matter you are residing in India or NRI.
Read this post on cookievagabond.com