All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22363-80523
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22363-80523
Case Status
Certified-Expired
Received Date
2023-01-23
Decision Date
2024-02-27
Refile
N
Original File Date
2024-01-01 00:48:33
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
THE DEVEREUX FOUNDATION
Employer Name Slug
the-devereux-foundation
Employer Address 1
444 DEVEREUX DRIVE
Employer Address 2
Employer City
VILLANOVA
Employer City Slug
villanova
Employer State
PENNSYLVANIA
Employer State Slug
pennsylvania
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
19085
Employer Phone
6105423000
Employer Number of Employees
7106
Employer Year Commenced Business
1912
NAICS Code
62431
FW Ownership Interest
N
Employer Contact Name
Robert Simon
Employer Contact Address 1
444 Devereux Drive
Employer Contact Address 2
Employer Contact City
Villanova
Employer Contact State/Province
PENNSYLVANIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
19085
Employer Contact Phone
610-542-3193
Employer Contact Email
rsimon@devereux.org
Agent Attorney Name
John F LEsperance
Agent Attorney Firm Name
Duane Morris LLP
Agent Attorney Phone
5619622114
Agent Attorney Address 1
1875 NW Corporate Boulevard
Agent Attorney Address 2
Ste 300
Agent Attorney City
Boca Raton
Agent Attorney State/Province
FLORIDA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
33431
Agent Attorney Email
jlesperance@duanemorris.com
PW Track Number
P10021238546776
PW SOC Code
15-1199
PW SOC Title
Data Warehousing Specialists
PW Skill Level
Level II
PW Wage
77418.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-05-09
PW Expiration Date
2022-08-07
Wage Offer From
77418.00
Wage Offer To
0.00
Average Salary
77418.00
Wage Unit of Pay
Year
Worksite Address 1
444 Devereux Drive
Worksite Address 2
May require to traveltelecommute.
Worksite City
Villanova
Worksite City Slug
villanova
Worksite State
PENNSYLVANIA
Worksite Postal Code
19085
Job Title
Data Integration Specialist
Job Title Slug
data-integration-specialist
Minimum Education
Master's
Major Field of Study
Computer Science, Information Systems Technology – Information Assurance, or related technical field
Required Training
N
Required Experience
Y
Required Experience Months
6
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Computer Science, Information Systems Technology Information Assurance, or related technical 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
6
Accept Alternative Job Title
Data Integration Specialist
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Masters degree in Computer Science, Information Systems Technology Information Assurance, or related technical field plus 6 months experience in job offered, SQL BI Developer, or computer related occupation. Experience must include 1 MS BI Stack, Data warehousing, SQL Server, Teradata, PostgreSQL using SQL programming, 2 Creating, Configuring, Finetuning ETL workflows designed in DTS and MS SQL SSIS, 3 Developingmaintaining SSIS packages, SQL jobs and SSRS reports, 4 Developing and automating process retrieving data for data loads through SSIS from different sources, 5 Creatingmaintaining databases and schema objects including tables, indexes, stored procedures and functions, 6 Creating ETL packages to validate, extract, transform and load data into enterprise data warehouse, and 7 Writing SQL queries to create Stored Procedures, triggers, function, tables, and other SQL joins and statements for applications.
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
2022-10-16
SWA Job Order End Date
2022-12-17
Sunday Edition Newspaper
Y
First Newspaper Name
THE PHILADELPHIA INQUIRER
First Advertisement Start Date
2022-11-27
Second Newspaper Ad Name
THE PHILADELPHIA INQUIRER
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-12-04
Employer Website From Date
2024-01-01 00:48:33
Employer Website To Date
2024-01-01 00:48:33
Professional Organization Ad From Date
2024-01-01 00:48:33
Professional Organization Advertisement To Date
2024-01-01 00:48:33
Job Search Website From Date
2022-08-01
Job Search Website To Date
2022-10-16
Employee Referral Program From Date
2024-01-01 00:48:33
Employee Referral Program To Date
2024-01-01 00:48:33
Local Ethnic Paper From Date
2022-11-28
Local Ethnic Paper To Date
2022-11-28
Radio/TV Ad From Date
2022-11-28
Radio/TV Ad To Date
2022-11-28
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
INFORMATION SYSTEMS TECHNOLOGIES INFORMATION ASSURANCE
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
WILMINGTON UNIVERSITY
Foreign Worker Education Institution Address 1
320 N DUPONT HWY
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
NEW CASTLE
Foreign Worker Education Institution State/Province
DE
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
19720
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
JOHN F LESPERANCE
Preparer Title
PARTNER
Preparer Email
JLESPERANCE@DUANEMORRIS.COM
Employer Information Declaration Name
ROBERT SIMON
Employer Information Declaration Title
People Operations DirectorCorporate