All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23131-41168
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23131-41168
Case Status
Certified
Received Date
2023-05-11
Decision Date
2024-05-28
Refile
N
Original File Date
2024-01-01 01:27:37
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
Farmers New World Life Insurance Co
Employer Name Slug
farmers-new-world-life-insurance-co
Employer Address 1
3120 139th Ave SE
Employer Address 2
Suite 300
Employer City
Bellevue
Employer City Slug
bellevue
Employer State
WASHINGTON
Employer State Slug
washington
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
98005
Employer Phone
818 965 0450
Employer Number of Employees
526
Employer Year Commenced Business
1910
NAICS Code
524113
FW Ownership Interest
N
Employer Contact Name
Viviana V Vasquez
Employer Contact Address 1
6303 Owensmouth Ave
Employer Contact Address 2
Employer Contact City
Woodland Hills
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
91367
Employer Contact Phone
818 965 0450
Employer Contact Email
viviana.vasquez@zurichservices.com
Agent Attorney Name
Tahreem Kalam
Agent Attorney Firm Name
Minsky, McCormick Hallagan, P.C.
Agent Attorney Phone
3124276163
Agent Attorney Address 1
210 S Clark St
Agent Attorney Address 2
Suite 2025
Agent Attorney City
Chicago
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60603
Agent Attorney Email
tkalam@mmhpc.com
PW Track Number
P-100-22091-030
PW SOC Code
15-1243.01
PW SOC Title
Data Warehousing Specialists
PW Skill Level
Level II
PW Wage
138861.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-10-26
PW Expiration Date
2023-06-30
Wage Offer From
138861.00
Wage Offer To
0.00
Average Salary
138861.00
Wage Unit of Pay
Year
Worksite Address 1
3120 139th Avenue SE
Worksite Address 2
Suite 300
Worksite City
Bellevue
Worksite City Slug
bellevue
Worksite State
WASHINGTON
Worksite Postal Code
98005
Job Title
Sr. Informatica Developer
Job Title Slug
sr-informatica-developer
Minimum Education
Bachelor's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
24
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
24
Accept Alternative Job Title
See H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Position requires a Bachelors degree or foreign equivalent, in Computer Science, Electronics Engineering, or a closely related field of study, plus 2 years of experience in the job offered, or as a Technology Lead, or similar experience in data warehouse and ETL domain. Must have 2 years of experience with each of the following working with ETL Tools, including Informatica PowerCenter 10.1, Informatica PowerExchange; working with Databases, including Oracle 12c, 11i, 10g, and Teradata; working with various languages, including Oracle PLSQL, Oracle Stored Procedure, UnixLinux Shell scripting, and Python programming; and working with Cloud Technologies, including AWS Lambda, AWS Glue, AWS Dynamo DB, AWS Aurora DB, and AWS Redshift. Must have AWS Certified Cloud Practitioner Certification. Option to work remotely is available.
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-12-01
SWA Job Order End Date
2023-01-02
Sunday Edition Newspaper
Y
First Newspaper Name
Seattle TImes
First Advertisement Start Date
2022-12-04
Second Newspaper Ad Name
Seattle Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-12-11
Employer Website From Date
2022-11-21
Employer Website To Date
2023-02-03
Professional Organization Ad From Date
2024-01-01 01:27:37
Professional Organization Advertisement To Date
2024-01-01 01:27:37
Job Search Website From Date
2022-12-28
Job Search Website To Date
2023-01-02
Employee Referral Program From Date
2024-01-01 01:27:37
Employee Referral Program To Date
2024-01-01 01:27:37
Local Ethnic Paper From Date
2024-01-01 01:27:37
Local Ethnic Paper To Date
2024-01-01 01:27:37
Radio/TV Ad From Date
2022-12-28
Radio/TV Ad To Date
2022-12-28
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 ENGINEERING
Foreign Worker Years of Education Completed
2005
Foreign Worker Institution of Education
UNIVERSITY OF KERALA
Foreign Worker Education Institution Address 1
SENATE HOUSE CAMPUS, PALAYAM
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
THIRUVANANTHAPURAM
Foreign Worker Education Institution State/Province
KERALA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
695033
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Tahreem Kalam
Preparer Title
Partner
Preparer Email
tkalam@mmhpc.com
Employer Information Declaration Name
Michael Marquardt
Employer Information Declaration Title
Head of HR Client Experience