Fiscal Year

2020

Case Number

A-20091-37076

Case Status

Certified

Received Date

2020-04-14

Decision Date

2020-09-03

Refile

N

Original File Date

2020-01-01 19:57:33

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Constellation, Inc.

Employer Name Slug

constellation-inc

Employer Address 1

7701 France Ave South Suite 500

Employer Address 2

Employer City

Edina

Employer City Slug

edina

Employer State

MINNESOTA

Employer State Slug

minnesota

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

55435

Employer Phone

9528386700

Employer Number of Employees

145

Employer Year Commenced Business

1988

NAICS Code

551112

FW Ownership Interest

N

Employer Contact Name

Taylor Wells

Employer Contact Address 1

7701 France Ave South Suite 500

Employer Contact Address 2

Employer Contact City

Edina

Employer Contact State/Province

MINNESOTA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

55435

Employer Contact Phone

9528386700

Employer Contact Email

Taylor.wells@constellationmutual.com

Agent Attorney Name

Debra Schneider

Agent Attorney Firm Name

Fredrikson Byron P.A.

Agent Attorney Phone

612-492-7214

Agent Attorney Address 1

200 South Sixth Street

Agent Attorney Address 2

Suite 4000

Agent Attorney City

Minneapolis

Agent Attorney State/Province

MINNESOTA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

55402

Agent Attorney Email

dschneider@fredlaw.com

PW Track Number

P10019205027418

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level II

PW Wage

81536.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-11-18

PW Expiration Date

2020-06-30

Wage Offer From

130000.00

Wage Offer To

0.00

Average Salary

130000.00

Wage Unit of Pay

Year

Worksite Address 1

7701 France Avenue South

Worksite Address 2

Suite 500

Worksite City

Edina

Worksite City Slug

edina

Worksite State

MINNESOTA

Worksite Postal Code

55435

Job Title

Systems Engineer- Oasis

Job Title Slug

systems-engineer-oasis

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Electronic or Electrical Engineering, Info. Tech.,or closely relate 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

36

Accept Alternative Job Title

Systems engineering experience with large data warehousing applications

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Complete requirements for the position are as followsbr Bachelors degree in Computer Science, Electronic or Electrical Engineering, Information Technology or a closelyrelated field, and 3 years of systems engineering experience with large data warehousing applications.br br Specific skills and requirements3 years of Oracle Database 11g, 12c Administration, WebLogic Application Server Administration; 3 years PLSQL, SQL, SQL Developer, Putty, Microsoft SQL Server 2005, 2008R2, 2012,2014,2016 Windows 3.x, 9x, ME, NT, 2000, XP, 2003, 7, 10,Cron, DBMSSCHEDULER, DBMSJOBS

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

SWA Job Order End Date

2020-02-06

Sunday Edition Newspaper

Y

First Newspaper Name

Star Tribune

First Advertisement Start Date

2020-01-05

Second Newspaper Ad Name

Star Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-01-12

Employer Website From Date

2020-01-02

Employer Website To Date

2020-03-30

Professional Organization Ad From Date

2020-01-01 19:57:33

Professional Organization Advertisement To Date

2020-01-01 19:57:33

Job Search Website From Date

2020-01-08

Job Search Website To Date

2020-01-14

Employee Referral Program From Date

2020-01-02

Employee Referral Program To Date

2020-01-10

Local Ethnic Paper From Date

2020-01-01 19:57:33

Local Ethnic Paper To Date

2020-01-01 19:57:33

Radio/TV Ad From Date

2020-01-01 19:57:33

Radio/TV Ad To Date

2020-01-01 19:57:33

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

ELECTRICAL AND ELECTRONIC ENGINEERING

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY

Foreign Worker Education Institution Address 2

KUKATPALLY

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

Debra Schneider

Preparer Title

Attorney

Preparer Email

dschneider@fredlaw.com

Employer Information Declaration Name

Taylor Wells

Employer Information Declaration Title

HR Business Partner