I am currently working in the SAP BODS ETL tool and thought of switching to some other tool. What is the best ETL tool which would fetch me a job with a good salary quickly in the US?
Frankly, if you want to guarantee yourself work, you likely want to learn one of the leading tools, since they have the widest set of customers using it who are looking for developers capabile in them. I don't see anything wrong with knowing BODS;
The leading ETL tools (or "Data Integration" tools in the parlance of the industry) are Informatica, Business Objects' Data Services, IBM's Data Stage, Oracle's OWB, and Microsoft's SSIS. There are a number of lesser players by marketshare who have great technology (SAS, Ab Initio, etc) and there are some shareware tools in the space (Pentaho, Talend, Clover, etc). Here's a quick look at the July 2015 Gartner group Magic Quadrant showing the landscape of the DI market: https://www.informatica.com/data-integration-magic-quadrant.html#fbid=-56UproDYw8
Frankly, if you want to guarantee yourself work, you likely want to learn one of the leading tools, since they have the widest set of customers using it who are looking for developers capabile in them. I don't see anything wrong with knowing BODS; its one of the leading tools. By virtue of the fact that you know the Business Objects product, you likely could learn how to do universe design and report development and become a broader BO professional. If you wanted to make a change, i'd probably suggest Informatica; it seems to be the market leader and is database-vendor independent, unlike IBM, Oracle and Microsoft's ETL offerings. If you choose to (say) learn SSIS, it only works on MS platforms and then you'll be limited in your job selections.
This is not to say that the "other" technologies aren't good; most people who have worked with Ab Initio for example rave about it, but they refuse to participate with industry analysts like Gartner so nobody really knows the product. And I think this keeps the demand down for it. Likewise with shareware; its great to know Pentaho and be able to work with organizations that are doing ETL on the cheap ... but if they're not paying for an industry-standard tool, are they going to pay competitive salaries?