Fiscal Year

2024

Case Number

A-22269-28121

Case Status

Certified-Expired

Received Date

2022-11-22

Decision Date

2023-10-13

Refile

N

Original File Date

2024-01-01 00:05:32

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MCKINSEY COMPANY, INC UNITED STATES

Employer Name Slug

mckinsey-company-inc-united-states

Employer Address 1

711 3RD AVENUE

Employer Address 2

4TH FLOOR

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10017

Employer Phone

212-446-7000

Employer Number of Employees

9000

Employer Year Commenced Business

1926

NAICS Code

54161

FW Ownership Interest

N

Employer Contact Name

Sona M Patel

Employer Contact Address 1

1 Deforest Avenue

Employer Contact Address 2

Suite 300

Employer Contact City

Summit

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

7901

Employer Contact Phone

646-203-2946

Employer Contact Email

Sona_M_Patel@mckinsey.com

Agent Attorney Name

Nishita S Desai

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

6468616942

Agent Attorney Address 1

1400 Broadway

Agent Attorney Address 2

9th FL

Agent Attorney City

New York

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10018

Agent Attorney Email

McKinseyIV@Fragomen.com

PW Track Number

P10021288647161

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level III

PW Wage

121722.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-04-15

PW Expiration Date

2022-07-14

Wage Offer From

218900.00

Wage Offer To

0.00

Average Salary

218900.00

Wage Unit of Pay

Year

Worksite Address 1

McKinsey Company Inc. United States

Worksite Address 2

1200 Nineteenth Street NW, Suite 1000

Worksite City

Washington

Worksite City Slug

washington

Worksite State

DISTRICT OF COLUMBIA

Worksite Postal Code

20036

Job Title

Staff Engineer

Job Title Slug

staff-engineer

Minimum Education

Master's

Major Field of Study

Information Systems, Data Analytics, Computer Science, or related field or foreign degree equivalent

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

designing and developing data ETL services.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Addendum to H.4, Education Masters degree in Information Systems, Data Analytics, Computer Science, or related field or foreign degree equivalent.br br Addendum to H.10B, Acceptable alternate occupation Minimum two 2 years of experience designing and developing data ETL services.br br Specific skills Experience must have included using advanced SQL, Python, advanced NoSQL database technologies; scripting languages Unix and Python; and using following version control tools Git. Academic or professional experience using reporting tools and technologies Tableau; building big data platforms; and building scalable backend systems.

Combination Occupation

N

Offered to Applicant Foreign Worker

Y

Foreign Worker Live on Premises

N

Foreign Worker Live in Domestic Service

N

Foreign Worker Live in Domestic Service Count

Professional Occupation

Y

Application for College/University Teacher

N

SWA Job Order Start Date

2022-07-14

SWA Job Order End Date

2022-08-26

Sunday Edition Newspaper

Y

First Newspaper Name

The Washington Post

First Advertisement Start Date

2022-07-17

Second Newspaper Ad Name

The Washington Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-07-24

Employer Website From Date

2024-01-01 00:05:32

Employer Website To Date

2024-01-01 00:05:32

Professional Organization Ad From Date

2024-01-01 00:05:32

Professional Organization Advertisement To Date

2024-01-01 00:05:32

Job Search Website From Date

2022-07-08

Job Search Website To Date

2022-08-07

Employee Referral Program From Date

2022-07-07

Employee Referral Program To Date

2022-07-22

Local Ethnic Paper From Date

2022-07-13

Local Ethnic Paper To Date

2022-07-13

Radio/TV Ad From Date

2024-01-01 00:05:32

Radio/TV Ad To Date

2024-01-01 00:05:32

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

INDIA

Foreign Worker Birth Country

INDIA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

BUSINESS ADMINISTRATION INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

UNIVERSITY OF CINCINNATI

Foreign Worker Education Institution Address 1

2600 CLIFTON AVE.

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

CINCINNATI

Foreign Worker Education Institution State/Province

OH

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

45221

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Nishita S Desai

Preparer Title

Attorney

Preparer Email

McKinseyIV@fragomen.com

Employer Information Declaration Name

Sona M Patel

Employer Information Declaration Title

Assistant General Counsel Immigration