Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:AMERICAN EXPRESS TRAVEL RELATED SERVICES
Employer Address_Line 1:200 VESEY STREET
Employer Address_Line 2:MAIL CODE 014909
Employer City :NEW YORK
State:
Employer State/ Province:NEW YORK
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:10285
Employer Phone No.:212-640-2000
Employer Phone Extent No.:
Total Number of Employees:23000
Employer Year of Commenced :
NAICS Code:522210
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Richard N Quinones
Employer Contact Address Line1:200 Vesey Street
Employer Contact Address Line2:Mail Code 014906
Employer Contact City:New York
Employer Contact State/ Provice:NEW YORK
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:10285
Employer Contact Phone:212-640-1129
Employer Contact Email:immigrationteam@aexp.com
Attorney
Agent/ Attorney Name:Grace Shie
Agent/ Attorney Firm Name:Mayer Brown LLP
Agent/ Attorney Phone:2022633845
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:Mayer Brown LLP
Agent/ Attorney Address Line 2:1999 K Street, NW
Agent/ Attorney City:Washington
Agent/ Attorney State/ Province:DISTRICT OF COLUMBIA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:20006
Agent/ Attorney Email:gshie@mayerbrown.com
Position Info
Prevailing Wage Track Number:P10020347955656
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Database Architects
Prevailing Wage Skill Level:Level IV
Prevailing Wage:105518
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-06-03
Prevailing Wage Expiration Date :2021-09-01
Wage Offer From:121597
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:18850 N. 56th St.
Worksite Address Line 2:
Worksite City :Phoenix
Worksite State:ARIZONA
Worksite Postal Code:85054
Job Title:Senior Data Engineer
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Computer Science
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:Y
Accept Alternate Major:Engineering, Information Systems, or a related STEM field
Alternate Combination of Education/ Experience:N
Required Alternate Level of Education :
Other Alternate Level of Education:
Acceptable Years of Experience:
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:60
Accept Alternate Job Title:Database Architects, DATA ENGINEER, IT ANALYST, SOFTWARE ENGINEER, or rel occ
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Position requires a Bachelors degree in Computer Science, Engineering, Information Systems, or a related STEM field, followed by 5 years of progressively responsible database administration experience. Experience must include a minimum of 1 year of experience with developing and tuning with a relational database RDMS; 1 year of experience with database development and support of OLTP and OLAP systems; 1 year of experience with transforming logical data architectures into physical data designs; 1 year of experience with applying Agile methodologies; and 1 year of experience with BI reporting, database process optimization, data modeling, data profiling, data quality, data security, data processing ETL, dimensional modeling, IBM OB2, Informatica, Linux, Oracle databases, PLSQL, Python, schema designing, and SQL tuning.
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:2021-02-03
Job Oder End Date:2021-03-10
Sunday Edition Newspaper:Y
First Newspaper Name:The Arizona Republic
First Advertisement Start Date:2021-02-07
Second Newspaper Name:The Arizona Republic
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-02-14
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-02-02
Employer Website to Date:2021-03-19
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-02-03
Job Search Website to Date:2021-02-17
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-02-02
Employee Referral Program to Date:2021-03-19
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:
Local Ethnic Newspaper to Date:
Radio/TV Ad from Date:
Radio/TV Ad to Date:
Employer Received the Payment:N
Payment Details:
Bargaining Representative Notified:N/A
Posted Notice at Worksite:Y
Layoff in Past Six Months:Y
US Worker Considered:Y
Country of Citizenship:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:ELECTRONIC ENGINEERING
Year of Compelted Education:2007
Foreign Worker Istitution of Eduation:UTTAR PRADESH TECHNICAL UNIVERSITY
Foreign Worker Education Instution Address Line 1:SEC11, JANKIPURAM VISTAR
Foreign Worker Education Institution Address Line 2:
