All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-20198-77301

Fiscal year: 2021

Fiscal Year

2021

Case Number

A-20198-77301

Case Status

Certified

Received Date

2020-07-16

Decision Date

2021-04-30

Refile

N

Original File Date

2021-01-01 09:18:13

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

YAPSTONE HOLDINGS, INC.

Employer Name Slug

yapstone-holdings-inc

Employer Address 1

2121 NORTH CALIFORNIA BLVD

Employer Address 2

SUITE 400

Employer City

WALNUT CREEK

Employer City Slug

walnut-creek

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

94596

Employer Phone

925-954-6865

Employer Number of Employees

140

Employer Year Commenced Business

1999

NAICS Code

518210

FW Ownership Interest

N

Employer Contact Name

Monique Sao

Employer Contact Address 1

2121 N. CALIFORNIA BOULEVARD

Employer Contact Address 2

SUITE 400

Employer Contact City

WALNUT CREEK

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

94596

Employer Contact Phone

925-954-6690

Employer Contact Email

msao@yapstone.com

Agent Attorney Name

Anna P Ozdemir

Agent Attorney Firm Name

Weaver Schlenger LLP

Agent Attorney Phone

415 395-9331

Agent Attorney Address 1

550 Montgomery Street

Agent Attorney Address 2

Ste 650

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94111

Agent Attorney Email

pozdemir@wsmimmigration.com

PW Track Number

P10019102039377

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level II

PW Wage

119122.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-07-26

PW Expiration Date

2020-06-30

Wage Offer From

161200.00

Wage Offer To

201800.00

Average Salary

181500.00

Wage Unit of Pay

Year

Worksite Address 1

2121 N. California Blvd

Worksite Address 2

Ste. 400

Worksite City

Walnut Creek

Worksite City Slug

walnut-creek

Worksite State

CALIFORNIA

Worksite Postal Code

94596

Job Title

Senior Data Engineer (Big Data)

Job Title Slug

senior-data-engineer-big-data

Minimum Education

Master's

Major Field of Study

Computer Science, Computer Engineering, Electrical or Electronics Engineering or rel tech f

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

See Section H.14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

The position indicated at Section H.3 requires a Masters degree in Computer Science, Computer Engineering, Electrical or Electronics Engineering or related technical field and 2 years of data engineering, software development, or related experience developing software applications for ecommerce, retail, and finance. Employer will accept as the equivalent a Bachelors degree in one of the requisite fields and 5 years of data engineering, software development, or related experience developing software applications for ecommerce, retail, and finance. Experience must include Developing business algorithms and integrations across systems using ETLingestion pipelines using informatica or streaming technologies, version control systems, and scheduling tools; Working with Big Data frameworks to develop complex high availability, scalable, unstructured data for business dashboards and reporting; Developing SQL queries and creating snapshots using one of the following databases Oracle, SQL Server, PostgresMySQL, andor SnowFlake; and Experience with Python, Unix shell scripting, PLSQL, C, Java, and Java Script programming languages.

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

2020-03-03

SWA Job Order End Date

2020-04-06

Sunday Edition Newspaper

Y

First Newspaper Name

East Bay Times

First Advertisement Start Date

2020-03-15

Second Newspaper Ad Name

East Bay Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-03-22

Employer Website From Date

2021-01-01 09:18:13

Employer Website To Date

2021-01-01 09:18:13

Professional Organization Ad From Date

2021-01-01 09:18:13

Professional Organization Advertisement To Date

2021-01-01 09:18:13

Job Search Website From Date

2020-03-06

Job Search Website To Date

2020-03-20

Employee Referral Program From Date

2021-01-01 09:18:13

Employee Referral Program To Date

2021-01-01 09:18:13

Local Ethnic Paper From Date

2021-01-01 09:18:13

Local Ethnic Paper To Date

2021-01-01 09:18:13

Radio/TV Ad From Date

2020-06-10

Radio/TV Ad To Date

2020-06-10

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

ELECTRONIC ENGINEERING U.S. EQUIVALENT

Foreign Worker Years of Education Completed

1999

Foreign Worker Institution of Education

MANONMANIAM SUNDARANAR UNIVERSITY

Foreign Worker Education Institution Address 1

K.R.NAGAR, NALATINPUTHUR

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

KOVILPATTI

Foreign Worker Education Institution State/Province

TAMILNADU

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

628503

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Anna P Ozdemir

Preparer Title

Attorney

Preparer Email

pozdemir@wsmimmigration.com

Employer Information Declaration Name

David Durant

Employer Information Declaration Title

EVP, Chief Administrative Officer General Counse