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
AMAZON WEB SERVICES INC (Chicago, IL)
Job Title: Professional Services II - Big Data Consultant
Wage Rate: $105,269.00
Employer Business Identification
Employer Name
AMAZON WEB SERVICES INC
Fiscar Year
2020
Case Status
Certified-Expired
Case Number
A-19280-67447
Received Date
10/22/19
2007 NAICS US Code
454111
Job Title
Professional Services II - Big Data Consultant
Country of Citizenship
PAKISTAN
Prevailing Wage Information
SOC Code
15-1121
Level
Level IV
Wage Rate
105269.0
SOC Title
Computer Systems Analysts
Source
OES
Wage Rate & Work Location
Wage Rate
$105,269.00 to 185,000.00 per year
City
Chicago
State
IL
Contact & Attorney Information
Attorney Firm Name
Berry Appleman Leiden LLP
Attorney Name
Haesung Kim
Attorney Location
McLean, VIRGINIA
Others
Decision Date
3/13/20
Refile
N
Scheduled A Sheepherder
N
Employer Phone
206-266-1000
Employer Number of Employees
566000
Employer Year of Commenced Business
2006
FW Ownership Interest
N
Employer Contact Name
Julie A Eisemann
Employer Contact Address 1
2021 7th Ave.
Employer Contact City
Seattle
Employer Contact State/Province
WASHINGTON
Employer Contact Postal Code
98121
Employer Contact Phone
206-266-1000
Employer Contact Email
[email protected]
Agent Attorney Phone
703-226-2801
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10018201064587
Prevailing Wage Determination Date
10/26/18
Prevailing Wage Expiration Date
6/30/19
Minimum Education
Bachelor's
Major Field Of Study
Computer Science, Eng, Industrial Eng or related quantiative or scientific field
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
Any occupation meeting H.14.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
A Bachelors degree in Computer Science, Engineering, Industrial Engineering or related quantitative or scientific field followed by 5 progressively responsible years of experience in the job offered or a related database management or design role. Experience must includebr br 1 3 years of implementationconsulting experience in software development, distributed computing, andor enterprise environments.br 2 2 years of experience in two of the following areas Database and Analytical Technologies MySQL, Oracle, MSSQL, MPP databases, NoSQL storage, Data Warehouse design, BI reporting, ETLELT processes and Dashboard development, and Big Data and Implementation and tuning experience Hadoop, Pig and Hive.br 3 1 year of experience working with cloudbased service offerings for Enterprise Customers at large multinational global organizations.br 4 2 years of client facing support experience to prepare and deliver technical and business driven reports to Enterprise CustomersClient senior management regarding tradeoffs, best practices, project management and risk mitigation.
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/5/19
SWA Job Order End Date
7/5/19
Sunday Edition News Paper
Y
First News Paper Name
Chicago Tribune
First Advertisement Start Date
6/23/19
Second News Paper Ad Name
Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
6/30/19
Job Search Website From Date
6/5/19
Job Search Webiste To Date
6/17/19
Local Ethnic Paper From Date
6/27/19
Local Ethnic Paper To Date
6/27/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
PAKISTAN
Class Of Admission
H-1B
Foreign Worker Education
Bachelor's
Foreign Worker INFO Major
INDUSTRIAL ENGINEERING
Foreign Worker Education Completed
2013
Foreign Worker Educational Institution
NORTHWESTERN UNIVERSITY
Foreign Worker Educational Institution Address 1
2145 SHERIDAN ROAD
Foreign Worker Educational Institution City
EVANSTON
Foreign Worker Educational Institution State
IL
Foreign Worker Educational Institution Country
UNITED STATES OF AMERICA
Foreign Worker Educational Institution Postal Code
60208
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
Haesung Kim
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Omesh Seemangal
Title of Person Signing Employer Declaration
Senior Immigration Program Specialist

Insurance