Fiscal Year

2022

Case Number

A-21162-00204

Case Status

Certified

Received Date

2021-07-29

Decision Date

2022-04-20

Refile

N

Original File Date

2022-01-01 11:17:37

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

STANFORD HEALTH CARE

Employer Name Slug

stanford-health-care

Employer Address 1

1850 EMBARCADERO

Employer Address 2

SUITE B

Employer City

PALO ALTO

Employer City Slug

palo-alto

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

94303

Employer Phone

(650) 723-4748

Employer Number of Employees

14000

Employer Year Commenced Business

1959

NAICS Code

622110

FW Ownership Interest

N

Employer Contact Name

Mark W Hyde

Employer Contact Address 1

1850 Embarcadero Rd.

Employer Contact Address 2

Suite B

Employer Contact City

Palo Alto

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

94303

Employer Contact Phone

650.736.4967

Employer Contact Email

mhyde@stanfordhealthcare.org

Agent Attorney Name

Kelly S Wachs

Agent Attorney Firm Name

The Law Office of Kelly S. Wachs, PC

Agent Attorney Phone

8316615210

Agent Attorney Address 1

8070 Soquel Drive.

Agent Attorney Address 2

Suite #130

Agent Attorney City

Aptos

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

95003

Agent Attorney Email

Kelly@kellywachs.com

PW Track Number

P10020244796327

PW SOC Code

15-1034

PW SOC Title

Software Developers, Applications, Non RD

PW Skill Level

Level IV

PW Wage

107411.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-03-19

PW Expiration Date

2021-06-30

Wage Offer From

140004.80

Wage Offer To

0.00

Average Salary

140004.80

Wage Unit of Pay

Year

Worksite Address 1

Stanford Health Care

Worksite Address 2

Discovery Hall, 455 Broadway

Worksite City

Redwood City

Worksite City Slug

redwood-city

Worksite State

CALIFORNIA

Worksite Postal Code

94063

Job Title

Senior ETL Developer

Job Title Slug

senior-etl-developer

Minimum Education

Bachelor's

Major Field of Study

information or business-related field

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

60

Accept Alternative Job Title

IT or business Intelligence related position.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Five 5 years of progressive, postbaccalaureate experience in an IT or business intelligence related position.br br br Five 5 years of experience with ETL design and development that must include3 years of experience with Informatica Power Center; 2 years of experience with SQL in an Oracle andor SQL Server environment; Experience delivering highquality Reporting Analytics solutions; Experience implementing ETL principles and best practices, including error handling, logging alerting, scheduling, and job control; Demonstrated ability to utilize performance tuning utilities Explain Plans, etc. to optimize queries to meet user needs and improve normal operations; Data Definition Language DDL, Data Manipulation Language DML, and Extraction, Transformation, and Loading ETL design and development using SQL Server tools SQL Management Studio, TSQL, SSIS, Team Foundation, etc., Oracle tools, andor Epic Clarity Compass; Experience applying Lean concepts including visibility walls, problemsolving A3s, and Gemba rounding principles.

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

2021-04-12

SWA Job Order End Date

2021-05-15

Sunday Edition Newspaper

Y

First Newspaper Name

San Francisco Chronicle

First Advertisement Start Date

2021-05-09

Second Newspaper Ad Name

San Francisco Chronicle

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-05-16

Employer Website From Date

2021-04-09

Employer Website To Date

2021-05-10

Professional Organization Ad From Date

2022-01-01 11:17:37

Professional Organization Advertisement To Date

2022-01-01 11:17:37

Job Search Website From Date

2022-01-01 11:17:37

Job Search Website To Date

2022-01-01 11:17:37

Employee Referral Program From Date

2022-01-01 11:17:37

Employee Referral Program To Date

2022-01-01 11:17:37

Local Ethnic Paper From Date

2021-05-13

Local Ethnic Paper To Date

2021-05-13

Radio/TV Ad From Date

2021-05-12

Radio/TV Ad To Date

2021-05-12

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

INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2003

Foreign Worker Institution of Education

KAKATIYA UNIVERSITY

Foreign Worker Education Institution Address 1

NH563 VIDYARANYAPURI

Foreign Worker Education Institution Address 2

HANAMKONDA

Foreign Worker Education Institution City

WARANGAL

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

506009

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Kelly S Wachs

Preparer Title

Attorney at Law

Preparer Email

kelly@kellywachs.com

Employer Information Declaration Name

Mark W Hyde

Employer Information Declaration Title

Director, Talent Acquisition