Fiscal Year

2020

Case Number

A-20038-16540

Case Status

Certified

Received Date

2020-03-13

Decision Date

2020-07-28

Refile

N

Original File Date

2020-01-01 08:36:56

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

SYNECHRON

Employer Name Slug

synechron

Employer Address 1

11 TIMES SQUARE

Employer Address 2

SUITE 3301

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10036

Employer Phone

212-619-5200

Employer Number of Employees

1200

Employer Year Commenced Business

2005

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Charudatt M Garud

Employer Contact Address 1

11 Times Square

Employer Contact Address 2

SUITE 3301

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10036

Employer Contact Phone

615-678-3192

Employer Contact Email

Charudatt.garud@synechron.com

Agent Attorney Name

Rajdeep Singh

Agent Attorney Firm Name

Dua Hobbs Associates

Agent Attorney Phone

4044742660

Agent Attorney Address 1

1270 Caroline Street

Agent Attorney Address 2

Suite D120-336

Agent Attorney City

Atlanta

Agent Attorney State/Province

GEORGIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

30307

Agent Attorney Email

dha@dhallc.com

PW Track Number

P10019213031988

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level II

PW Wage

72030.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-12-02

PW Expiration Date

2020-06-30

Wage Offer From

87528.00

Wage Offer To

0.00

Average Salary

87528.00

Wage Unit of Pay

Year

Worksite Address 1

214 North Tryon Street

Worksite Address 2

Worksite City

Charlotte

Worksite City Slug

charlotte

Worksite State

NORTH CAROLINA

Worksite Postal Code

28202

Job Title

Data Warehouse Architect

Job Title Slug

data-warehouse-architect

Minimum Education

Bachelor's

Major Field of Study

Computer ScienceEngineering, Information Technology or Management Information Systems

Required Training

N

Required Experience

N

Required Experience Months

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

Database Administrator, Software Developer, Programmer or related position

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Skills Required br 1. Databases and tools Mongo, MS Access, Oracle, Sybase, MS SQL Server, PLSQL, Toad, SQLLoader, SSIS, SSRS, SSAS, Talend, Neo4j, Oracle GoldenGate, Enterprise Manager Grid Control, Oracle Exadata DB Machine, Oracle Data Guard, Netezza, Oracle RACbr 2. Data Warehouses EDW, Data Martsbr 3. Data Modeling Star Schema, Snowflake, FactDimension Tables, ERWin Data Modelerbr 4. Job Scheduling Autosysbr 5. Hadoop Distributions Cloudera Hadoop, MapR, Horton Worksbr 6. Hadoop Components HDFS, MapReduce, Hive, Pig, Yarn, Sqoop, Flume, HBase, Impala, Zoo Keeper, Oozie, Kafka, Spark, Python, R, Apache Mahoutbr br Education and Experience Bachelor of Science degree in Computer ScienceEngineering, Information Technology or Management Information Systems. Foreign educational equivalent accepted. Willing to accept a suitable combination of education and experience BachelorMasters degree from a foreign university 3 years experience that equates to at least a Bachelor of Science degree in Computer ScienceEngineering, Information Technology or Management Information Systems from an accredited US university. Two 2 years experience as Database Administrator, Software Developer, Programmer or related position.br br GC Worksite 214 North Tryon Street, Charlotte, NC 28202. Must be willing to relocate to unanticipated locations across the country. No travel andor telecommuting.

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-12-11

SWA Job Order End Date

2020-01-11

Sunday Edition Newspaper

Y

First Newspaper Name

The Charlotte Observer

First Advertisement Start Date

2019-11-24

Second Newspaper Ad Name

The Charlotte Observer

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-12-01

Employer Website From Date

2019-12-18

Employer Website To Date

2020-01-03

Professional Organization Ad From Date

2020-01-01 08:36:56

Professional Organization Advertisement To Date

2020-01-01 08:36:56

Job Search Website From Date

2019-11-24

Job Search Website To Date

2019-12-12

Employee Referral Program From Date

2020-01-03

Employee Referral Program To Date

2020-01-21

Local Ethnic Paper From Date

2020-01-01 08:36:56

Local Ethnic Paper To Date

2020-01-01 08:36:56

Radio/TV Ad From Date

2020-01-01 08:36:56

Radio/TV Ad To Date

2020-01-01 08:36:56

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

BUSINESS ADMINISTRATION

Foreign Worker Years of Education Completed

2005

Foreign Worker Institution of Education

DEVI AHILYA VISHWAVIDYALAYA

Foreign Worker Education Institution Address 1

NALANDA CAMPUS, R. N. T., RABINDRANATH TAGORE MARG

Foreign Worker Education Institution Address 2

CHHOTI GWALTOLI,

Foreign Worker Education Institution City

INDORE 452001

Foreign Worker Education Institution State/Province

MADHYA PRADESH

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Rajdeep Singh

Preparer Title

Attorney

Preparer Email

dha@dhallc.com

Employer Information Declaration Name

Charudatt M GARUD

Employer Information Declaration Title

Specialist Resourcing