All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20241-93601
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20241-93601
Case Status
Certified
Received Date
2020-11-04
Decision Date
2021-05-25
Refile
N
Original File Date
2021-01-01 09:27:39
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
TRUWEST CREDIT UNION
Employer Name Slug
truwest-credit-union
Employer Address 1
1667 N. PRIEST DRIVE
Employer Address 2
Employer City
TEMPE
Employer City Slug
tempe
Employer State
ARIZONA
Employer State Slug
arizona
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
85281
Employer Phone
4804415900
Employer Number of Employees
260
Employer Year Commenced Business
2003
NAICS Code
52213
FW Ownership Interest
N
Employer Contact Name
Erica J Salinas
Employer Contact Address 1
1667 N. Priest Drive
Employer Contact Address 2
Employer Contact City
Tempe
Employer Contact State/Province
ARIZONA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
85281
Employer Contact Phone
4804415900
Employer Contact Email
ejsalinas@truwest.org
Agent Attorney Name
Jared C Leung
Agent Attorney Firm Name
JCL Immigration Attorneys, PLLC
Agent Attorney Phone
6026759486
Agent Attorney Address 1
3200 N. Hayden Road
Agent Attorney Address 2
Suite 320
Agent Attorney City
Scottsdale
Agent Attorney State/Province
ARIZONA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
85251
Agent Attorney Email
jleung@jclimmigration.com
PW Track Number
P10020056350438
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level II
PW Wage
74443.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-05-13
PW Expiration Date
2020-08-11
Wage Offer From
90307.86
Wage Offer To
0.00
Average Salary
90307.86
Wage Unit of Pay
Year
Worksite Address 1
1667 N. Priest Drive
Worksite Address 2
Worksite City
Tempe
Worksite City Slug
tempe
Worksite State
ARIZONA
Worksite Postal Code
85284
Job Title
Database Developer
Job Title Slug
database-developer
Minimum Education
Master's
Major Field of Study
Computer Technology, Computer Systems Technology, Information Systems, or closely related
Required Training
N
Required Experience
Y
Required Experience Months
12
Accept Alternative Field of Study
N
Accept Alternative Major 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
12
Accept Alternative Job Title
in job offered or MS SQL BI Report Developer or closely related
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Education Requirements Masters Degree in Computer Technology, Computer Systems Technology, Information Systems, or closely relatedbr br Experience Requirements 12 months experience in job offered or MS SQL BI Report Developer or closely relatedbr br Special skills requirementsbr br 1. Experience with DB2 Databases, TransactStructured Query Language TSQL, Stored Procedures, Data Transformation Services Extract Transform Load DTSETL.br 2. Experience with account processing Solutionsbr 3. Experience with financial institution member research MCIF and CRMbr 4. Experience with Structured Query Language SQL, User Functions and administering SQL and PowerBI.br 5. Experience auditing data through Extract Transform Load ETL on a centralized data center Operational Data Storage ODS and creating dashboards out of SQL Server Integration Service Database SSISDB systembr 6. Experience creating database objects for reporting team and make data flow is fast for business dashboardsbr 7. Experience converting dashboards from legacy system into new environment Tableau BI dashboards
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
2020-06-01
SWA Job Order End Date
2020-07-06
Sunday Edition Newspaper
Y
First Newspaper Name
The Arizona Republic
First Advertisement Start Date
2020-05-31
Second Newspaper Ad Name
The Arizona Republic
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-06-07
Employer Website From Date
2020-05-19
Employer Website To Date
2020-06-02
Professional Organization Ad From Date
2021-01-01 09:27:39
Professional Organization Advertisement To Date
2021-01-01 09:27:39
Job Search Website From Date
2020-06-02
Job Search Website To Date
2020-06-16
Employee Referral Program From Date
2021-01-01 09:27:39
Employee Referral Program To Date
2021-01-01 09:27:39
Local Ethnic Paper From Date
2020-05-31
Local Ethnic Paper To Date
2020-05-31
Radio/TV Ad From Date
2021-01-01 09:27:39
Radio/TV Ad To Date
2021-01-01 09:27:39
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 TECHNOLOGYCOMPUTER SYSTEMS TECHNOLOGY
Foreign Worker Years of Education Completed
2014
Foreign Worker Institution of Education
EASTERN ILLINOIS UNIVERSITY
Foreign Worker Education Institution Address 1
600 LINCOLN AVE.
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CHARLESTON
Foreign Worker Education Institution State/Province
IL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
61920
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jared C Leung
Preparer Title
Attorney
Preparer Email
jleung@jclimmigration.com
Employer Information Declaration Name
Erica Salinas
Employer Information Declaration Title
Human Resources Business Partner