Fiscal Year

2020

Case Number

A-19300-75639

Case Status

Certified

Received Date

2019-11-08

Decision Date

2020-04-15

Refile

N

Original File Date

2020-01-01 08:12:25

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

BBT

Employer Name Slug

bbt

Employer Address 1

200 WEST SECOND STREET

Employer Address 2

Employer City

WINSTON-SALEM

Employer City Slug

winston-salem

Employer State

NORTH CAROLINA

Employer State Slug

north-carolina

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

27101

Employer Phone

(919) 716-9044

Employer Number of Employees

35908

Employer Year Commenced Business

1872

NAICS Code

522120

FW Ownership Interest

N

Employer Contact Name

Paige A Whitesell

Employer Contact Address 1

434 Fayetteville St Mall

Employer Contact Address 2

Employer Contact City

Raleigh

Employer Contact State/Province

NORTH CAROLINA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

27601

Employer Contact Phone

(919) 716-9044

Employer Contact Email

pwhitesell@bbandt.com

Agent Attorney Name

Jeanette K Phelan

Agent Attorney Firm Name

Constangy, Brooks, Smith Prophete, LLP

Agent Attorney Phone

904-357-2663

Agent Attorney Address 1

200 West Forsyth Street

Agent Attorney Address 2

Suite 1700

Agent Attorney City

Jacksonville

Agent Attorney State/Province

FLORIDA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

32202

Agent Attorney Email

jphelan@constangy.com

PW Track Number

P10019134598354

PW SOC Code

15-1132

PW SOC Title

EDO ETL Developer III

PW Skill Level

Level II

PW Wage

75130.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-08-27

PW Expiration Date

2020-06-30

Wage Offer From

96256.00

Wage Offer To

149196.00

Average Salary

122726.00

Wage Unit of Pay

Year

Worksite Address 1

2400 REYNOLDA RD

Worksite Address 2

Worksite City

WINSTON-SALEM

Worksite City Slug

winston-salem

Worksite State

NORTH CAROLINA

Worksite Postal Code

27106

Job Title

EDO ETL Developer III

Job Title Slug

edo-etl-developer-iii

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

Information Technology, Information Systems or Management Information Systems

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

24

Accept Alternative Job Title

experience as a Technology Specialist, Application Developer or in an IT related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

2 years experience is required and must include Data warehousing and database programming; Analysis, design, development, customization, implementation and testing of software applications and products; ETL Development utilizing Informatica PowerCenter and Big Data Management BDMBDE for Hadoop; Performance tuning ETL tool mappings and sessions; Data warehouse architecture, data quality and data profiling while understanding database concepts such as referential integrity, indexes, and keys; Development using best practices for common ETL design techniques such as change data capture, key generation, error handling, logging and optimization; and Successfully design, deploy and evolve ETL solutions to meet business needs.br br Employer will accept a Bachelors degree and 5 years experience in lieu of a Masters degree and 2 years experience.br br Employer is willing to accept any suitable combination of education, training, or experience.

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

2019-09-04

SWA Job Order End Date

2019-10-04

Sunday Edition Newspaper

Y

First Newspaper Name

WinstonSalem Journal

First Advertisement Start Date

2019-09-15

Second Newspaper Ad Name

WinstonSalem Journal

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-09-22

Employer Website From Date

2019-09-11

Employer Website To Date

2019-09-26

Professional Organization Ad From Date

2020-01-01 08:12:25

Professional Organization Advertisement To Date

2020-01-01 08:12:25

Job Search Website From Date

2019-09-04

Job Search Website To Date

2019-09-19

Employee Referral Program From Date

2020-01-01 08:12:25

Employee Referral Program To Date

2020-01-01 08:12:25

Local Ethnic Paper From Date

2019-09-19

Local Ethnic Paper To Date

2019-09-19

Radio/TV Ad From Date

2020-01-01 08:12:25

Radio/TV Ad To Date

2020-01-01 08:12:25

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

COMPUTER SCIENCE TECHNOLOGY

Foreign Worker Years of Education Completed

2005

Foreign Worker Institution of Education

ANNA UNIVERSITY

Foreign Worker Education Institution Address 1

12, SARDAR PATEL ROAD

Foreign Worker Education Institution Address 2

GUINDY

Foreign Worker Education Institution City

CHENNAI

Foreign Worker Education Institution State/Province

TAMIL NADU

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

600025

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jeanette K Phelan

Preparer Title

Attorney

Preparer Email

jphelan@constangy.com

Employer Information Declaration Name

Paige Whitesell

Employer Information Declaration Title

Immigration Recruiting Support Manager