| LCA CASE NUMBER | I-200-19326-162923 |
| STATUS | Certified |
| LCA CASE SUBMIT | 2019-11-22 |
| DECISION DATE | 2019-12-02 |
| VISA CLASS | H-1B |
| LCA CASE JOB TITLE | Database Administrator III |
| SOC CODE | 15-1141.00 |
| SOC TITLE | Database Administrators |
| FULL TIME POSITION | Y |
| LCA CASE EMPLOYMENT START DATE | 2020-01-01 |
| END DATE | 2022-12-31 |
| TOTAL WORKER POSITIONS | 1 |
| NEW EMPLOYMENT | 0 |
| CONTINUED EMPLOYMENT | 0 |
| CHANGE PREVIOUS EMPLOYMENT | 0 |
| NEW CONCURRENT EMPLOYMENT | 0 |
| CHANGE EMPLOYER | 1 |
| AMENDED PETITION | 0 |
| LCA CASE EMPLOYER NAME | Farmers Mutual Hail Insurance Co. of Iowa |
| EMPLOYER ADDRESS1 | 6785 Westown Pkwy |
| EMPLOYER CITY | West Des Moines |
| EMPLOYER STATE | IA |
| EMPLOYER POSTAL CODE | 50266 |
| EMPLOYER COUNTRY | UNITED STATES OF AMERICA |
| EMPLOYER PHONE | +15157245041 |
| NAICS CODE | 524126 |
| EMPLOYER POC LAST NAME | Farley |
| EMPLOYER POC FIRST NAME | Brian |
| EMPLOYER POC JOB TITLE | AVP, Compensation & Benefits |
| EMPLOYER POC ADDRESS1 | 6785 Westown Pkwy |
| EMPLOYER POC CITY | West Des Moines |
| EMPLOYER POC STATE | IA |
| EMPLOYER POC POSTAL CODE | 50266 |
| EMPLOYER POC COUNTRY | UNITED STATES OF AMERICA |
| EMPLOYER POC PHONE | +15157245041 |
| EMPLOYER POC EMAIL | [email protected] |
| AGENT REPRESENTING EMPLOYER | Y |
| AGENT ATTORNEY LAST NAME | PISTON |
| AGENT ATTORNEY FIRST NAME | MICHAEL |
| AGENT ATTORNEY MIDDLE NAME | EDWARD |
| AGENT ATTORNEY ADDRESS1 | 1955 WEST HAMLIN ROAD |
| AGENT ATTORNEY ADDRESS2 | STE. 100 |
| AGENT ATTORNEY CITY | Rochester Hills |
| AGENT ATTORNEY STATE | MI |
| AGENT ATTORNEY POSTAL CODE | 48309 |
| AGENT ATTORNEY COUNTRY | UNITED STATES OF AMERICA |
| AGENT ATTORNEY PHONE | 12488440700.0 |
| AGENT ATTORNEY PHONE EXT | 3.0 |
| AGENT ATTORNEY EMAIL ADDRESS | [email protected] |
| LAWFIRM NAME BUSINESS NAME | Transnational Legal Services, P.C. |
| STATE OF HIGHEST COURT | MI |
| NAME OF HIGHEST STATE COURT | Michigan Supreme Court |
| WORKSITE WORKERS | 1.0 |
| SECONDARY ENTITY | N |
| WORKSITE ADDRESS1 | 6785 Westown Pkwy |
| LCA CASE WORKLOC1 CITY | West Des Moines |
| WORKSITE COUNTY | POLK |
| LCA CASE WORKLOC1 STATE | IA |
| WORKSITE POSTAL CODE | 50266 |
| LCA CASE WAGE RATE FROM | 127200.0 |
| LCA CASE WAGE RATE UNIT | Year |
| PREVAILING WAGE | 114358.0 |
| PW UNIT OF PAY | Year |
| PW WAGE LEVEL | IV |
| PW OES YEAR | 7/1/2019 - 6/30/2020 |
| TOTAL WORKSITE LOCATIONS | 1.0 |
| AGREE TO LC STATEMENT | Y |
| H-1B DEPENDENT | N |
| WILLFUL VIOLATOR | N |
| PUBLIC DISCLOSURE | Disclose Business |
| PREPARER LAST NAME | Rengaraj |
| PREPARER FIRST NAME | Revathy |
| PREPARER BUSINESS NAME | Transnational Legal Services, P.C. |
| PREPARER EMAIL | [email protected] |
