Fiscal Year

2024

Case Number

A-23072-12375

Case Status

Certified

Received Date

2023-05-08

Decision Date

2024-06-11

Refile

N

Original File Date

2024-01-01 01:37:23

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

THERMO FISHER SCIENTIFIC

Employer Name Slug

thermo-fisher-scientific

Employer Address 1

168 THIRD AVENUE

Employer Address 2

Employer City

WALTHAM

Employer City Slug

waltham

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

2451

Employer Phone

760 918 3874

Employer Number of Employees

100000

Employer Year Commenced Business

1960

NAICS Code

54171

FW Ownership Interest

N

Employer Contact Name

Donna Gaulard

Employer Contact Address 1

5823 Newton Drive

Employer Contact Address 2

Employer Contact City

Carlsbad

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

92008

Employer Contact Phone

760 918 3874

Employer Contact Email

donna.gaulard@thermofisher.com

Agent Attorney Name

Fauzia N Amlani

Agent Attorney Firm Name

Ogletree, Deakins, Nash, Smoak Stewart, P.C.

Agent Attorney Phone

4049460852

Agent Attorney Address 1

One Ninety One Peachtree Tower

Agent Attorney Address 2

191 Peachtree Street, N.E., Suite 4800

Agent Attorney City

Atlanta

Agent Attorney State/Province

GEORGIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

30303

Agent Attorney Email

fauzia.amlani@ogletree.com

PW Track Number

P10022024847971

PW SOC Code

15-1243.00

PW SOC Title

Database Architects

PW Skill Level

Level IV

PW Wage

126402.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-07-23

PW Expiration Date

2023-06-30

Wage Offer From

128276.00

Wage Offer To

137800.00

Average Salary

133038.00

Wage Unit of Pay

Year

Worksite Address 1

300 Industry Drive

Worksite Address 2

Worksite City

Pittsburgh

Worksite City Slug

pittsburgh

Worksite State

PENNSYLVANIA

Worksite Postal Code

15275

Job Title

Sr. Data Engineer

Job Title Slug

sr-data-engineer

Minimum Education

Bachelor's

Major Field of Study

Information Technology, Computer Science, or related field of study

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

72

Accept Alternative Job Title

data integration and pipeline development, or related experience

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Requirements Bachelors Degree in Information Technology, Computer Science, or related field of study plus 6 years of professional experience in data integration and pipeline development, or related experience.br Required knowledge or experience withbr Databricks, DataDelta lake, Oracle, SQL Server or AWS Redshift type relational databases;br ETL Data extraction, data transformation and data load processes;br Athena;br AWS Cloud on data integration with Apache Spark, Glue, Kafka, Elastic Search, Lambda, S3, Redshift, RDS, and MongoDBDynamoDB ecosystems;br Python development including in pySpark in AWS Cloud environment;br Python and common python libraries;br Analytical experience with database in writing complex queries, query optimization, debugging, user defined functions, views, and indexes;br Source control systems such as Git and Jenkins build and continuous integration tools;br Development methodology and experience writing functional and technical design specifications;br Technical, development background in either data Services or Engineering;br Resolving complex data integration problems; andbr Working crossfunctionally.br br Employer will accept any suitable combination of education, training, or experience.

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

2022-11-14

SWA Job Order End Date

2022-12-29

Sunday Edition Newspaper

Y

First Newspaper Name

Pittsburgh PostGazette

First Advertisement Start Date

2022-12-04

Second Newspaper Ad Name

Pittsburgh PostGazette

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-12-11

Employer Website From Date

2022-11-10

Employer Website To Date

2023-01-27

Professional Organization Ad From Date

2024-01-01 01:37:23

Professional Organization Advertisement To Date

2024-01-01 01:37:23

Job Search Website From Date

2023-01-04

Job Search Website To Date

2023-01-17

Employee Referral Program From Date

2024-01-01 01:37:23

Employee Referral Program To Date

2024-01-01 01:37:23

Local Ethnic Paper From Date

2024-01-01 01:37:23

Local Ethnic Paper To Date

2024-01-01 01:37:23

Radio/TV Ad From Date

2022-12-07

Radio/TV Ad To Date

2022-12-07

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 TECHNOLOGY

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

ANDHRA UNIVERSITY

Foreign Worker Education Institution Address 1

ANDHRA UNIVERSITY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

VISAKHAPATNAM

Foreign Worker Education Institution State/Province

AP

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

530003

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Fauzia Amlani

Preparer Title

Attorney

Preparer Email

fauzia.amlani@ogletree.com

Employer Information Declaration Name

Donna Gaulard

Employer Information Declaration Title

HR Compliance Specialist