Fiscal Year

2020

Case Number

A-19247-53135

Case Status

Certified-Expired

Received Date

2019-10-10

Decision Date

2020-03-13

Refile

N

Original File Date

2020-01-01 07:55:57

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

NEOPOST USA INC.

Employer Name Slug

neopost-usa-inc

Employer Address 1

478 WHEELERS FARMS ROAD

Employer Address 2

Employer City

MILFORD

Employer City Slug

milford

Employer State

CONNECTICUT

Employer State Slug

connecticut

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

6461

Employer Phone

203-301-3470

Employer Number of Employees

1200

Employer Year Commenced Business

1976

NAICS Code

33429

FW Ownership Interest

N

Employer Contact Name

Sharon Scinto

Employer Contact Address 1

478 Wheelers Farms Road

Employer Contact Address 2

Employer Contact City

Milford

Employer Contact State/Province

CONNECTICUT

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

6461

Employer Contact Phone

203-301-3655

Employer Contact Email

s.scinto@neopost.com

Agent Attorney Name

Joshua S Mirer

Agent Attorney Firm Name

Robinson Cole LLP

Agent Attorney Phone

8602758344

Agent Attorney Address 1

280 Trumbull Street

Agent Attorney Address 2

28th Floor

Agent Attorney City

Hartford

Agent Attorney State/Province

CONNECTICUT

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

6103

Agent Attorney Email

jmirer@rc.com

PW Track Number

P10019165005143

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level I

PW Wage

55848.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-09-30

PW Expiration Date

2020-06-30

Wage Offer From

100000.00

Wage Offer To

120000.00

Average Salary

110000.00

Wage Unit of Pay

Year

Worksite Address 1

478 Wheelers Farms Road

Worksite Address 2

Worksite City

Milford

Worksite City Slug

milford

Worksite State

CONNECTICUT

Worksite Postal Code

6461

Job Title

Data Warehouse Developer

Job Title Slug

data-warehouse-developer

Minimum Education

Other

Major Field of Study

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Information Systems or a 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

Prior work experience in Data Warehousing in a Business Intelligence Environment.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must possess the following at least 5 years of experience in Data modeling Dimensional Relational using Informatica PowerCenter; at least 5 years of experience with Oracle SQLPLSQL experience or related technology; at least 5 years of experience with performance tuning, optimization and reconciliation of ETLSQL for data warehousing and OLTP applications; at least 3 years of experience writing complex SQL queries, PLSQL programs, Batch scripts and Shell scripts; and at least 1 year of experience with Big dataHadoop technologies and platforms.

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

2019-06-12

SWA Job Order End Date

2019-07-29

Sunday Edition Newspaper

Y

First Newspaper Name

The Connecticut Post

First Advertisement Start Date

2019-07-21

Second Newspaper Ad Name

The Connecticut Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-07-28

Employer Website From Date

2019-07-17

Employer Website To Date

2019-08-05

Professional Organization Ad From Date

2020-01-01 07:55:57

Professional Organization Advertisement To Date

2020-01-01 07:55:57

Job Search Website From Date

2019-08-01

Job Search Website To Date

2019-08-31

Employee Referral Program From Date

2020-01-01 07:55:57

Employee Referral Program To Date

2020-01-01 07:55:57

Local Ethnic Paper From Date

2019-07-28

Local Ethnic Paper To Date

2019-07-28

Radio/TV Ad From Date

2020-01-01 07:55:57

Radio/TV Ad To Date

2020-01-01 07:55:57

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

Other

Foreign Worker Information: Major

COMPUTER INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2019

Foreign Worker Institution of Education

THE TRUSTFORTE CORPORATION

Foreign Worker Education Institution Address 1

271 MADISON AVENUE

Foreign Worker Education Institution Address 2

THIRD FLOOR

Foreign Worker Education Institution City

NEW YORK

Foreign Worker Education Institution State/Province

NY

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

10016

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Joshua S Mirer

Preparer Title

Attorney

Preparer Email

jmirer@rc.com

Employer Information Declaration Name

Sharon Scinto

Employer Information Declaration Title

HR Associate Recruiter