For visitors, travel, student and other international travel medical insurance.
Visit insubuy.com or call +1 (866) INSUBUY or +1 (972) 985-4400Greencard Sponsors
Greencard Sponsors Case Details
Certified-Expired
BANK OF AMERICA (New York, NEW YORK)
Job Title: Assistant Vice President / Programmer Mkts
Wage Rate: $122,990.00
Employer Business Identification
Employer Name
BANK OF AMERICA
Fiscar Year
2022
Case Status
Certified-Expired
Case Number
A-21071-61796
Received Date
5/11/21
2007 NAICS US Code
522110
Job Title
Assistant Vice President / Programmer Mkts
Country of Citizenship
CHINA
Prevailing Wage Information
SOC Code
15-1132
Level
Level II
Wage Rate
100526.0
SOC Title
Software Developers, Applications
Source
OES
Wage Rate & Work Location
Wage Rate
$122,990.00 per year
City
New York
State
NEW YORK
Contact & Attorney Information
Attorney Firm Name
FRAGOMEN, DEL REY, BERNSEN LOEWY, LLP
Attorney Name
Isha Atassi
Attorney Location
New York, NEW YORK
Others
Decision Date
10/4/21
Refile
N
Scheduled A Sheepherder
N
Employer Phone
646-855-1847
Employer Number of Employees
208000
Employer Year of Commenced Business
1904
FW Ownership Interest
N
Employer Contact Name
Rachel Goldin
Employer Contact Address 1
1114 AVENUE OF THE AMERICAS
Employer Contact City
New York
Employer Contact State/Province
NEW YORK
Employer Contact Postal Code
10036
Employer Contact Phone
646-855-1847
Employer Contact Email
[email protected]
Agent Attorney Phone
(212) 688-8555
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10020178683204
Prevailing Wage Determination Date
10/29/20
Prevailing Wage Expiration Date
6/30/21
Minimum Education
Master's
Major Field Of Study
INFO SYS, ENG (ANY), COMP SCI OR REL
Required Training
N
Required Expirence Months
24
Required Expirence
Y
Acceptable Alternate Field Of Study
N
Acceptable Alternate Combination
N
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
24
Alternate Occupation Job Title
Job offered or a related IT occupation
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Must include 2 years of experience in each of the following Analyzing and troubleshooting all major incidents and production issues utilizing SQL, PLSQL, UNIX Shell Script, Python, Core JAVA, XML, HTML and CSS; Using PLSQL Development OracleEXADATA database; Designing, creating and implementing complex ETL process by pulling large volume of data from various data sources using Informatica Power Center, ODI and SQL; Optimizing data processing performance, monitoring and maintaining multiple applications and jobs in development, QA, staging, and production environments; and, Automating configuration management and deployments using SVN.
Combination of Occupations
N
Offered To Foreign Worker
Y
Foreign Worker live in Employer Premises
N
Live-in Domestic Service Worker
N
Professional Occupation
Y
College or University Teacher
N
SWA Job Order Start Date
1/21/21
SWA Job Order End Date
2/25/21
Sunday Edition News Paper
Y
First News Paper Name
The New York Times
First Advertisement Start Date
1/24/21
Second News Paper Ad Name
The New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
1/31/21
Professional Organization Ad From Date
1/25/21
Professional Organization Ad To Date
2/3/21
Job Search Website From Date
1/24/21
Job Search Webiste To Date
2/2/21
Local Ethnic Paper From Date
1/27/21
Local Ethnic Paper To Date
1/27/21
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
CHINA
Class Of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker INFO Major
INFORMATION SYSTEMS
Foreign Worker Education Completed
2014
Foreign Worker Educational Institution
STEVENS INSTITUTE OF TECHNOLOGY
Foreign Worker Educational Institution Address 1
CASTLE POINT TERRACE
Foreign Worker Educational Institution City
HOBOKEN
Foreign Worker Educational Institution State
NJ
Foreign Worker Educational Institution Country
UNITED STATES OF AMERICA
Foreign Worker Educational Institution Postal Code
07030
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N
Foreign Worker Alternate Education/Experience
N/A
Foreign Worker Has Experience in Alternate Occupation
Y
Foreign Worker Experience With Employer
N
Employer Paid For Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Isha Atassi
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Rachel Goldin
Title of Person Signing Employer Declaration
Senior Vice President
