Fiscal Year

2021

Case Number

A-20090-37026

Case Status

Certified-Expired

Received Date

2020-04-28

Decision Date

2020-10-01

Refile

N

Original File Date

2021-01-01 08:44:13

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MEDLINE INDUSTRIES

Employer Name Slug

medline-industries

Employer Address 1

THREE LAKES DRIVE

Employer Address 2

Employer City

NORTHFIELD

Employer City Slug

northfield

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60093

Employer Phone

847-643-4309

Employer Number of Employees

24000

Employer Year Commenced Business

1966

NAICS Code

33911

FW Ownership Interest

N

Employer Contact Name

Karrie DeBlauw

Employer Contact Address 1

Three Lakes Drive

Employer Contact Address 2

Employer Contact City

Northfield

Employer Contact State/Province

ILLINOIS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

60093

Employer Contact Phone

847-643-4875

Employer Contact Email

immigration@medline.com

Agent Attorney Name

Danielle H Gotcher

Agent Attorney Firm Name

Global Immigration Partners, Inc.

Agent Attorney Phone

8189146482

Agent Attorney Address 1

30300 Agoura Road

Agent Attorney Address 2

Suite B-100

Agent Attorney City

Agoura Hills

Agent Attorney State/Province

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

91301

Agent Attorney Email

perm@gotcherlaw.com

PW Track Number

P10019261059503

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level III

PW Wage

97781.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-01-22

PW Expiration Date

2020-06-30

Wage Offer From

113630.00

Wage Offer To

0.00

Average Salary

113630.00

Wage Unit of Pay

Year

Worksite Address 1

1160 S. Northpoint Blvd.

Worksite Address 2

Worksite City

Waukegan

Worksite City Slug

waukegan

Worksite State

ILLINOIS

Worksite Postal Code

60085

Job Title

Business Intelligence Talend/SQL Developer/Analyst

Job Title Slug

business-intelligence-talendsql-developeranalyst

Minimum Education

Master's

Major Field of Study

See H-14.

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

See H14.

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

36

Accept Alternative Job Title

See H14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Masters degree in Computer Science, Computer Applications, Electronics or Electrical Engineering, or any related Engineering or IT field of study, plus at least three 3 years of experience in the job offered or in any related positions involving Business Intelligence, Data Warehousing andor ETL Development.br br In lieu of the abovestated primary education and experience requirements, the company will accept a Bachelors degree in Computer Science, Computer Applications, Electronics or Electrical Engineering, or any related Engineering or IT field of study, plus at least five 5 years of postdegree, progressively responsible experience in any related positions involving business intelligence, data warehousing andor ETL development.br br Qualified applicants must also have demonstrable proficiency, knowledge, skill and experience with the followingbr br 1. Write SQL queries for data validation.br 2. Develop plSQL and Talend codes for mapping requirements.br 3. Validation and verification testing.br 4. Data extraction, data mapping and data loading.br br This position is based in our Waukegan, IL office but individual will be required to travel locally to work from our headquarters office in Northfield, IL one day each week.br br No other travel required; no telecommuting.

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

SWA Job Order End Date

2020-03-11

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Sun Times

First Advertisement Start Date

2020-02-02

Second Newspaper Ad Name

Chicago Sun Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-02-09

Employer Website From Date

2021-01-01 08:44:13

Employer Website To Date

2021-01-01 08:44:13

Professional Organization Ad From Date

2021-01-01 08:44:13

Professional Organization Advertisement To Date

2021-01-01 08:44:13

Job Search Website From Date

2020-02-04

Job Search Website To Date

2020-02-18

Employee Referral Program From Date

2020-02-17

Employee Referral Program To Date

2020-03-02

Local Ethnic Paper From Date

2021-01-01 08:44:13

Local Ethnic Paper To Date

2021-01-01 08:44:13

Radio/TV Ad From Date

2020-02-11

Radio/TV Ad To Date

2020-02-11

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

Master's

Foreign Worker Information: Major

ELECTRICAL ENGINEERING

Foreign Worker Years of Education Completed

2012

Foreign Worker Institution of Education

NORTHWESTERN POLYTECHNIC UNIVERSITY

Foreign Worker Education Institution Address 1

47671 WESTINGHOUSE DRIVE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FREMONT

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

94539

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Danielle H Gotcher

Preparer Title

Attorney

Preparer Email

perm@gotcherlaw.com

Employer Information Declaration Name

Karrie DeBlauw

Employer Information Declaration Title

Global Mobility Manager