bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / CAPGEMINI US LLC

CAPGEMINI US LLC H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
CAPGEMINI US LLC
CAPGEMINI US LLC
792713FY2016 to FY2016
Latest decision 2016-06-13
2,070DEVELOPER
26 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings79
Certified LCAs56
Denied LCAs0
Role titles27
Worksites13
Latest decision2016-06-13
USCIS approvals2,070
USCIS denials105

Aliases and source names

AliasesSource NamesSources
CAPGEMINI US LLCCAPGEMINI US LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DEVELOPER15-113326$79,400$0
SYSTEM ANALYST15-119910$74,200$0
PROJECT MANAGER15-11995$92,900$0
SENIOR MANAGER/PROJECT MANAGER11-30214$150,000$271,000
TESTER15-11994$74,200$0
APPLICATIONS CONSULTANT15-11322$91,600$0
FUNCTIONAL SYSTEMS ANALYST/MANAGER15-11212$100,000$121,000
MANAGER / PROJECT MANAGER15-11992$98,000$200,000
MANAGER/FUNCTIONAL SYSTEMS ANALYST15-11212$112,000$183,000
MANAGER/PROJECT MANAGER15-11992$112,000$183,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
AtlantaGA30305531074,200183,0002,0162,016
BurbankCA915059995,000271,0002,0162,016
IrvingTX750625583,000249,0002,0162,016
South San FranciscoCA940802290,355151,0002,0162,016
ChicagoIL6060622106,000200,0002,0162,016
AlpharettaGA300051190,100138,0002,0162,016
MalboroughMA0175211133,000249,0002,0162,016
MiddletonMA0194911112,000183,0002,0162,016
EaganMN5512111150,000200,0002,0162,016
BloomfieldNJ0700311112,000183,0002,0162,016

Full company payload

Company IDcompany:capgemini us
NameCAPGEMINI US LLC
Normalized Namecapgemini us
Source Company Idscompany_dol_oflc_lca_capgemini_us_llc, company_uscis_h1b_datahub_capgemini_us_llc_tax_2959
Source NamesCAPGEMINI US LLC
AliasesCAPGEMINI US LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2959",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 79,
  "case_count": 79,
  "role_title_count": 27,
  "worksite_count": 13,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2016,
  "latest_decision_date": "2016-06-13",
  "certified_count": 56,
  "denied_count": 0
}
Petition Activity
{
  "total_approval": 2070,
  "total_denial": 105,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_025072"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 2,
      "initial_denial": 0,
      "total_approval": 151,
      "initial_approval": 25,
      "continuing_denial": 2,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_017058",
        "sr_uscis_h1b_datahub_2010_row_017906"
      ],
      "continuing_approval": 126
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60605"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 13,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_019512",
        "sr_uscis_h1b_datahub_2011_row_019513"
      ],
      "continuing_approval": 13
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 64,
      "initial_approval": 8,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_016836"
      ],
      "continuing_approval": 56
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60606"
      ],
      "total_denial": 14,
      "initial_denial": 8,
      "total_approval": 377,
      "initial_approval": 209,
      "continuing_denial": 6,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_015736",
        "sr_uscis_h1b_datahub_2013_row_015737"
      ],
      "continuing_approval": 168
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60606"
      ],
      "total_denial": 34,
      "initial_denial": 27,
      "total_approval": 475,
      "initial_approval": 237,
      "continuing_denial": 7,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_015356",
        "sr_uscis_h1b_datahub_2014_row_015357"
      ],
      "continuing_approval": 238
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60606"
      ],
      "total_denial": 21,
      "initial_denial": 15,
      "total_approval": 550,
      "initial_approval": 243,
      "continuing_denial": 6,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_012235",
        "sr_uscis_h1b_datahub_2015_row_012236"
      ],
      "continuing_approval": 307
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603",
        "60606"
      ],
      "total_denial": 32,
      "initial_denial": 22,
      "total_approval": 437,
      "initial_approval": 106,
      "continuing_denial": 10,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_012782",
        "sr_uscis_h1b_datahub_2016_row_012783"
      ],
      "continuing_approval": 331
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60603"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_capgemini_us_llc_tax_2959_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_011398"
      ],
      "continuing_approval": 2
    }
  ]
}
Geography
{
  "states": [
    "GA",
    "CA",
    "TX",
    "IL",
    "MA",
    "MN",
    "NJ",
    "WA"
  ],
  "cities": [
    "Atlanta",
    "Burbank",
    "Irving",
    "South San Francisco",
    "Chicago",
    "Alpharetta",
    "Malborough",
    "Middleton",
    "Eagan",
    "Bloomfield",
    "Cypress",
    "Mckinney",
    "Bellevue"
  ],
  "postal_codes": [
    "30305",
    "91505",
    "75062",
    "94080",
    "60606",
    "30005",
    "01752",
    "01949",
    "55121",
    "07003",
    "77433",
    "75070",
    "98006",
    "60603",
    "60605"
  ],
  "top_markets": [
    {
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30305",
      "lca_count": 53,
      "role_title_count": 10,
      "wage_low_min": 74200,
      "wage_high_max": 183000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Burbank",
      "state": "CA",
      "postal_code": "91505",
      "lca_count": 9,
      "role_title_count": 9,
      "wage_low_min": 95000,
      "wage_high_max": 271000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Irving",
      "state": "TX",
      "postal_code": "75062",
      "lca_count": 5,
      "role_title_count": 5,
      "wage_low_min": 83000,
      "wage_high_max": 249000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "South San Francisco",
      "state": "CA",
      "postal_code": "94080",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 90355,
      "wage_high_max": 151000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 106000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 90100,
      "wage_high_max": 138000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Malborough",
      "state": "MA",
      "postal_code": "01752",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 133000,
      "wage_high_max": 249000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Middleton",
      "state": "MA",
      "postal_code": "01949",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 112000,
      "wage_high_max": 183000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Eagan",
      "state": "MN",
      "postal_code": "55121",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 150000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Bloomfield",
      "state": "NJ",
      "postal_code": "07003",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 112000,
      "wage_high_max": 183000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "54"
  ]
}
Wage Summary
{
  "annualized_low_min": 74200,
  "annualized_high_max": 271000,
  "annualized_low_avg": 107338.835443038
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 79,
    "case_count": 79,
    "role_title_count": 27,
    "worksite_count": 13,
    "wage_low_min": 74200,
    "wage_high_max": 271000,
    "wage_low_avg": 107338.835443038
  }
]
Links
{
  "roles": "/v1/roles?company=CAPGEMINI%20US%20LLC",
  "wages": "/v1/wages?company=CAPGEMINI%20US%20LLC",
  "trends": "/v1/trends?company=CAPGEMINI%20US%20LLC"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=capgemini+us+llc&limit=5JSON