All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-19318-83154

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-19318-83154

Case Status

Certified

Received Date

2019-12-05

Decision Date

2020-04-27

Refile

N

Original File Date

2020-01-01 08:17:29

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CELGENE CORPORATION

Employer Name Slug

celgene-corporation

Employer Address 1

86 MORRIS AVENUE

Employer Address 2

Employer City

SUMMIT

Employer City Slug

summit

Employer State

NEW JERSEY

Employer State Slug

new-jersey

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

7901

Employer Phone

9086732009

Employer Number of Employees

3700

Employer Year Commenced Business

1986

NAICS Code

32541

FW Ownership Interest

N

Employer Contact Name

Barbara Colvin

Employer Contact Address 1

86 MORRIS AVENUE

Employer Contact Address 2

Employer Contact City

SUMMIT

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

7901

Employer Contact Phone

908-673-2009

Employer Contact Email

bcolvin@celgene.com

Agent Attorney Name

Lauren E Randle

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

7133605573

Agent Attorney Address 1

3355 West Alabama Street

Agent Attorney Address 2

STE. 1050

Agent Attorney City

Houston

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

77098

Agent Attorney Email

lrandle@balglobal.com

PW Track Number

P10019108924825

PW SOC Code

11-3021

PW SOC Title

Computer and Information Systems Managers

PW Skill Level

Level II

PW Wage

160326.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-08-05

PW Expiration Date

2020-06-30

Wage Offer From

166400.00

Wage Offer To

0.00

Average Salary

166400.00

Wage Unit of Pay

Year

Worksite Address 1

556 Morris Avenue

Worksite Address 2

Worksite City

Summit

Worksite City Slug

summit

Worksite State

NEW JERSEY

Worksite Postal Code

7901

Job Title

Associate Director, Data Engineer Lead

Job Title Slug

associate-director-data-engineer-lead

Minimum Education

Bachelor's

Major Field of Study

COMPUTER SCIENCE, SYSTEM ANALYSIS, ENGINEERING OR RELATED FIELD

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

COMPUTER SCIENCE, SYSTEM ANALYSIS, ENGINEERING OR 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

See H.14.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Requirementsbr BACHELORS OR FOREIGN EQUIVALENT DEGREE IN COMPUTER SCIENCE, SYSTEMbr ANALYSIS, ENGINEERING OR RELATED FIELD PLUS 3 YEARS OF WORK EXPERIENCE INbr THE FOLLOWINGbr 1 DATA INTEGRATION, ETL ANDOR DATA ENGINEERING;br 2 BIG DATA TOOLS AND TECHNIQUES;br 3 TALEND USED IN CONJUNCTION OF HADOOP MAPREDUCESPARKHIVE;br 4 VARIOUS DATA MODELING TYPES CONCEPTUAL, LOGICAL, RELATIONAL,br DIMENSIONAL, CANONICAL MESSAGING, XML, JSON, DOCUMENTbr ESPECIALLY WITH NOSQL DATABASES AND EXPERIENCE WITH DATAbr MODELING TOOLS;br 5 CREATING DATA FLOW DOCUMENTATION AND BUSINESS PROCESSbr MODELING;br 6 LEVERAGING A BIG DATA CAPABILITY AND UNDERSTANDING THE SCHEMAONREAD APPROACH AND IMPLICATIONS;br 7 BUILDING DATA PIPELINES AND IMPLEMENTING COMPLEX DATAbr PROCESSING USING TALEND IN CONJUNCTION WITH THE BIG DATAbr PLATFORM;br 8 PROGRAMMING LANGUAGES SUCH AS SQL, PYTHON, SCALA, JAVA, R,br UNIX SHELL SCRIPTS FREQUENTLY USED TO BUILD WORKLOADS ON HADOOPbr PLATFORMS;br 9 AGILE AND ITERATIVE DATA MODELING WITH ABILITY TO INCORPORATEbr PROVEN DATA MODELING PATTERNS THAT PROVIDE FLEXIBILITY;br 10 DATA QUALITY PROFILINGMANAGEMENT TOOLS E.G. INFORMATICA IDQ,br TALEND DATA QUALITY;br 11 WORKING WITH REPORTING VISUALIZATION TOOLS LIKE TABLEAU, QLIK ETC.

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

SWA Job Order End Date

2019-10-11

Sunday Edition Newspaper

Y

First Newspaper Name

THE STAR LEDGER

First Advertisement Start Date

2019-09-15

Second Newspaper Ad Name

THE STAR LEDGER

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-09-22

Employer Website From Date

2020-01-01 08:17:29

Employer Website To Date

2020-01-01 08:17:29

Professional Organization Ad From Date

2020-01-01 08:17:29

Professional Organization Advertisement To Date

2020-01-01 08:17:29

Job Search Website From Date

2019-09-11

Job Search Website To Date

2019-09-19

Employee Referral Program From Date

2020-01-01 08:17:29

Employee Referral Program To Date

2020-01-01 08:17:29

Local Ethnic Paper From Date

2019-09-19

Local Ethnic Paper To Date

2019-09-19

Radio/TV Ad From Date

2019-09-17

Radio/TV Ad To Date

2019-09-17

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

ELECTRONIC ENGINEERING

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

SRKR ENGINEERING COLLEGE , ANDHRA UNIVERSITY

Foreign Worker Education Institution Address 1

CHINNAMIRAM

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BHIMAVARAM

Foreign Worker Education Institution State/Province

ANDHRA PRADESH

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

534204

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Lauren E Randle

Preparer Title

Associate Attorney

Preparer Email

lrandle@balglobal.com

Employer Information Declaration Name

Barbara Colvin

Employer Information Declaration Title

Manager, Global Mobility