Fiscal Year

2022

Case Number

A-21340-82041

Case Status

Withdrawn

Received Date

2021-12-15

Decision Date

2022-01-19

Refile

N

Original File Date

2022-01-01 10:47:26

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

KRONOS INCORPORATE

Employer Name Slug

kronos-incorporate

Employer Address 1

900 CHELMSFORD STREET

Employer Address 2

Employer City

LOWELL

Employer City Slug

lowell

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

1851

Employer Phone

978-250-9800

Employer Number of Employees

4217

Employer Year Commenced Business

1977

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Samantha Hamel

Employer Contact Address 1

900 Chelmsford Street

Employer Contact Address 2

Employer Contact City

Lowell

Employer Contact State/Province

MASSACHUSETTS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

1851

Employer Contact Phone

978-947-5160

Employer Contact Email

Samantha.Hamel@Kronos.com

Agent Attorney Name

Donald W Parker

Agent Attorney Firm Name

Parker Gallini LLP

Agent Attorney Phone

7818108990

Agent Attorney Address 1

460 Totten Pond Road

Agent Attorney Address 2

Suite 350

Agent Attorney City

Waltham

Agent Attorney State/Province

MASSACHUSETTS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

2451

Agent Attorney Email

dparker@parkergallini.com

PW Track Number

P10021012009402

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

108597.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-06-29

PW Expiration Date

2021-09-27

Wage Offer From

135950.00

Wage Offer To

0.00

Average Salary

135950.00

Wage Unit of Pay

Year

Worksite Address 1

900 Chelmsford Street

Worksite Address 2

Worksite City

Lowell

Worksite City Slug

lowell

Worksite State

MASSACHUSETTS

Worksite Postal Code

1851

Job Title

Business Intelligence Data Warehouse Analyst

Job Title Slug

business-intelligence-data-warehouse-analyst

Minimum Education

Bachelor's

Major Field of Study

Information Technology, Computer Science or a closely related field

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

96

Accept Alternative Job Title

Data Warehouse Analyst

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

This position requires a Bachelors degree or an equivalent foreign degree in Information Technology, Computer Science or a closely related field and 8 years of experience as a Data Warehouse Analyst. Must also have 5 years of experience which can have been gained concurrently with the primary experience requirement above with the followingbr br Designing and developing enterprise Data Warehouses to meet business vision and helping the business stakeholder meet their business goal.br Driving the modernization of the architecture and design of the data and analytics systems, including Data Warehouse, Application integrations and Master Data ManagementMDM solutionsbr Working with Informatica Cloud with multiple Database systems SQL Server and Oracle, Files Parquet, Avro, CSV, XML, and JSON and various Cloud applications.br Building loosely coupled Application Integration using iPaaS tools IICS, including integration to Salesforce, ServiceNow, REVPRO and OpenAir specifically using their RESTSOAP APIs.br Developing complex SQL, UNIX, and PYTHON scripts and PLSQL packages and procedures.br Working with consulting firms and offshore resources and serving as a Team lead for 3 or more developers.br Working with Cloud technologies Azure, AWS or GCP

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-09-22

SWA Job Order End Date

2021-10-26

Sunday Edition Newspaper

Y

First Newspaper Name

Boston Globe

First Advertisement Start Date

2021-10-03

Second Newspaper Ad Name

Boston Globe

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-10-10

Employer Website From Date

2021-09-23

Employer Website To Date

2021-10-15

Professional Organization Ad From Date

2022-01-01 10:47:26

Professional Organization Advertisement To Date

2022-01-01 10:47:26

Job Search Website From Date

2021-09-23

Job Search Website To Date

2021-09-30

Employee Referral Program From Date

2022-01-01 10:47:26

Employee Referral Program To Date

2022-01-01 10:47:26

Local Ethnic Paper From Date

2021-09-28

Local Ethnic Paper To Date

2021-09-30

Radio/TV Ad From Date

2022-01-01 10:47:26

Radio/TV Ad To Date

2022-01-01 10:47:26

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

2006

Foreign Worker Institution of Education

ANNA UNIVERSITY

Foreign Worker Education Institution Address 1

12, SARDAR PATEL RD

Foreign Worker Education Institution Address 2

ANNA UNIVERSITY, GUINDY

Foreign Worker Education Institution City

CHENNAI

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

600025

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Donald W Parker

Preparer Title

Attorney

Preparer Email

dparker@parkergallini.com

Employer Information Declaration Name

Samantha Hamel

Employer Information Declaration Title

Associate Manager, Talent Acquisition Operations