All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21118-79665
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21118-79665
Case Status
Certified-Expired
Received Date
2021-05-06
Decision Date
2021-10-21
Refile
N
Original File Date
2022-01-01 10:18:14
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
WELLS FARGO BANK, N.A.
Employer Name Slug
wells-fargo-bank-na
Employer Address 1
101 NORTH PHILLIPS AVENUE
Employer Address 2
Employer City
SIOUX FALLS
Employer City Slug
sioux-falls
Employer State
SOUTH DAKOTA
Employer State Slug
south-dakota
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
57104
Employer Phone
704-374-4920
Employer Number of Employees
260000
Employer Year Commenced Business
1852
NAICS Code
52399
FW Ownership Interest
N
Employer Contact Name
Rachael Kerpan
Employer Contact Address 1
350 W. Colorado Blvd.
Employer Contact Address 2
4th Floor
Employer Contact City
Pasadena
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
91105
Employer Contact Phone
626-590-0725
Employer Contact Email
rae.kerpan@wellsfargo.com
Agent Attorney Name
JACOB KANYUSIK
Agent Attorney Firm Name
Ogletree, Deakins, Nash, Smoak Stewart, P.C.
Agent Attorney Phone
9197879700
Agent Attorney Address 1
P.O. Box 31608
Agent Attorney Address 2
Agent Attorney City
Raleigh
Agent Attorney State/Province
NORTH CAROLINA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
27622
Agent Attorney Email
jake.kanyusik@ogletree.com
PW Track Number
P10020258821596
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level IV
PW Wage
127150.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-01-12
PW Expiration Date
2021-06-30
Wage Offer From
132900.00
Wage Offer To
167700.00
Average Salary
150300.00
Wage Unit of Pay
Year
Worksite Address 1
2975 Regent Blvd.
Worksite Address 2
Floor 1
Worksite City
Irving
Worksite City Slug
irving
Worksite State
TEXAS
Worksite Postal Code
75063
Job Title
Application Systems Engineer 5
Job Title Slug
application-systems-engineer-5
Minimum Education
Bachelor's
Major Field of Study
Electronics Engineering
Required Training
N
Required Experience
Y
Required Experience Months
84
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Communications Engineering, Computer Science, or related technical field of study.
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
84
Accept Alternative Job Title
Application Systems Engineer or Developer, Programmer, Analyst, or related position in software appl
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Position requires a Bachelors degree in Electronics Engineering, Communications Engineering, Computer Science, or related technical field of study plus seven 7 years of experience in job offered or as an Application Systems Engineer or Developer, Programmer, Analyst, or related position in software applications development and implementation.br br Position requires experience and skill with the followingbr Analyzing ETL jobs within the data warehouse application environment.br Troubleshooting and analyzing complex production problems related to source data.br Troubleshooting and analyzing existing Ab Initio code as well as fixing the Ab Initio code, including plans, graphs, and transforms to resolve production incidents.br Facilitating Ab Initio code reading transformation mappings, psets, and generic graphs to resolve production issues.br Resolving complex data design issuesprovide optimal solutions that meet business requirements and benefits system performance.br Developing and updating documentation, departmental technical procedures and user guides.br Performing design reviews and ensuring application of best practices and standards.br Reviewing ETL code for consistency, quality, and performance.br Reviewing release code in lower environments and ensuring they follow production standards.br Operating Systems Unix, Linux, Teradata, Oracle, Windows, and other RDBMS.
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
2021-02-17
SWA Job Order End Date
2021-03-26
Sunday Edition Newspaper
Y
First Newspaper Name
The Dallas Morning News
First Advertisement Start Date
2021-02-14
Second Newspaper Ad Name
The Dallas Morning News
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-02-21
Employer Website From Date
2022-01-01 10:18:14
Employer Website To Date
2022-01-01 10:18:14
Professional Organization Ad From Date
2021-02-15
Professional Organization Advertisement To Date
2021-02-22
Job Search Website From Date
2021-02-14
Job Search Website To Date
2021-02-21
Employee Referral Program From Date
2022-01-01 10:18:14
Employee Referral Program To Date
2022-01-01 10:18:14
Local Ethnic Paper From Date
2021-02-18
Local Ethnic Paper To Date
2021-02-24
Radio/TV Ad From Date
2022-01-01 10:18:14
Radio/TV Ad To Date
2022-01-01 10:18:14
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
Bachelor's
Foreign Worker Information: Major
ELECTRONICS COMMUNICATION ENGINEERING
Foreign Worker Years of Education Completed
2008
Foreign Worker Institution of Education
PUNJAB TECHNICAL UNIVERSITY
Foreign Worker Education Institution Address 1
BEANT COLLEGE OF ENGINEERING TECHNOLOGY
Foreign Worker Education Institution Address 2
NATIONAL HIGHWAY 15, GURDASPUR PATHANKOT ROAD, BARIAR, GURDASPUR
Foreign Worker Education Institution City
JALANDHAR
Foreign Worker Education Institution State/Province
PUNJAB
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
143521
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jacob Kanyusik
Preparer Title
Attorney
Preparer Email
Jake.Kanyusik@ogletree.com
Employer Information Declaration Name
Declan Mumford
Employer Information Declaration Title
Immigration Consultant