What will America pay to H1b job candidates?

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

United States Department of Labor publishes quarterly data of H1-B and other visa applications. Below is an analysis and visualization of the same data.

What is in the Data files?

The data is available as CSV files. Each file contains around 500k records. It contains details of each application whether it is approved, rejected or withdrawn. It has the name of the employer who is sponsoring the H1-B visa, salary range and location of the employer. It also contains the duration for which the employer intends to keep the h1-b visa candidate.

Image

Tricky Part:

The salary/wage is not uniform. For most of the rows, the salary is listed as annual/yearly wage. But then there are applications where the wage is listed weekly, bi-weekly, monthly. So to analyze the data, we first need to normalize the salary. Another interesting information they have is the duration of each h1b visa application. So this becomes easy to normalize the salary by “Daily” and then if we multiply by number of valid days we get what the company will be spending on each candidate for the entire valid stay of the visa.

The daily wage is calculated in the excel/csv file and then the whole csv file is uploaded to the infocaptor-warehouse/personal cloud

(NOTE: The raw files needs some clean up to remove the backslashes and double quotes that may fail during upload process. To clean this we use Excel Find and Replace function to remove \ and ” )

County Level Metrics

Once the data is available in SQL tables, it is now easy to generate city level aggregation. This data is then matched with zip codes to generate a county level aggregation. We then use USA County Vector Map to generate the below visualization.

Image

Here is the link to the County Metrics

 

Higher the count of the h1b approved applications darker is the region mapped.

Next, State level metrics

We can now aggregate the metrics by state and generate the below visuals

Image

Image

Here is the State Map for H1b metrics

Finally, the below visuals helps us understand the top 100 employers and job titles. It is interactive where you can switch between job titles and employer names.

Image

Image

Click here to see the interactive dashboard

Here is the list of top 100 companies that is hiring h1b candidates

– Infosys Limited [ Jobs=7766 , Pay = 1983.8 million]
– Wipro Limited [ Jobs=2401 , Pay = 485.7 million]
– Tata Consultancy Services Limited [ Jobs=1641 , Pay = 282.1 million]
– Accenture Llp [ Jobs=1227 , Pay = 1305.6 million]
– Intel Corporation [ Jobs=911 , Pay = 1358.2 million]
– Cognizant Technology Solutions U.S. Corporation [ Jobs=698 , Pay = 124.4 million]
– Hcl America, Inc. [ Jobs=694 , Pay = 150.1 million]
– Igate Technologies Inc. [ Jobs=578 , Pay = 702.2 million]
– Larsen & Toubro Limited [ Jobs=570 , Pay = 74.1 million]
– Larsen & Toubro Infotech Limited [ Jobs=551 , Pay = 94.4 million]
– Oracle America, Inc. [ Jobs=497 , Pay = 147.8 million]
– Ibm India Private Limited [ Jobs=492 , Pay = 77.4 million]
– Qualcomm Technologies, Inc. [ Jobs=407 , Pay = 112.8 million]
– Hexaware Technologies, Inc. [ Jobs=385 , Pay = 68.5 million]
– Satyam Computer Services Ltd [ Jobs=359 , Pay = 76.2 million]
– Ust Global Inc. [ Jobs=308 , Pay = 647.9 million]
– Apple Inc. [ Jobs=293 , Pay = 101.6 million]
– Ust Global Inc [ Jobs=291 , Pay = 53.1 million]
– Ibm Corporation [ Jobs=267 , Pay = 73.9 million]
– Deloitte & Touche Llp [ Jobs=264 , Pay = 51.4 million]
– Deloitte Consulting Llp [ Jobs=255 , Pay = 929.3 million]
– Jpmorgan Chase & Co. [ Jobs=250 , Pay = 70.4 million]
– Microsoft Corporation [ Jobs=224 , Pay = 77.7 million]
– Broadcom Corporation [ Jobs=222 , Pay = 73.2 million]
– Ntt Data, Inc. [ Jobs=219 , Pay = 49.4 million]
– Persistent Systems, Inc. [ Jobs=209 , Pay = 42.8 million]
– Compunnel Software Group, Inc. [ Jobs=205 , Pay = 38 million]
– Mayo Clinic [ Jobs=201 , Pay = 55.7 million]
– Ericsson Inc. [ Jobs=200 , Pay = 42.8 million]
– Johns Hopkins University [ Jobs=199 , Pay = 23.4 million]
– Avant Healthcare Professionals [ Jobs=189 , Pay = 48 million]
– National Institutes Of Health, Hhs [ Jobs=177 , Pay = 20.6 million]
– Yash Technologies, Inc. [ Jobs=176 , Pay = 24.4 million]
– Hewlett-Packard Company [ Jobs=175 , Pay = 890.2 million]
– Cummins Inc. [ Jobs=171 , Pay = 34.6 million]
– Mphasis Corporation [ Jobs=170 , Pay = 32.1 million]
– Satyam Computer Services Ltd. [ Jobs=169 , Pay = 38.3 million]
– Amirit Technologies, Inc. [ Jobs=169 , Pay = 24.9 million]
– Schlumberger Technology Corporation [ Jobs=165 , Pay = 36.6 million]
– Marvell Semiconductor, Inc. [ Jobs=154 , Pay = 40.6 million]
– Capgemini Financial Services Usa Inc [ Jobs=151 , Pay = 29.7 million]
– Amazon Corporate Llc [ Jobs=149 , Pay = 41.3 million]
– Satyam Computer Services Limited [ Jobs=147 , Pay = 30.3 million]
– Bank Of America N.A. [ Jobs=146 , Pay = 41 million]
– Sapient Corporation [ Jobs=145 , Pay = 39.7 million]
– Csc Covansys Corporation [ Jobs=140 , Pay = 26.9 million]
– University Of Michigan [ Jobs=139 , Pay = 25.9 million]
– Cvs Rx Services, Inc. [ Jobs=138 , Pay = 66.8 million]
– New York University Hospitals Center [ Jobs=137 , Pay = 18.1 million]
– University Of Washington [ Jobs=136 , Pay = 16.1 million]
– Ebay Inc. [ Jobs=135 , Pay = 47 million]
– Populus Group [ Jobs=133 , Pay = 55.4 million]
– Infotech Enterprises America, Inc. [ Jobs=132 , Pay = 26.2 million]
– Natsoft Corporation [ Jobs=131 , Pay = 640.2 million]
– Texas Instruments Incorporated [ Jobs=130 , Pay = 38.1 million]
– Cloudeeva, Inc [ Jobs=126 , Pay = 369.3 million]
– Orian Engineers Incorporated [ Jobs=126 , Pay = 24.9 million]
– Globalfoundries U.S. Inc. [ Jobs=124 , Pay = 29.5 million]
– Smartplay, Inc. [ Jobs=124 , Pay = 35 million]
– Trustees Of The University Of Pennsylvania [ Jobs=123 , Pay = 20.8 million]
– Wal-Mart Associates, Inc. [ Jobs=122 , Pay = 43.9 million]
– Washington University In St. Louis [ Jobs=120 , Pay = 18.3 million]
– Northstar Group Inc [ Jobs=119 , Pay = 22 million]
– Baylor College Of Medicine [ Jobs=119 , Pay = 23.3 million]
– Netapp, Inc. [ Jobs=119 , Pay = 38.4 million]
– The Ohio State University [ Jobs=118 , Pay = 21.2 million]
– Mindtree Limited [ Jobs=117 , Pay = 550.2 million]
– Erp And Erp Corp [ Jobs=116 , Pay = 22.3 million]
– Ntt Data, Inc. (Formerly Keane Inc.) [ Jobs=114 , Pay = 26.3 million]
– Baltimore City Public Schools [ Jobs=114 , Pay = 13.8 million]
– Yale University [ Jobs=113 , Pay = 15.7 million]
– Google Inc. [ Jobs=113 , Pay = 40.3 million]
– Emc Corporation [ Jobs=113 , Pay = 28.9 million]
– Dotcom Team, Llc [ Jobs=113 , Pay = 19.5 million]
– Cisco Systems, Inc. [ Jobs=112 , Pay = 31.4 million]
– Duke University And Medical Center [ Jobs=111 , Pay = 10.4 million]
– Emory University [ Jobs=111 , Pay = 16.6 million]
– State University Of New York At Buffalo [ Jobs=111 , Pay = 10.3 million]
– University Of Minnesota [ Jobs=111 , Pay = 23.7 million]
– Kpit Infosystems, Inc. [ Jobs=110 , Pay = 19.6 million]
– Perficient, Inc. [ Jobs=109 , Pay = 25.3 million]
– The Board Of Trustees Of The Leland Stanford, Jr. [ Jobs=109 , Pay = 24 million]
– Astir It Solutions Inc. [ Jobs=109 , Pay = 19.5 million]
– Verinon Technology Solutions Ltd. [ Jobs=108 , Pay = 21 million]
– Rite Aid Corp. [ Jobs=108 , Pay = 58.4 million]
– Indus Valley Consultants, Inc. [ Jobs=107 , Pay = 19.7 million]
– 3I Infotech, Inc [ Jobs=106 , Pay = 19 million]
– Dgn Technologies Inc [ Jobs=106 , Pay = 24.8 million]
– University Of Maryland College Park [ Jobs=105 , Pay = 14.5 million]
– Ciber, Inc. [ Jobs=104 , Pay = 25.4 million]
– University Of California, Davis [ Jobs=104 , Pay = 13.8 million]
– Syntel Inc [ Jobs=103 , Pay = 17.2 million]
– University Of California, Los Angeles [ Jobs=103 , Pay = 17.3 million]
– Onward Technologies, Inc [ Jobs=103 , Pay = 19.3 million]
– Delasoft, Inc. [ Jobs=102 , Pay = 17.4 million]
– Nvidia Corporation [ Jobs=102 , Pay = 32 million]
– Childrens Hospital Corporation [ Jobs=102 , Pay = 13.2 million]
– Merrill Lynch [ Jobs=102 , Pay = 28.9 million]
– Infoysys Limited [ Jobs=100 , Pay = 24 million]
– Zensar Technologies Inc. [ Jobs=100 , Pay = 22.5 million]

Summary: The H1b program will pay a sum of $60,374,682,695 that is roughly $60 Billion US dollars over a period of next three years. A total of 300,000 candidates were approved for h1-b visa. Around 8000 applications were rejected, around 9000 applications were withdrawn and around 26000 applications were approved but later withdrawn.

Links to all three dashboard visualizations

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH