All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20190-73927
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20190-73927
Case Status
Certified-Expired
Received Date
2020-08-10
Decision Date
2021-03-22
Refile
N
Original File Date
2021-01-01 09:07:53
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
GERMANIA FARM MUTUAL INSURANCE ASSOCIATION
Employer Name Slug
germania-farm-mutual-insurance-association
Employer Address 1
507 HWY 290 E
Employer Address 2
Employer City
BRENHAM
Employer City Slug
brenham
Employer State
TEXAS
Employer State Slug
texas
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
77833
Employer Phone
979-836-5224
Employer Number of Employees
452
Employer Year Commenced Business
1896
NAICS Code
52412
FW Ownership Interest
N
Employer Contact Name
Carol R McBride
Employer Contact Address 1
P.O. Box 645
Employer Contact Address 2
Employer Contact City
Brenham
Employer Contact State/Province
TEXAS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
77833
Employer Contact Phone
979-830-7553
Employer Contact Email
cmcbride@germaniainsurance.com
Agent Attorney Name
Mark J Wu
Agent Attorney Firm Name
Ogletree, Deakins, Nash, Smoak Stewart, P.C.
Agent Attorney Phone
5123444707
Agent Attorney Address 1
301 Congress Avenue
Agent Attorney Address 2
Suite 1150
Agent Attorney City
Austin
Agent Attorney State/Province
TEXAS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
78701
Agent Attorney Email
mark.wu@ogletreedeakins.com
PW Track Number
P10020016259237
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level II
PW Wage
62442.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-04-15
PW Expiration Date
2020-07-14
Wage Offer From
85000.24
Wage Offer To
0.00
Average Salary
85000.24
Wage Unit of Pay
Year
Worksite Address 1
507 Highway 290 East
Worksite Address 2
Worksite City
Brenham
Worksite City Slug
brenham
Worksite State
TEXAS
Worksite Postal Code
77833
Job Title
ETL Developer
Job Title Slug
etl-developer
Minimum Education
Master's
Major Field of Study
Computer Science
Required Training
N
Required Experience
Y
Required Experience Months
12
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.11
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
Software Developer all levels, see H.11
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Requires one 1 year of experience in the following RDBMS databases such SQL Server andor Oracle; Modern software design and development methodologies including Agile Scrum; Responding to information needs and process flows; Ensuring data quality and reliability and providing feedback to business team on how to improve data quality; and Troubleshooting, debugging, and resolving production related issues.
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-04-24
SWA Job Order End Date
2020-05-28
Sunday Edition Newspaper
Y
First Newspaper Name
The BannerPress
First Advertisement Start Date
2020-04-26
Second Newspaper Ad Name
The BannerPress
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-05-03
Employer Website From Date
2020-04-24
Employer Website To Date
2020-05-04
Professional Organization Ad From Date
2021-01-01 09:07:53
Professional Organization Advertisement To Date
2021-01-01 09:07:53
Job Search Website From Date
2020-04-24
Job Search Website To Date
2020-05-04
Employee Referral Program From Date
2021-01-01 09:07:53
Employee Referral Program To Date
2021-01-01 09:07:53
Local Ethnic Paper From Date
2021-01-01 09:07:53
Local Ethnic Paper To Date
2021-01-01 09:07:53
Radio/TV Ad From Date
2020-04-29
Radio/TV Ad To Date
2020-04-29
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
2016
Foreign Worker Institution of Education
UNIVERSITY OF MISSOURI KANSAS CITY
Foreign Worker Education Institution Address 1
5000 HOLMES ST
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
KANSAS CITY
Foreign Worker Education Institution State/Province
MO
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
64110
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Mark J Wu
Preparer Title
Attorney
Preparer Email
mark.wu@ogletreedeakins.com
Employer Information Declaration Name
Carol McBride
Employer Information Declaration Title
Senior Director, Human Resources