All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
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