All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19224-42950
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19224-42950
Case Status
Certified-Expired
Received Date
2019-10-15
Decision Date
2020-03-13
Refile
N
Original File Date
2020-01-01 07:48:54
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
U.S. BANK NATIONAL ASSOCIATION
Employer Name Slug
us-bank-national-association
Employer Address 1
800 NICOLLET MALL
Employer Address 2
Employer City
MINNEAPOLIS
Employer City Slug
minneapolis
Employer State
MINNESOTA
Employer State Slug
minnesota
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
55402
Employer Phone
612-303-9841
Employer Number of Employees
74000
Employer Year Commenced Business
1929
NAICS Code
521110
FW Ownership Interest
N
Employer Contact Name
Stefan Johansson
Employer Contact Address 1
800 Nicollet Mall
Employer Contact Address 2
BCMNH21N
Employer Contact City
Minneapolis
Employer Contact State/Province
MINNESOTA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
55402
Employer Contact Phone
612-303-9841
Employer Contact Email
meghan.list@usbank.com
Agent Attorney Name
Agent Attorney Firm Name
Agent Attorney Phone
Agent Attorney Address 1
Agent Attorney Address 2
Agent Attorney City
Agent Attorney State/Province
Agent Attorney Country
Agent Attorney Postal Code
Agent Attorney Email
PW Track Number
P10019070098715
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level III
PW Wage
100880.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-06-24
PW Expiration Date
2019-09-22
Wage Offer From
100880.00
Wage Offer To
0.00
Average Salary
100880.00
Wage Unit of Pay
Year
Worksite Address 1
3180 S. Rider Trail
Worksite Address 2
Worksite City
Earth City
Worksite City Slug
earth-city
Worksite State
MISSOURI
Worksite Postal Code
63045
Job Title
ETL Developer
Job Title Slug
etl-developer
Minimum Education
Master's
Major Field of Study
Computer Science, related
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
Bachelor's
Accept Alternative Combination Education Years
60
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
36
Accept Alternative Job Title
Prog Analyst, Sys Eng, SW Dev, related
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Masters degree in Computer Science or related field plus 3 years of experience or a Bachelors degree in Computer Science or related field plus 5 years of experience. Must have 3 years with creating complex mappings using transformations, Informatica Power Center, DB2, and SQL Server; 2 years with system and development testing; and 1 year with Autosys, development and maintenance of data warehouse, database design and development using Oracle, and performing ETL and database code migrations across environments in the financial services or banking industry. Employer will accept candidates with any suitable combination of education or experience as described in H4 to H10, above.
Combination Occupation
N
Offered to Applicant Foreign Worker
Y
Foreign Worker Live on Premises
N
Foreign Worker Live in Domestic Service
N
Foreign Worker Live in Domestic Service Count
Professional Occupation
Y
Application for College/University Teacher
N
SWA Job Order Start Date
2019-06-26
SWA Job Order End Date
2019-07-31
Sunday Edition Newspaper
Y
First Newspaper Name
St. Louis PostDispatch
First Advertisement Start Date
2019-06-30
Second Newspaper Ad Name
St. Louis PostDispatch
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-07-07
Employer Website From Date
2019-06-26
Employer Website To Date
2019-07-31
Professional Organization Ad From Date
2020-01-01 07:48:54
Professional Organization Advertisement To Date
2020-01-01 07:48:54
Job Search Website From Date
2019-06-30
Job Search Website To Date
2019-07-08
Employee Referral Program From Date
2020-01-01 07:48:54
Employee Referral Program To Date
2020-01-01 07:48:54
Local Ethnic Paper From Date
2019-07-05
Local Ethnic Paper To Date
2019-07-11
Radio/TV Ad From Date
2020-01-01 07:48:54
Radio/TV Ad To Date
2020-01-01 07:48:54
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2014
Foreign Worker Institution of Education
THE UNIVERSITY OF SOUTHERN MISSISSIPPI
Foreign Worker Education Institution Address 1
118 COLLEGE DRIVE
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
HATTIESBURG
Foreign Worker Education Institution State/Province
MS
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
39406
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
Y
Preparer Name
Preparer Title
Preparer Email
Employer Information Declaration Name
Stefan Johansson
Employer Information Declaration Title
Senior Corporate Counsel