Fiscal Year

2022

Case Number

A-21147-92736

Case Status

Certified-Expired

Received Date

2021-06-22

Decision Date

2021-11-19

Refile

N

Original File Date

2022-01-01 10:27:43

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

AMGEN INC.

Employer Name Slug

amgen-inc

Employer Address 1

ONE AMGEN CENTER DRIVE

Employer Address 2

Employer City

THOUSAND OAKS

Employer City Slug

thousand-oaks

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

91320

Employer Phone

805-447-1000

Employer Number of Employees

12973

Employer Year Commenced Business

1980

NAICS Code

54171

FW Ownership Interest

N

Employer Contact Name

Jenny Cummings

Employer Contact Address 1

2202 N. Westshore Blvd.

Employer Contact Address 2

Employer Contact City

Tampa

Employer Contact State/Province

FLORIDA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

33607

Employer Contact Phone

813-392-0428

Employer Contact Email

jen01@amgen.com

Agent Attorney Name

Laura Bloniarz

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

469 290 9687

Agent Attorney Address 1

2400 N Glenville Drive, Building A

Agent Attorney Address 2

Suite 100

Agent Attorney City

Richardson

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

75082

Agent Attorney Email

labloniarz@balglobal.com

PW Track Number

P10020325921769

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level II

PW Wage

81806.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-04-06

PW Expiration Date

2021-07-05

Wage Offer From

110968.00

Wage Offer To

0.00

Average Salary

110968.00

Wage Unit of Pay

Year

Worksite Address 1

2202 N Westshore Blvd

Worksite Address 2

Worksite City

Tampa

Worksite City Slug

tampa

Worksite State

FLORIDA

Worksite Postal Code

33607

Job Title

Data Engineer

Job Title Slug

data-engineer

Minimum Education

Master's

Major Field of Study

See H.14

Required Training

N

Required Experience

Y

Required Experience Months

24

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 H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

MASTERS DEGREE IN DATA ANALYTICS ENGINEERING OR A RELATED FIELD, AND 2 YEARS OF PROGRESSIVE EXPERIENCE IN THE FOLLOWING UTILIZING AWS S3 LIFECYCLE POLICY, S3 STORAGE CLASSES, S3 CROSSREGION REPLICATION, REDSHIFT DISTRIBUTION KEY AND SORT KEY, DATABRICKS DATA LAKE, DELTA LAKE DISASTER RECOVERY, SPARKS LOGICAL AND PHYSICAL PLAN, DYNAMIC CLUSTER SETTINGS TO DESIGN DATA PIPELINE; PROCESSING AND MANAGING LARGE DATA SETS UTILIZING APACHE SPARK, SCALA OR PYSPARK; DESIGNING TRANSACTIONAL AND DATA WAREHOUSE DATA MODELS FOR MASTER DATA MANAGEMENT, MULTICHANNEL MARKETING DATA, GLOBAL AND REGIONAL SALES DATA, AND IQVIA CLAIMS AND SALES DATA, AS WELL AS BUILDING SLOWLY CHANGING DIMENSIONS TYPE 02, FULL AND INCREMENTAL LOADING AND DATA WITHDRAWAL INFRASTRUCTURE; UTILIZING AWS CLOUD TECHNOLOGY, EC2, S3, LAMBDA LAYERS, RDS, DYNAMODB AND REDSHIFT FOR DATA BACKUP, DATA PARTITIONING, DATA RESTORE, DATA TIME TRAVELING AND DATABRICKS COST SAVING, AS WELL AS UTILIZING AWS CLOUDWATCH TO TRACK AWS RESOURCE USAGE; PERFORMING DEVOPS PROCESS FOR CONTINUOUS INTEGRATION AND CONTINUOUS DELIVERY CICD UTILIZING GITLAB, JIRA, AND AIRFLOW; AND TROUBLESHOOTING, DEBUGGING, OPTIMIZING CODE IN DATABRICKS NOTEBOOK, AND MANAGING GIT REPOSITORIES ON GITLAB, LAUNCHING EC2 INSTANCE, ORCHESTRATION AND DAG DESIGN IN APACHE AIRFLOW.br ORbr BACHELORS DEGREE IN DATA ANALYTICS ENGINEERING OR A RELATED FIELD, AND 5 YEARS OF PROGRESSIVE EXPERIENCE IN THE FOLLOWING UTILIZING AWS S3 LIFECYCLE POLICY, S3 STORAGE CLASSES, S3 CROSSREGION REPLICATION, REDSHIFT DISTRIBUTION KEY AND SORT KEY, DATABRICKS DATA LAKE, DELTA LAKE DISASTER RECOVERY, SPARKS LOGICAL AND PHYSICAL PLAN, DYNAMIC CLUSTER SETTINGS TO DESIGN DATA PIPELINE; PROCESSING AND MANAGING LARGE DATA SETS UTILIZING APACHE SPARK, SCALA OR PYSPARK; DESIGNING TRANSACTIONAL AND DATA WAREHOUSE DATA MODELS FOR MASTER DATA MANAGEMENT, MULTICHANNEL MARKETING DATA, GLOBAL AND REGIONAL SALES DATA, AND IQVIA CLAIMS AND SALES DATA, AS WELL AS BUILDING SLOWLY CHANGING DIMENSIONS TYPE 02, FULL AND INCREMENTAL LOADING AND DATA WITHDRAWAL INFRASTRUCTURE; UTILIZING AWS CLOUD TECHNOLOGY, EC2, S3, LAMBDA LAYERS, RDS, DYNAMODB AND REDSHIFT FOR DATA BACKUP, DATA PARTITIONING, DATA RESTORE, DATA TIME TRAVELING AND DATABRICKS COST SAVING, AS WELL AS UTILIZING AWS CLOUDWATCH TO TRACK AWS RESOURCE USAGE; PERFORMING DEVOPS PROCESS FOR CONTINUOUS INTEGRATION AND CONTINUOUS DELIVERY CICD UTILIZING GITLAB, JIRA, AND AIRFLOW; AND TROUBLESHOOTING, DEBUGGING, OPTIMIZING CODE IN DATABRICKS NOTEBOOK, AND MANAGING GIT REPOSITORIES ON GITLAB, LAUNCHING EC2 INSTANCE, ORCHESTRATION AND DAG DESIGN IN APACHE AIRFLOW.br br Any suitable combination of experience of education, training, or experience is acceptable.

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

SWA Job Order End Date

2021-05-20

Sunday Edition Newspaper

Y

First Newspaper Name

Tampa Bay Times

First Advertisement Start Date

2021-04-18

Second Newspaper Ad Name

Tampa Bay Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-04-25

Employer Website From Date

2022-01-01 10:27:43

Employer Website To Date

2022-01-01 10:27:43

Professional Organization Ad From Date

2021-04-16

Professional Organization Advertisement To Date

2021-04-23

Job Search Website From Date

2021-04-16

Job Search Website To Date

2021-04-23

Employee Referral Program From Date

2022-01-01 10:27:43

Employee Referral Program To Date

2022-01-01 10:27:43

Local Ethnic Paper From Date

2021-04-23

Local Ethnic Paper To Date

2021-04-23

Radio/TV Ad From Date

2022-01-01 10:27:43

Radio/TV Ad To Date

2022-01-01 10:27:43

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

F-1

Foreign Worker Education

Master's

Foreign Worker Information: Major

DATA ANALYTICS ENGINEERING

Foreign Worker Years of Education Completed

2019

Foreign Worker Institution of Education

NORTHEASTERN UNIVERSITY

Foreign Worker Education Institution Address 1

360 HUNTINGTON AVE.

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BOSTON

Foreign Worker Education Institution State/Province

MA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

2115

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Laura Bloniarz

Preparer Title

Senior Associate

Preparer Email

labloniarz@balglobal.com

Employer Information Declaration Name

Jen Cummings

Employer Information Declaration Title

HR Representative