All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22293-43144
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22293-43144
Case Status
Certified-Expired
Received Date
2022-11-14
Decision Date
2023-10-05
Refile
N
Original File Date
2024-01-01 00:02:46
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
REPUBLIC SERVICES, INC.
Employer Name Slug
republic-services-inc
Employer Address 1
18500 N. ALLIED WAY
Employer Address 2
Employer City
PHOENIX
Employer City Slug
phoenix
Employer State
ARIZONA
Employer State Slug
arizona
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
85054
Employer Phone
4806272700
Employer Number of Employees
40000
Employer Year Commenced Business
1996
NAICS Code
562111
FW Ownership Interest
N
Employer Contact Name
Elizabeth Duross
Employer Contact Address 1
18500 N. Allied Way
Employer Contact Address 2
Employer Contact City
Phoenix
Employer Contact State/Province
ARIZONA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
85054
Employer Contact Phone
4806272767
Employer Contact Email
eduross@republicservices.com
Agent Attorney Name
Otieno B Ombok
Agent Attorney Firm Name
Jackson Lewis PC
Agent Attorney Phone
9148726895
Agent Attorney Address 1
44 South Broadway
Agent Attorney Address 2
14th Floor
Agent Attorney City
White Plains
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10601
Agent Attorney Email
otieno.ombok@jacksonlewis.com
PW Track Number
P10022026855734
PW SOC Code
15-1252.00
PW SOC Title
Software Developers
PW Skill Level
Level II
PW Wage
95139.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-07-13
PW Expiration Date
2023-06-30
Wage Offer From
95139.00
Wage Offer To
0.00
Average Salary
95139.00
Wage Unit of Pay
Year
Worksite Address 1
14400 North 87th Street
Worksite Address 2
Suite 300
Worksite City
Scottsdale
Worksite City Slug
scottsdale
Worksite State
ARIZONA
Worksite Postal Code
85260
Job Title
ETL Developer II
Job Title Slug
etl-developer-ii
Minimum Education
Bachelor's
Major Field of Study
Computer Science, Engineering, or Statistics
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
36
Accept Alternative Job Title
See H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Requires 3 years of experience in IT operations and support performing ETL using the Informatica tool set; 3 years of experience working on large data initiatives gt;2 terabytes; 2 years of experience with at least three of the following Oracle, DB2, SQL Server, Teradata, IBM, and Informatica modules IDQ, PowerCenter, MDM, and ETL; 2 years of experience with at least two of the following SQLServer, Oracle, DB2, MySQL, MarkLogic, Denodo, AWS; 2 years of experience with at least 1 of the following Informatica modules PowerCenter, CDC, ETL workflows, IDQ, MDM Hub Configuration, Validation rules, IDD Configuration, Validation rules. The role may presently be performed remotely in the State of Arizona, but this is subject to change.
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-26
SWA Job Order End Date
2022-08-31
Sunday Edition Newspaper
Y
First Newspaper Name
The Arizona Republic
First Advertisement Start Date
2022-08-14
Second Newspaper Ad Name
The Arizona Republic
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-08-21
Employer Website From Date
2022-07-21
Employer Website To Date
2022-08-25
Professional Organization Ad From Date
2024-01-01 00:02:46
Professional Organization Advertisement To Date
2024-01-01 00:02:46
Job Search Website From Date
2022-08-16
Job Search Website To Date
2022-09-14
Employee Referral Program From Date
2024-01-01 00:02:46
Employee Referral Program To Date
2024-01-01 00:02:46
Local Ethnic Paper From Date
2022-08-21
Local Ethnic Paper To Date
2022-08-21
Radio/TV Ad From Date
2024-01-01 00:02:46
Radio/TV Ad To Date
2024-01-01 00:02:46
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
COMPUTER SCIENCE SOFTWARE ENGINEERING
Foreign Worker Years of Education Completed
2019
Foreign Worker Institution of Education
OKLAHOMA CHRISTIAN UNIVERSITY
Foreign Worker Education Institution Address 1
2501 E MEMORIAL RD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
EDMOND
Foreign Worker Education Institution State/Province
OK
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
73013
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Otieno B Ombok
Preparer Title
Attorney
Preparer Email
otieno.ombok@jacksonlewis.com
Employer Information Declaration Name
Jennifer Thomson
Employer Information Declaration Title
Vice President, Associate General Counsel