All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19228-45227
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19228-45227
Case Status
Certified-Expired
Received Date
2019-09-06
Decision Date
2019-12-23
Refile
N
Original File Date
2020-01-01 07:50:29
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
480-627-2767
Employer Number of Employees
34000
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
480-627-2767
Employer Contact Email
eduross@republicservices.com
Agent Attorney Name
Gabriel H Mozes
Agent Attorney Firm Name
Seyfarth Shaw LLP
Agent Attorney Phone
(404) 885-6758
Agent Attorney Address 1
1075 Peachtree Street, N.E.
Agent Attorney Address 2
Suite 2500
Agent Attorney City
Atlanta
Agent Attorney State/Province
GEORGIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
30309-3958
Agent Attorney Email
swilkinson@seyfarth.com
PW Track Number
P10018348050798
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level IV
PW Wage
114650.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-04-25
PW Expiration Date
2019-07-24
Wage Offer From
114650.00
Wage Offer To
0.00
Average Salary
114650.00
Wage Unit of Pay
Year
Worksite Address 1
14400 N. 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 III
Job Title Slug
etl-developer-iii
Minimum Education
Bachelor's
Major Field of Study
Computer Science
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Engineering, Statistics or related field
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
72
Accept Alternative Job Title
performing ETL using the Informatica tool set in IT operations and support
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Requires Bachelors degree in computer science, engineering, statistics or related field willing to accept foreign education equivalent plus six years of experience performing ETL using the Informatica tool set in IT operations and support. Specific skillsother requirements quantitative experience requirements not applicable to this section at least five years of experience working on large data initiatives gt;5 terabytes and at least three years of experience with at least three of the following Oracle, DB2, SQL Server, Teradata, IBM, and Informatica modules IDQ, PowerCenter, MDM, and ETL.
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
2019-06-25
SWA Job Order End Date
2019-07-30
Sunday Edition Newspaper
Y
First Newspaper Name
The Arizona Republic
First Advertisement Start Date
2019-06-30
Second Newspaper Ad Name
The Arizona Republic
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-07-07
Employer Website From Date
2019-07-03
Employer Website To Date
2019-07-22
Professional Organization Ad From Date
2020-01-01 07:50:29
Professional Organization Advertisement To Date
2020-01-01 07:50:29
Job Search Website From Date
2019-07-01
Job Search Website To Date
2019-07-08
Employee Referral Program From Date
2020-01-01 07:50:29
Employee Referral Program To Date
2020-01-01 07:50:29
Local Ethnic Paper From Date
2019-06-27
Local Ethnic Paper To Date
2019-06-27
Radio/TV Ad From Date
2020-01-01 07:50:29
Radio/TV Ad To Date
2020-01-01 07:50:29
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
Bachelor's
Foreign Worker Information: Major
ELECTRICAL AND ELECTRONICS ENGINEERING
Foreign Worker Years of Education Completed
2002
Foreign Worker Institution of Education
BANGALORE UNIVERSITY
Foreign Worker Education Institution Address 1
GNANA BHARATHI MAIN ROAD, GNANA BHARATHI
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
BENGALURU
Foreign Worker Education Institution State/Province
KARNATAKA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
560056
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Gabriel H Mozes
Preparer Title
Attorney
Preparer Email
swilkinson@seyfarth.com
Employer Information Declaration Name
Myndi Kort
Employer Information Declaration Title
VP and Associate General Counsel