is it correct to say " i have tendency to be a pilot in future ? "
Is it about what you like to be in the future? is it about your future career? Then I am afraid not. "I have a tendency to be..." is idiomic but what comes next is not your future career, it is an adjective or a phrase which shows a characteristic of you. Even when what comes next is a career it comes with some adjective which shows the way you act in that career.