Fiscal Year

2022

Case Number

A-21251-41267

Case Status

Certified-Expired

Received Date

2021-09-30

Decision Date

2022-04-05

Refile

N

Original File Date

2022-01-01 11:13:07

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Kellogg Business Services Company

Employer Name Slug

kellogg-business-services-company

Employer Address 1

One Kellogg Square

Employer Address 2

Employer City

Battle Creek

Employer City Slug

battle-creek

Employer State

MICHIGAN

Employer State Slug

michigan

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

49017

Employer Phone

269-961-2000

Employer Number of Employees

31000

Employer Year Commenced Business

1906

NAICS Code

31123

FW Ownership Interest

N

Employer Contact Name

Nicole M Perry

Employer Contact Address 1

One Kellogg Square

Employer Contact Address 2

Employer Contact City

Battle Creek

Employer Contact State/Province

MICHIGAN

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

49017

Employer Contact Phone

269-961-3663

Employer Contact Email

nicole.perry@kellogg.com

Agent Attorney Name

Nina A Thekdi

Agent Attorney Firm Name

Varnum LLP

Agent Attorney Phone

248-567-7406

Agent Attorney Address 1

39500 High Pointe Blvd, Ste. 350

Agent Attorney Address 2

Agent Attorney City

Novi

Agent Attorney State/Province

MICHIGAN

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

48375

Agent Attorney Email

nathekdi@varnumlaw.com

PW Track Number

P10020329926797

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

117894.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-04-08

PW Expiration Date

2021-07-07

Wage Offer From

126061.00

Wage Offer To

0.00

Average Salary

126061.00

Wage Unit of Pay

Year

Worksite Address 1

800 Commerce Drive

Worksite Address 2

Worksite City

Oak Brook

Worksite City Slug

oak-brook

Worksite State

ILLINOIS

Worksite Postal Code

60523

Job Title

Lead IT Data Engineer

Job Title Slug

lead-it-data-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

Y

Required Experience Months

60

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Data Science 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

Please see H.14.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Minimum of 5 years of related data engineering experience including experience with the following requiredbr Largescale data and query optimization techniques;br ETL to data warehouse systems SAP BODS, SSIS;br AWS cloud services S3, EMR, Lambda, Glue, Redshift Athena, SQL, NoSQL, and RDBMS;br Data orchestration tools including Nifi, AWS Step functions;br Big Data technologies such as Hadoop, Hive, Spark, PySpark;br Multiple scripting languages such as Python;br Cloud, distributed systems, and streamprocessing systems;br Predictive analytics tools like SAS, R and Machine Learning;br SAP data as well as CPG related data

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-06-21

SWA Job Order End Date

2021-07-26

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago SunTimes

First Advertisement Start Date

2021-07-11

Second Newspaper Ad Name

Chicago SunTimes

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-18

Employer Website From Date

2021-06-21

Employer Website To Date

2021-08-25

Professional Organization Ad From Date

2022-01-01 11:13:07

Professional Organization Advertisement To Date

2022-01-01 11:13:07

Job Search Website From Date

2021-07-12

Job Search Website To Date

2021-07-26

Employee Referral Program From Date

2022-01-01 11:13:07

Employee Referral Program To Date

2022-01-01 11:13:07

Local Ethnic Paper From Date

2021-07-15

Local Ethnic Paper To Date

2021-07-15

Radio/TV Ad From Date

2022-01-01 11:13:07

Radio/TV Ad To Date

2022-01-01 11:13: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

COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2005

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY, KUKATPALLY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Nina A Thekdi

Preparer Title

Attorney

Preparer Email

nathekdi@varnumlaw.com

Employer Information Declaration Name

Nicole M Perry

Employer Information Declaration Title

Counsel