All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20237-91207
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20237-91207
Case Status
Certified
Received Date
2020-12-07
Decision Date
2021-06-04
Refile
N
Original File Date
2021-01-01 09:31:19
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ERNST YOUNG U.S. LLP
Employer Name Slug
ernst-young-us-llp
Employer Address 1
200 PLAZA DRIVE
Employer Address 2
Employer City
SECAUCUS
Employer City Slug
secaucus
Employer State
NEW JERSEY
Employer State Slug
new-jersey
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
7094
Employer Phone
201-872-2200
Employer Number of Employees
40000
Employer Year Commenced Business
1989
NAICS Code
541211
FW Ownership Interest
N
Employer Contact Name
Sunday D Rubenstein
Employer Contact Address 1
200 Plaza Drive
Employer Contact Address 2
Employer Contact City
Secaucus
Employer Contact State/Province
NEW JERSEY
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
7094
Employer Contact Phone
201-872-2200 2899
Employer Contact Email
Sunday.Rubenstein@ey.com
Agent Attorney Name
Roy Hollis
Agent Attorney Firm Name
EY Law LLP
Agent Attorney Phone
416 943 3163
Agent Attorney Address 1
100 Adelaide Street West
Agent Attorney Address 2
Floor 31
Agent Attorney City
Toronto
Agent Attorney State/Province
ON
Agent Attorney Country
CANADA
Agent Attorney Postal Code
M5H 0B3
Agent Attorney Email
eyusperm@ca.ey.com
PW Track Number
P10020083428770
PW SOC Code
15-1121
PW SOC Title
Computer Systems Analysts
PW Skill Level
N/A
PW Wage
115000.00
PW Unit of Pay
Year
PW Wage Source
Other
PW Determination Date
2020-06-12
PW Expiration Date
2020-09-10
Wage Offer From
115000.00
Wage Offer To
0.00
Average Salary
115000.00
Wage Unit of Pay
Year
Worksite Address 1
560 Mission Street
Worksite Address 2
Suite 1600
Worksite City
San Francisco
Worksite City Slug
san-francisco
Worksite State
CALIFORNIA
Worksite Postal Code
94105
Job Title
IT Advisor, PI -Tech Consulting - (DDA – Data Engineer)(Mng)
Job Title Slug
it-advisor-pi-tech-consulting-dda-data-engineermng
Minimum Education
Bachelor's
Major Field of Study
Mathematics
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Information Systems, Statistics, Computer Science, or a related field
Accept Alternative Combination
Y
Accept Alternative Combination Education
Master's
Accept Alternative Combination Education Years
4
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
Any in which the required experience is gained.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors degree in Mathematics, Information Systems, Statistics, Computer Science, or a related field of study and 5 years of postbaccalaureate, progressive related work experience; or a Masters degree Mathematics, Information Systems, Statistics, Computer Science, or a related field of study and 4 years of related work experience.br br Must have 4 years of professional services or consulting experience.br br Must have 4 years of handson experience with various relational and NoSQL database technologies, including SQL Server, DB2, Oracle, Cassandra, MongoDB, Azure DB or Neo4J.br br Must have 2 years of hands on experience with architecture and implementation of data warehouse and ETL solutions.br br Must have 3 years of experience with logical and physical data modeling.br br Must have 4 years of experience with SQL, C#, R and TypescriptJavascript.br br Must have 2 years of experience in API development and 3tier application development.br br Must have 2 years of experience with big data platforms, Microsoft Azure technologies and serverless environment.br br Must have 2 years of experience leading teams of data professionals.br br Requires travel up to 80.br br Employer will accept any suitable combination of education, training or experience.
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
2020-07-08
SWA Job Order End Date
2020-08-13
Sunday Edition Newspaper
Y
First Newspaper Name
San Francisco Chronicle
First Advertisement Start Date
2020-07-12
Second Newspaper Ad Name
San Francisco Chronicle
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-07-19
Employer Website From Date
2020-07-08
Employer Website To Date
2020-08-14
Professional Organization Ad From Date
2021-01-01 09:31:19
Professional Organization Advertisement To Date
2021-01-01 09:31:19
Job Search Website From Date
2020-07-13
Job Search Website To Date
2020-07-13
Employee Referral Program From Date
2020-07-08
Employee Referral Program To Date
2020-08-14
Local Ethnic Paper From Date
2021-01-01 09:31:19
Local Ethnic Paper To Date
2021-01-01 09:31:19
Radio/TV Ad From Date
2021-01-01 09:31:19
Radio/TV Ad To Date
2021-01-01 09:31:19
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
INFORMATION MANAGEMENT REL. TO INFORMATION SYSTEMS
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
SYRACUSE UNIVERSITY
Foreign Worker Education Institution Address 1
900 SOUTH CROUSE AVE.
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
SYRACUSE
Foreign Worker Education Institution State/Province
NY
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
13244
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Roy Hollis
Preparer Title
Attorney
Preparer Email
eyusperm@ca.ey.com
Employer Information Declaration Name
Renet Shakeria FAGAN COLLIECHARLTON
Employer Information Declaration Title
Supervising AssociateAssociate Director, Americas