Fiscal Year

2021

Case Number

A-20143-57740

Case Status

Certified-Expired

Received Date

2020-08-05

Decision Date

2021-03-15

Refile

N

Original File Date

2021-01-01 09:06:19

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

AMAZON WEB SERVICES, INC.

Employer Name Slug

amazon-web-services-inc

Employer Address 1

2250 7TH AVE

Employer Address 2

Employer City

SEATTLE

Employer City Slug

seattle

Employer State

WASHINGTON

Employer State Slug

washington

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

98121

Employer Phone

206-266-1000

Employer Number of Employees

647500

Employer Year Commenced Business

1995

NAICS Code

45411

FW Ownership Interest

N

Employer Contact Name

Sophia Johnykutty

Employer Contact Address 1

2201 Westlake Avenue

Employer Contact Address 2

Suite 500

Employer Contact City

Seattle

Employer Contact State/Province

WASHINGTON WA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

98121

Employer Contact Phone

2062661000

Employer Contact Email

amazonimmigration@amazon.com

Agent Attorney Name

Hector Bondoc

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

469 290-9929

Agent Attorney Address 1

11 Times Square

Agent Attorney Address 2

11th Floor

Agent Attorney City

New York

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10036

Agent Attorney Email

hbondoc@balglobal.com

PW Track Number

P10020008239894

PW SOC Code

15-2031

PW SOC Title

Operations Research Analysts

PW Skill Level

Level II

PW Wage

64355.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-04-09

PW Expiration Date

2020-07-08

Wage Offer From

113400.00

Wage Offer To

158600.00

Average Salary

136000.00

Wage Unit of Pay

Year

Worksite Address 1

13455 Noel Road

Worksite Address 2

Worksite City

Dallas

Worksite City Slug

dallas

Worksite State

TEXAS

Worksite Postal Code

75240

Job Title

Professional Services II – Big Data: MPP/DW Architect

Job Title Slug

professional-services-ii-big-data-mppdw-architect

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Information Systems, Computer or Electronic Engineering, or related field

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science, Information Systems, Computer or Electronic Engineering, 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

60

Accept Alternative Job Title

See H.14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

A Bachelors degree or foreign equivalent in Computer Science, Information Systems, Computer or Electronic Engineering, or related field followed by 5 progressively responsible years of experience in solutions architecture, data management, machine learning, or related field.br br Experience must includebr br 1. 5 years of experience developing and operating largescale data structures for business intelligence analytics using ETLELT processes, and experience with Oracle database, Informatica PowerCenter, SQL, Data lake formation, troubleshooting shell scripting.br 2. 5 years of experience developing experimental and analytics plans for data modeling processes, and experience with data modelling tools CA Erwin, Oracle SQL Developer or equivalents, and logical physical data modeling, large scale database design, quality checks, implementing data centric project methodology.br 3. 5 years of experience in database and analytical technologies and in implementation and tuning, including experience with Oracle database design development, creation of database objects, stored procedure development like PLSQL, dynamic SQL, exception handling, materialized view, performance tuning, SQL data migration.br 4. 5 years of experience in enterprise data architecture, data quality data governance process, including planning executing enterprise data by removing redundancy fragmentation control, mastering enterprise entity using master data management tools like Informatica MDM and IBM Infosphere master data management, performing enterprise data quality improvements using data quality tool like Informatica Data Quality data cleansing or standardization tool like Address Doctor, and data profiling process tool like Informatica Analyst.br 5. 5 years of experience developing and operating largescale data structures for business intelligence analytics using SQL, developing database code SQL for retrieving aggregated data from different sources compiling into a single report, and owning the design, development maintenance of BI infrastructure solutions.br br Up to 25 domestic travel required to various Amazon and client locations to support business and technical relationships. Up to 30 telecommuting allowed.

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

SWA Job Order End Date

2020-06-01

Sunday Edition Newspaper

Y

First Newspaper Name

Dallas Morning News

First Advertisement Start Date

2020-04-26

Second Newspaper Ad Name

Dallas Morning News

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-05-03

Employer Website From Date

2020-05-07

Employer Website To Date

2020-05-14

Professional Organization Ad From Date

2021-01-01 09:06:19

Professional Organization Advertisement To Date

2021-01-01 09:06:19

Job Search Website From Date

2020-04-27

Job Search Website To Date

2020-05-04

Employee Referral Program From Date

2021-01-01 09:06:19

Employee Referral Program To Date

2021-01-01 09:06:19

Local Ethnic Paper From Date

2020-04-30

Local Ethnic Paper To Date

2020-05-06

Radio/TV Ad From Date

2021-01-01 09:06:19

Radio/TV Ad To Date

2021-01-01 09:06:19

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

COMPUTER ENGINEERING

Foreign Worker Years of Education Completed

2002

Foreign Worker Institution of Education

UNIVERSITY OF KALYANI

Foreign Worker Education Institution Address 1

UNIVERSITY OF KALYANI, KALYANI

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NADIA

Foreign Worker Education Institution State/Province

WB

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

741235

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Hector Bondoc

Preparer Title

Associate

Preparer Email

hbondoc@balglobal.com

Employer Information Declaration Name

Sophia R Johnykutty

Employer Information Declaration Title

Sr. U.S. Immigration Project Specialist