For visitors, travel, student and other international travel medical insurance.

Visit insubuy.com or call +1 (866) INSUBUY or +1 (972) 985-4400

Greencard Sponsors

Greencard Sponsors Case Details

Certified-Expired
AETNA RESOURCES LLC (Chicago, IL)
Job Title: Advanced Software Development Engineer
Wage Rate: $120,000.00
Employer Business Identification
Employer Name
AETNA RESOURCES LLC
Fiscar Year
2020
Case Status
Certified-Expired
Case Number
A-19234-47896
Received Date
9/10/19
2007 NAICS US Code
524114
Job Title
Advanced Software Development Engineer
Country of Citizenship
INDIA
Prevailing Wage Information
SOC Code
15-1132
Level
Level IV
Wage Rate
112403.0
SOC Title
Software Developers, Application
Source
OES
Wage Rate & Work Location
Wage Rate
$120,000.00 per year
City
Chicago
State
IL
Contact & Attorney Information
Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Attorney Name
Freddi M Weintraub
Attorney Location
New York, NEW YORK
Others
Decision Date
12/17/19
Refile
N
Scheduled A Sheepherder
N
Employer Phone
860-273-0123
Employer Number of Employees
49500
Employer Year of Commenced Business
1853
FW Ownership Interest
N
Employer Contact Name
Neal A Murphy
Employer Contact Address 1
151 Farmington Avenue
Employer Contact City
Hartford
Employer Contact State/Province
CONNECTICUT
Employer Contact Postal Code
06156
Employer Contact Phone
860-273-0740
Employer Contact Email
[email protected]
Agent Attorney Phone
2126888555
Agent Attorney Phone Extension
7560
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10019024484965
Prevailing Wage Determination Date
5/8/19
Prevailing Wage Expiration Date
8/6/19
Minimum Education
Bachelor's
Major Field Of Study
Computer Science, Computer Applications or Computer Information Systems
Required Training
N
Required Expirence Months
60
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
60
Alternate Occupation Job Title
Software engineering andor development experience.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Must have at least five years of experience working with the full SDLC in Waterfall and Agile methodologies; implementing end to end solutions in the ETL and ELT domains; performance optimization techniques using ETL and ELT tools; data integration tools, including Informatica PowerCenter; databases, including Oracle; and scripting languages, including LinuxUnix shell scripting. Must also have at least one year of experience working with the following toolstechnologies DataStage; Hadoop; Hive; Netezza; Informatica PowerExchange for SAS; Python; and Agile tool Jira.
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
6/18/19
SWA Job Order End Date
7/19/19
Sunday Edition News Paper
Y
First News Paper Name
The Chicago Tribune
First Advertisement Start Date
6/23/19
Second News Paper Ad Name
The Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
6/30/19
Job Search Website From Date
6/24/19
Job Search Webiste To Date
7/8/19
Employee Referral Program From Date
6/19/19
Employee Referral Program To Date
7/3/19
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
INDIA
Class Of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker INFO Major
COMPUTER INFORMATION SYSTEMS
Foreign Worker Education Completed
2008
Foreign Worker Educational Institution
ANDHRA UNIVERSITY
Foreign Worker Educational Institution Address 1
ANDHRA UNIVERSITY CAMPUS
Foreign Worker Educational Institution City
VISAKHAPATNAM
Foreign Worker Educational Institution State
ANDHRA PRADESH
Foreign Worker Educational Institution Country
INDIA
Foreign Worker Educational Institution Postal Code
530003
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N/A
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
Freddi M Weintraub
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Alexader Nadel
Title of Person Signing Employer Declaration
Director Application Development

Insurance