All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-19220-42037

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-19220-42037

Case Status

Certified-Expired

Received Date

2019-08-19

Decision Date

2019-11-08

Refile

N

Original File Date

2020-01-01 07:48:25

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Hyundai AutoEver America, LLC

Employer Name Slug

hyundai-autoever-america-llc

Employer Address 1

10550 Talbert Avenue

Employer Address 2

Employer City

Fountain Valley

Employer City Slug

fountain-valley

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

92708

Employer Phone

9494684928

Employer Number of Employees

314

Employer Year Commenced Business

2005

NAICS Code

519

FW Ownership Interest

N

Employer Contact Name

Sandhya Vibhagar

Employer Contact Address 1

10550 Talbert Avenue

Employer Contact Address 2

Employer Contact City

Fountain Valley

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

92708

Employer Contact Phone

9494684928

Employer Contact Email

svibhagar@autoeveramerica.com

Agent Attorney Name

AMRITA JOLLY

Agent Attorney Firm Name

FRAGOMEN, DEL REY, BERNSEN LOEWY LLP

Agent Attorney Phone

9498629443

Agent Attorney Address 1

18401 VON KARMAN AVE

Agent Attorney Address 2

SUITE 255

Agent Attorney City

IRVINE

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

92618

Agent Attorney Email

AJOLLY@FRAGOMEN.COM

PW Track Number

P10019043528621

PW SOC Code

15-1199

PW SOC Title

DATABASE ARCHITECTS

PW Skill Level

Level IV

PW Wage

111426.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-05-23

PW Expiration Date

2019-08-21

Wage Offer From

116520.00

Wage Offer To

0.00

Average Salary

116520.00

Wage Unit of Pay

Year

Worksite Address 1

410 EXCHANGE

Worksite Address 2

Worksite City

IRVINE

Worksite City Slug

irvine

Worksite State

CALIFORNIA

Worksite Postal Code

92602

Job Title

SOFTWARE ENGINEER III

Job Title Slug

software-engineer-iii

Minimum Education

Bachelor's

Major Field of Study

SEE H.11

Required Training

N

Required Experience

Y

Required Experience Months

72

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

SEE H.11

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

CLOSELY RELATED POSITION

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must possess expertiseknowledge sufficient to adequately perform the duties of the job being offered. Expertiseknowledge may be gained through employment experience or education. Such expertiseknowledge cannot be quot;quantifiedquot; by quot;timequot;. Required expertiseknowledge includesbr br Designing high level ETL process and data flow from source system to target databasesbr Knowledge of data model architecture in OLAP systembr Oracle databases and strong SQL and PLSQL knowledge.br Knowledge of EDQbr Understanding of project life cycle, especially tasks within the ETL phase

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-04

SWA Job Order End Date

2019-07-09

Sunday Edition Newspaper

Y

First Newspaper Name

LOS ANGELES TIMES EAST ZONE

First Advertisement Start Date

2019-06-16

Second Newspaper Ad Name

LOS ANGELES TIMES EAST ZONE

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-06-23

Employer Website From Date

2019-06-06

Employer Website To Date

2019-06-19

Professional Organization Ad From Date

2020-01-01 07:48:25

Professional Organization Advertisement To Date

2020-01-01 07:48:25

Job Search Website From Date

2019-06-19

Job Search Website To Date

2019-06-25

Employee Referral Program From Date

2020-01-01 07:48:25

Employee Referral Program To Date

2020-01-01 07:48:25

Local Ethnic Paper From Date

2019-06-19

Local Ethnic Paper To Date

2019-06-19

Radio/TV Ad From Date

2020-01-01 07:48:25

Radio/TV Ad To Date

2020-01-01 07:48:25

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 INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2002

Foreign Worker Institution of Education

MAHARSHI DAYANAND UNIVERSITY, ROHTAK

Foreign Worker Education Institution Address 1

TIGAON RD., NEAR SAI DHAM, SECTOR 86

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FARIDABAD

Foreign Worker Education Institution State/Province

HARYANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

121002

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

AMRITA JOLLY

Preparer Title

ASSOCIATE

Preparer Email

AJOLLY@FRAGOMEN.COM

Employer Information Declaration Name

JOELLEN WHITEWOLF

Employer Information Declaration Title

PRINCIPAL, HUMAN RESOURCES ADMINISTRATION