VISITING NURSE SERVICE OF NEW YORK
Data Integration Developer
A-22208-95853
H-1B
2023
Certified
Salary
$45,282
Visa Type
H-1B
Job Title
Data Integration Developer
Employee's Citizenship
INDIA
Graduate School
PANJAB UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22208-95853
Case Status
Certified
Received Date
2022-08-10
Decision Date
2023-07-19
Refile
N
Original File Date
-
Previous State Work Force Agency (SWA) Case Number Stete
-
Schedule A or a Sheepherder Occupation
N
Company Info
14 fields
Employer Name
VISITING NURSE SERVICE OF NEW YORK
Employer Address_Line 1
107 EAST 70TH STREET
Employer Address_Line 2
-
Employer City
NEW YORK
State
-
Employer State/ Province
NEW YORK
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
10021
Employer Phone No.
212-609-1588
Employer Phone Extent No.
-
Total Number of Employees
768
Employer Year of Commenced
1893
NAICS Code
621610
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Jennifer F Whetsell
Employer Contact Address Line1
220 East 42nd Street
Employer Contact Address Line2
6th floor
Employer Contact City
New York
Employer Contact State/ Provice
NEW YORK
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
10017
Employer Contact Phone
212-609-7903
Employer Contact Email
jennifer.whetsell@vnsny.org
Attorney
11 fields
Agent/ Attorney Name
Karin Wolman
Agent/ Attorney Firm Name
Law Office of Karin Wolman, PLLC
Agent/ Attorney Phone
2129184940
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
Law Office of Karin Wolman PLLC
Agent/ Attorney Address Line 2
48 Wall Street, Floor 11
Agent/ Attorney City
New York
Agent/ Attorney State/ Province
NEW YORK
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
100052887
Agent/ Attorney Email
karin@kwvisalaw.com
Position Info
89 fields
Prevailing Wage Track Number
P10021256579012
Prevailing Wage SOC Code
15-1243.01
Prevailing Wage SOC Title
Data Integration Developer
Prevailing Wage Skill Level
Level II
Prevailing Wage
45282
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-04-25
Prevailing Wage Expiration Date
2022-07-24
Wage Offer From
120981
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
220 East 42nd Street, 6th Floor
Worksite Address Line 2
-
Worksite City
New York
Worksite State
NEW YORK
Worksite Postal Code
10017
Job Title
Data Integration Developer
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
Computer Science, MIS, or related
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
Y
Required Expreience Months
60
Accept Alternate Field of Study
N
Accept Alternate Major
-
Alternate Combination of Education/ Experience
Y
Required Alternate Level of Education
Master's
Other Alternate Level of Education
-
Acceptable Years of Experience
2
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
60
Accept Alternate Job Title
Database Developer; Systems Engineer, Data Warehouse
Normal Requirements of Job Opportunity
Y
Required Foreign Language
N
Specific Skills
BS 5yrs or MS 2yrs experience on data integration projects, building ETL frameworks for data warehouse using Informatica 10.x; performance tuning ETL code underlying databases; developing PLSQL functions pkgs for opensouce commercial database platforms; use of RESTful Web Svc, UnixLinux shell Python scripting; advanced scheduling tools eg, ControlM, Autosys, Tivoli; conducting logical, conceptual physical data modeling for data warehouse projects; use of cloudbased data integration tools eg, Snowflake, RDS, S3, Lamda, EC2 data visualization tools eg OBIEE, MicroStrategy, or Tableau.
Combination Occupation
N
Offered to Applied Foreign Worker
Y
ForeignWorker Live on Premises
N
Live in Domestic Service Worker
N
Employment Contract
-
Professional Occupation
Y
College/ University Teacher
N
Competitive Process
-
Basic Recruitment Process
-
Teacher Select Date
-
Teacher Publish Journal Name
-
Additional Recruitment Information
-
Job Oder Start Date
2022-06-07
Job Oder End Date
2022-07-08
Sunday Edition Newspaper
Y
First Newspaper Name
The New York Times
First Advertisement Start Date
2022-06-19
Second Newspaper Name
The New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-06-26
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
2022-06-06
Employer Website to Date
2022-07-08
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-06-19
Job Search Website to Date
2022-07-03
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
-
Employee Referral Program to Date
-
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
2022-06-21
Local Ethnic Newspaper to Date
2022-06-21
Radio/TV Ad from Date
2022-06-30
Radio/TV Ad to Date
2022-06-30
Employer Received the Payment
N
Payment Details
-
Bargaining Representative Notified
N/A
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
US Worker Considered
-
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Employee Info
24 fields
Foreign Worker Education
Master's
Foreign Worker Education Other
-
Foreign Worker Major
COMPUTER APPLICATIONS
Year of Compelted Education
2013
Foreign Worker Istitution of Eduation
PANJAB UNIVERSITY
Foreign Worker Education Instution Address Line 1
SECTOR 14
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
CHANDIGARH
Foreign Worker Educatution Institution State
CHANDIGARH
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Training Post Code
160 014
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
Y
Foreign Worker Alternate Education and Experience
Y
Foreign Worker Alternate Occupation Experience
Y
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pay for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Karin Wolman
Preparer Title
Attorney
Preparer Email
Karin@kwvisalaw.com
Employer Information Declaration Name
Jennifer F Whetsell
Employer Declaration Title
VP Associate General Counsel