All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22109-42686
Fiscal year: 2023
Fiscal Year
2023
Case Number
A-22109-42686
Case Status
Certified
Received Date
2022-05-17
Decision Date
2023-02-24
Refile
N
Original File Date
2023-01-01 08:05:15
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
National Cable Communications LLC
Employer Name Slug
national-cable-communications-llc
Employer Address 1
151 West 42nd 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
10036
Employer Phone
5163302553
Employer Number of Employees
625
Employer Year Commenced Business
1980
NAICS Code
541810
FW Ownership Interest
N
Employer Contact Name
John M Calvo
Employer Contact Address 1
151 West 42nd Street
Employer Contact Address 2
Employer Contact City
New York
Employer Contact State/Province
NEW YORK
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
10036
Employer Contact Phone
5163302553
Employer Contact Email
john.calvo@ampersand.tv
Agent Attorney Name
Michael Haven
Agent Attorney Firm Name
Goldman Partners Immigration Law, LLP
Agent Attorney Phone
9782195040
Agent Attorney Address 1
125 Washington St
Agent Attorney Address 2
Suite 204
Agent Attorney City
Salem
Agent Attorney State/Province
MASSACHUSETTS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
1970
Agent Attorney Email
mike@gpimmigration.com
PW Track Number
P10021230529257
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level II
PW Wage
95680.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-02-15
PW Expiration Date
2022-06-30
Wage Offer From
160000.00
Wage Offer To
0.00
Average Salary
160000.00
Wage Unit of Pay
Year
Worksite Address 1
151 West 42nd Street
Worksite Address 2
11th Floor
Worksite City
New York
Worksite City Slug
new-york
Worksite State
NEW YORK
Worksite Postal Code
10036
Job Title
Data Engineer
Job Title Slug
data-engineer
Minimum Education
Master's
Major Field of Study
Computer Science, Computer Engineering or a 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
Building and designing big data pipelines in an industrial setting
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Masters degree in Computer Science, Computer Engineering or a related field or foreign degree equivalent, plus 2 years of progressively responsible experience in building and designing big data pipelines in an industrial setting.br br Experience, which may be gained concurrently, must include the followingbr br 2 years of experience working with cloud technologies and AWS services like EC2, S3, EMR, Redshift, Glue, Prestobr 2 years of experience building and optimizing distributed and scalable solutionsbr 2 years of experience and proficiency in using Python, Scala and SQLbr 2 years of experience building and optimizing big data data pipelines, architectures and data setsbr 2 years of experience with big data tools including Spark and gluebr 2 years of experience working with relational databases
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-02-25
SWA Job Order End Date
2022-03-31
Sunday Edition Newspaper
Y
First Newspaper Name
The New York Times
First Advertisement Start Date
2022-03-06
Second Newspaper Ad Name
The New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-03-13
Employer Website From Date
2023-01-01 08:05:15
Employer Website To Date
2023-01-01 08:05:15
Professional Organization Ad From Date
2023-01-01 08:05:15
Professional Organization Advertisement To Date
2023-01-01 08:05:15
Job Search Website From Date
2022-03-03
Job Search Website To Date
2022-04-02
Employee Referral Program From Date
2023-01-01 08:05:15
Employee Referral Program To Date
2023-01-01 08:05:15
Local Ethnic Paper From Date
2022-03-09
Local Ethnic Paper To Date
2022-03-09
Radio/TV Ad From Date
2022-03-07
Radio/TV Ad To Date
2022-03-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
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
ELECTRICAL AND COMPUTER ENGINEERING
Foreign Worker Years of Education Completed
2017
Foreign Worker Institution of Education
RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY
Foreign Worker Education Institution Address 1
57 US HIGHWAY 1
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
NEW BRUNSWICK
Foreign Worker Education Institution State/Province
NJ
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
8901
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Michael Haven
Preparer Title
Attorney
Preparer Email
mike@gpimmigration.com
Employer Information Declaration Name
John Calvo
Employer Information Declaration Title
Senior Director of People Operations