Fiscal Year

2021

Case Number

A-20230-88977

Case Status

Certified-Expired

Received Date

2020-08-25

Decision Date

2021-03-31

Refile

N

Original File Date

2021-01-01 09:10:03

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

INSURANCE SERVICES OFFICE, INC

Employer Name Slug

insurance-services-office-inc

Employer Address 1

545 WASHINGTON BLVD

Employer Address 2

Employer City

JERSEY CITY

Employer City Slug

jersey-city

Employer State

NEW JERSEY

Employer State Slug

new-jersey

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

7310

Employer Phone

201-469-2523

Employer Number of Employees

2230

Employer Year Commenced Business

1971

NAICS Code

541611

FW Ownership Interest

N

Employer Contact Name

Maybelle Francisco

Employer Contact Address 1

545 Washington Blvd

Employer Contact Address 2

Employer Contact City

Jersey City

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

7310

Employer Contact Phone

201-469-2523

Employer Contact Email

maybelle.francisco@verisk.com

Agent Attorney Name

Christopher J Preston

Agent Attorney Firm Name

Global Immigration Associates, P.C.

Agent Attorney Phone

3127226300

Agent Attorney Address 1

230 W. Monroe St.

Agent Attorney Address 2

Ste 2800

Agent Attorney City

Chicago

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60606

Agent Attorney Email

chris.preston@giafirm.com

PW Track Number

P10019269064199

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level II

PW Wage

86528.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-01-29

PW Expiration Date

2020-06-30

Wage Offer From

123850.00

Wage Offer To

0.00

Average Salary

123850.00

Wage Unit of Pay

Year

Worksite Address 1

545 Washington Blvd

Worksite Address 2

Worksite City

Jersey City

Worksite City Slug

jersey-city

Worksite State

NEW JERSEY

Worksite Postal Code

7310

Job Title

Database Engineer II

Job Title Slug

database-engineer-ii

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

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

36

Accept Alternative Job Title

Related occupations

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Requires at least a Bachelors degree in Computer Science or a related field plus 3 years of experience. Requires At least 2 years of experience in the following skills Configuring, managing, and troubleshooting Aurora PostgreSQL Postgres and AWS RDS; Experience with ETL tools such as Attunity, AWS Glue or ETL programming required experience writing TSQL; Hands on experience working with various AWS services such as S3, CFTs, API Gateway, Lambda functions, IAM, Amazon ECS.; experience with application performance monitoring tools including, New Relic, Splunk log monitoring, Dynatrace, Solarwinds, Cloud Watch, Cloud Trail; experience designing and implementing data security solutions such as Data Encryption, Data Masking, Key Management; Software development experience in AGILE SDLC Scrum environment which includes participating in standups, refinements, sprint reviews, retrospectives. Also requires at least 3 years of experience in the following Database backup and recovery, including implementing disaster recovery standards; Production experience with performance tuning queries and stored procedures; Experience in MS SQL 20122016 database management, modeling, architecting systems with data analytics needs.

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-03-11

SWA Job Order End Date

2020-04-12

Sunday Edition Newspaper

Y

First Newspaper Name

The StarLedger

First Advertisement Start Date

2020-06-07

Second Newspaper Ad Name

The Star Ledger

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-06-14

Employer Website From Date

2021-01-01 09:10:03

Employer Website To Date

2021-01-01 09:10:03

Professional Organization Ad From Date

2021-01-01 09:10:03

Professional Organization Advertisement To Date

2021-01-01 09:10:03

Job Search Website From Date

2020-03-11

Job Search Website To Date

2020-03-27

Employee Referral Program From Date

2021-01-01 09:10:03

Employee Referral Program To Date

2021-01-01 09:10:03

Local Ethnic Paper From Date

2020-06-08

Local Ethnic Paper To Date

2020-06-08

Radio/TV Ad From Date

2021-01-01 09:10:03

Radio/TV Ad To Date

2021-01-01 09:10:03

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

2015

Foreign Worker Institution of Education

TEXAS AM UNIVERSITY KINGSVILLE

Foreign Worker Education Institution Address 1

700 UNIVERSITY BLVD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

KINGSVILLE

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

78363

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Christopher J Preston

Preparer Title

Managing Attorney

Preparer Email

chris.preston@giafirm.com

Employer Information Declaration Name

Maybelle Francisco

Employer Information Declaration Title

Immigration Specialist