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.
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.
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
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.
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