There is an immense requirement for good data scientists. It's not concerning whether you know R and Hadoop. It's about obtaining knowledge and classifying important things from non-important. Data science is a union of applied statistics, software engineering and, often, domain knowledge whatever that domain may be. It's not easy and it's not going to be simple in the future. Coding in SQL, R, Hadoop, Python, etc are all main skillsets that a data scientist needs to have, but they aren’t the entire job. They’re just a segment, not the whole. It's always easy to learn a few basics about the field quickly due to plenty of tutorials and youtube videos online. But, it's the master talent that is rare to find and usually requires huge efforts to get there.
As data science is a comparatively new and hot field, a lot of people are hopping into it. There is and will always be a huge demand for talented data scientists. If you want a detailed explanation of Data Science then do check out Intellipaat’s blog which will help you in understanding DS.
You can get a hands-on project by referring to the following course by Intellipaat which will teach you Data Science from scratch to advance: https://intellipaat.com/data-scientist-course-training/
And if you are more into videos then do check out the following video tutorial which will help you in mastering in the field of Data Science: