Fiscal Year

2022

Case Number

A-21235-34922

Case Status

Certified-Expired

Received Date

2021-09-08

Decision Date

2022-03-02

Refile

N

Original File Date

2022-01-01 11:01:07

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

FPT USA, CORP

Employer Name Slug

fpt-usa-corp

Employer Address 1

801 E CAMPBELL ROAD

Employer Address 2

STE. 525

Employer City

RICHARDSON

Employer City Slug

richardson

Employer State

TEXAS

Employer State Slug

texas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

75081

Employer Phone

214-253-2662

Employer Number of Employees

261

Employer Year Commenced Business

2008

NAICS Code

541519

FW Ownership Interest

N

Employer Contact Name

Phuong T Dang

Employer Contact Address 1

801 E. CAMPBELL RD.

Employer Contact Address 2

Suite 525

Employer Contact City

Richardson

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

75081

Employer Contact Phone

+1 214 253 2662

Employer Contact Email

vivien.le@fsoft.com.vn

Agent Attorney Name

Gali Schaham Gordon

Agent Attorney Firm Name

Gordon Law Group PC

Agent Attorney Phone

415-284-1601

Agent Attorney Address 1

461 2nd Street

Agent Attorney Address 2

#C301

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94107

Agent Attorney Email

team@gordonlawgrouppc.com

PW Track Number

P10020344944253

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

N/A

PW Wage

86378.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2021-06-02

PW Expiration Date

2021-08-31

Wage Offer From

125000.00

Wage Offer To

0.00

Average Salary

125000.00

Wage Unit of Pay

Year

Worksite Address 1

2 Concourse Parkway

Worksite Address 2

Ste. 100

Worksite City

Atlanta

Worksite City Slug

atlanta

Worksite State

GEORGIA

Worksite Postal Code

30328

Job Title

Senior Data Operation Engineer

Job Title Slug

senior-data-operation-engineer

Minimum Education

Bachelor's

Major Field of Study

Information Technology or an Engineering field

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

Manager; Senior Consultant

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

2 years of experience with data warehousing and data analysis.br br 2 years of experience extracting, transforming, and loading data on the Informatica platform using Informatica Mappings, Informatica Sessions, Informatica Workflows, Unix Shell Scripts, Database Triggers, and Stored Procedures.br br 2 years of experience with data modeling using FACT, DIMENSION, DATAMART creations for various entities.br br 2 years of experience writing and tuning SQL queries to perform data extraction and analysis.br br 2 years of experience with the Agile methodology and Scrumsprintiterative development.br br 2 years of experience with big data implementation, including using AWS Lambda, AWS EMR, and Python to transform data in the cloud for integrating data into data warehouse.br br 2 years of experience maintaining, tuning, and providing support for Informatica batch, real time CDC workflows, database upgrades, and production to meet established SLAs.br br 2 years of experience triaging and suggesting solutions for data issues with multiple systems and teams.br br 2 years of experience with AS400 and mainframe technologies, such as RPGLE, CLLE, JCL, IMS, DB2, PL1, and COBOL, for analyzing legacy code to derive existing data rules and transformations.

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

2021-06-18

SWA Job Order End Date

2021-07-23

Sunday Edition Newspaper

Y

First Newspaper Name

The Atlanta JournalConstitution

First Advertisement Start Date

2021-06-27

Second Newspaper Ad Name

The Atlanta JournalConstitution

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-04

Employer Website From Date

2022-01-01 11:01:07

Employer Website To Date

2022-01-01 11:01:07

Professional Organization Ad From Date

2022-01-01 11:01:07

Professional Organization Advertisement To Date

2022-01-01 11:01:07

Job Search Website From Date

2021-06-18

Job Search Website To Date

2021-07-02

Employee Referral Program From Date

2022-01-01 11:01:07

Employee Referral Program To Date

2022-01-01 11:01:07

Local Ethnic Paper From Date

2021-07-01

Local Ethnic Paper To Date

2021-07-14

Radio/TV Ad From Date

2021-07-06

Radio/TV Ad To Date

2021-07-06

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 AND TELECOMMUNICATION ENGINEERING

Foreign Worker Years of Education Completed

2000

Foreign Worker Institution of Education

UNIVERSITY OF MUMBAI

Foreign Worker Education Institution Address 1

MAHATMA GANDHI ROAD, VIDYA NAGAR, KALA GHODA, FORT

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

MUMBAI

Foreign Worker Education Institution State/Province

MAHARASHTRA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

400032

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Gali Schaham Gordon

Preparer Title

Attorney

Preparer Email

gali@gordonlawgrouppc.com

Employer Information Declaration Name

Phuong T Dang

Employer Information Declaration Title

Chief Executive Officer