All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22297-44857
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22297-44857
Case Status
Certified-Expired
Received Date
2022-12-07
Decision Date
2023-11-17
Refile
N
Original File Date
2024-01-01 00:19:00
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
TMOBILE USA, INC.
Employer Name Slug
tmobile-usa-inc
Employer Address 1
12920 SE 38TH ST.
Employer Address 2
Employer City
BELLEVUE
Employer City Slug
bellevue
Employer State
WASHINGTON
Employer State Slug
washington
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
98006
Employer Phone
425-378-4000
Employer Number of Employees
74000
Employer Year Commenced Business
1994
NAICS Code
517212
FW Ownership Interest
N
Employer Contact Name
Irene Ballard
Employer Contact Address 1
12920 SE 38th St.
Employer Contact Address 2
Employer Contact City
Bellevue
Employer Contact State/Province
WASHINGTON
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
98006
Employer Contact Phone
425-383-6788
Employer Contact Email
immigration@t-mobile.com
Agent Attorney Name
Julie M Aponte
Agent Attorney Firm Name
J. Aponte Associates, LLC
Agent Attorney Phone
(312) 762-5966
Agent Attorney Address 1
550 Warrenville Rd.
Agent Attorney Address 2
Ste 240
Agent Attorney City
Lisle
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60532
Agent Attorney Email
japonte@japontelaw.com
PW Track Number
P10022006813875
PW SOC Code
15-1199
PW SOC Title
Database Architects
PW Skill Level
Level IV
PW Wage
119475.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-06-29
PW Expiration Date
2022-09-27
Wage Offer From
139050.00
Wage Offer To
0.00
Average Salary
139050.00
Wage Unit of Pay
Year
Worksite Address 1
22309 30th Drive SE
Worksite Address 2
Worksite City
Bothell
Worksite City Slug
bothell
Worksite State
WASHINGTON
Worksite Postal Code
98021
Job Title
Senior Architects, Data
Job Title Slug
senior-architects-data
Minimum Education
Master's
Major Field of Study
Computer Science
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
related field or its equivalent
Accept Alternative Combination
Y
Accept Alternative Combination Education
Bachelor's
Accept Alternative Combination Education Years
5
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
36
Accept Alternative Job Title
relevant work experience
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
PRIMARY REQUIREMENTS Masters degree in Computer Science, related field or equivalent and 3 years of relevant work experience.br br ALTERNATIVE REQUIREMENTS Applicant must have Bachelors degree in Computer Science, related field or equivalent and 5 years of relevant work experience.br br Applicants experience must includebr br Teradata Datawarehouse design; and Teradata development including FASTLOAD, MULTILOAD, BTEQ utilities.br Data modelling using Power Designer to create businessprocess models, and conceptual, logical and physical data models for database design.br Experience in writing BTEQ scripts, Stored proceduresMacro development.br Experience with Teradata performance tuning and query optimization.br Experience in developing in GithubGitlab; and in implementing CICD, DevOps.br Experience in UNIX scripting for using GIT commands for promotingmerging operations, automating DDL modifications.br Hands on experience on technologiestools including Azure ADF, ADB Azure Databricks, PL SQL, Python.br Experience with Agile development model and corresponding tracking tools including JIRA.br Programming experience in Cloud technologies including SnowflakeAzure AWS.br Experience in AVRO, JSON, XML, Parquet.br Telecommuting is permitted, but applicants must live within a reasonable commuting distance.
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
2022-09-08
SWA Job Order End Date
2022-10-10
Sunday Edition Newspaper
Y
First Newspaper Name
The Seattle Times
First Advertisement Start Date
2022-09-18
Second Newspaper Ad Name
The Seattle Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-09-25
Employer Website From Date
2022-09-15
Employer Website To Date
2022-10-03
Professional Organization Ad From Date
2024-01-01 00:19:00
Professional Organization Advertisement To Date
2024-01-01 00:19:00
Job Search Website From Date
2022-09-18
Job Search Website To Date
2022-10-03
Employee Referral Program From Date
2022-09-15
Employee Referral Program To Date
2022-10-03
Local Ethnic Paper From Date
2024-01-01 00:19:00
Local Ethnic Paper To Date
2024-01-01 00:19:00
Radio/TV Ad From Date
2024-01-01 00:19:00
Radio/TV Ad To Date
2024-01-01 00:19:00
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
Foreign Worker Education
Master's
Foreign Worker Information: Major
INDUSTRIAL ENGINEERING
Foreign Worker Years of Education Completed
2011
Foreign Worker Institution of Education
UNIVERSITY OF TEXAS AT ARLINGTON
Foreign Worker Education Institution Address 1
701 S NEDDERMAN DR
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
ARLINGTON
Foreign Worker Education Institution State/Province
TX
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
76019
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Julie M Aponte
Preparer Title
Managing Director
Preparer Email
japonte@japontelaw.com
Employer Information Declaration Name
Irene Yvonne Sharon Lindsay Angelique Ballard Malina Bundy Baitz Roy
Employer Information Declaration Title
Mgr. Sr. Paralegal Sr. Analyst Paralegal