All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21287-58331
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21287-58331
Case Status
Certified
Received Date
2021-12-01
Decision Date
2022-07-06
Refile
N
Original File Date
2022-01-01 11:42:08
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
GOLDMAN SACHS CO. LLC
Employer Name Slug
goldman-sachs-co-llc
Employer Address 1
200 WEST STREET
Employer Address 2
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
10282
Employer Phone
212-902-1000
Employer Number of Employees
11675
Employer Year Commenced Business
1869
NAICS Code
523110
FW Ownership Interest
N
Employer Contact Name
NATALIA MATILEVICA
Employer Contact Address 1
30 HUDSON STREET
Employer Contact Address 2
Employer Contact City
JERSEY CITY
Employer Contact State/Province
NEW JERSEY
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
7302
Employer Contact Phone
212-902-1000
Employer Contact Email
natalia.matilevica@gs.com
Agent Attorney Name
Mishita Jethi
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
2126888555
Agent Attorney Address 1
1400 Broadway
Agent Attorney Address 2
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
MJethi@Fragomen.com
PW Track Number
P10021048081931
PW SOC Code
15-1199
PW SOC Title
Computer Occupations, All Other
PW Skill Level
Level II
PW Wage
76856.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-07-30
PW Expiration Date
2022-06-30
Wage Offer From
80000.00
Wage Offer To
134000.00
Average Salary
107000.00
Wage Unit of Pay
Year
Worksite Address 1
2001 Ross Avenue
Worksite Address 2
Suite 2800
Worksite City
Dallas
Worksite City Slug
dallas
Worksite State
TEXAS
Worksite Postal Code
75201
Job Title
Associate
Job Title Slug
associate
Minimum Education
Bachelor's
Major Field of Study
Please see addendum of section H.14
Required Training
N
Required Experience
Y
Required Experience Months
36
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
36
Accept Alternative Job Title
A related position dealing with data analytics.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Must have three 3 years of experience in the following Structured Databases and Data Warehouses Utilizing databases, including SQL Server and Sybase IQ Data Warehouse, for ingesting, validating and reporting data, internally and to external constituents; Operational Reporting Building custom and automated reporting solutions using SQLbased databases; SQL Creating complex queries and joins, creating tables and views, designing and creating stored procedures; and Microsoft Excel including using VLOOKUP, HLOOKUP, WhatIf Analysis, creation and updating of macros, and using pivot tables to summarize and analyze data. Must have two 2 years of experience in the following Data Modeling Building logical and physical data models of business processes and reporting requirements. Must have one 1 year of experience in the following Mortgage business operations and reporting, including analysis and interpretation of mortgage attributes; Dataflow or ETL Extract Transform Load using the data tools CAS, Alteryx and Microsoft SSIS SQL Server Integration Servicers; Using scripting tools including Powershell and Visual Basic; Data visualization and reporting tools including Tableau, Qlickview; and Utilizing high level programming languages C, C, Java and Python.br br CONTINUED FROM SECTION H.4B Bachelors degree U.S. or foreign equivalent in Finance, Mathematics, Business, Information Systems or a relevant Engineering discipline such as Electronic Engineering.
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
2021-08-26
SWA Job Order End Date
2021-09-27
Sunday Edition Newspaper
Y
First Newspaper Name
Dallas Morning News
First Advertisement Start Date
2021-09-05
Second Newspaper Ad Name
Dallas Morning News
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-09-12
Employer Website From Date
2021-08-25
Employer Website To Date
2021-10-09
Professional Organization Ad From Date
2022-01-01 11:42:08
Professional Organization Advertisement To Date
2022-01-01 11:42:08
Job Search Website From Date
2021-09-05
Job Search Website To Date
2021-09-20
Employee Referral Program From Date
2021-08-25
Employee Referral Program To Date
2021-09-09
Local Ethnic Paper From Date
2022-01-01 11:42:08
Local Ethnic Paper To Date
2022-01-01 11:42:08
Radio/TV Ad From Date
2022-01-01 11:42:08
Radio/TV Ad To Date
2022-01-01 11:42:08
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
L-1
Foreign Worker Education
Bachelor's
Foreign Worker Information: Major
ELECTRONIC ENGINEERING
Foreign Worker Years of Education Completed
2010
Foreign Worker Institution of Education
GOA UNIVERSITY
Foreign Worker Education Institution Address 1
UNIVERSITY ROAD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
TALEIGAO
Foreign Worker Education Institution State/Province
GOA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
403206
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Mishita Jethi
Preparer Title
Attorney
Preparer Email
MJethi@fragomen.com
Employer Information Declaration Name
Natalia Matilevica
Employer Information Declaration Title
Vice President, Human Capital Management