Fiscal Year

2022

Case Number

A-21190-14998

Case Status

Certified-Expired

Received Date

2021-07-14

Decision Date

2022-01-04

Refile

N

Original File Date

2022-01-01 10:42:07

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

360training.com

Employer Name Slug

360trainingcom

Employer Address 1

6801 North Capital of Texas Highway Building 1

Employer Address 2

Suite 250

Employer City

Austin

Employer City Slug

austin

Employer State

TEXAS

Employer State Slug

texas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

78731

Employer Phone

512-236-5475

Employer Number of Employees

50

Employer Year Commenced Business

1997

NAICS Code

611430

FW Ownership Interest

N

Employer Contact Name

Mohammed Itratullah

Employer Contact Address 1

6801 North Capital of Texas Highway Building 1

Employer Contact Address 2

Suite 250

Employer Contact City

Austin

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

78731

Employer Contact Phone

512-236-5475

Employer Contact Email

mohammed.itratullah@360training.com

Agent Attorney Name

Wen Chen

Agent Attorney Firm Name

Azarmehr Law Group

Agent Attorney Phone

5127320555

Agent Attorney Address 1

2720 BEE CAVES RD

Agent Attorney Address 2

Agent Attorney City

AUSTIN

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

78746

Agent Attorney Email

wen@algvisas.com

PW Track Number

P10020168658856

PW SOC Code

15-1199

PW SOC Title

Data Warehouse Engineer

PW Skill Level

Level IV

PW Wage

102606.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-11-24

PW Expiration Date

2021-06-30

Wage Offer From

102606.00

Wage Offer To

0.00

Average Salary

102606.00

Wage Unit of Pay

Year

Worksite Address 1

6801 N Capital of Texas Highway Building 1

Worksite Address 2

Suite 250

Worksite City

Austin

Worksite City Slug

austin

Worksite State

TEXAS

Worksite Postal Code

78731

Job Title

Data Warehouse Engineer

Job Title Slug

data-warehouse-engineer

Minimum Education

Bachelor's

Major Field of Study

Information Technology, Science or Engineering

Required Training

N

Required Experience

Y

Required Experience Months

60

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

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors Degree in Information Technology, Science or Engineering;br Minimum of 5 years of experience in collecting and translating the business requirements and creating architectural designs that may include logical design, IO design, data modeling, data schema design and implementation;br Minimum of 5 years of experience in core Azure services related to data and analytics and deploying Azure components using PowerShell Scripting, Azure ARM Templates;br Minimum 5 years of experience in creating ETL involving heterogeneous data sources IBM DB2, SQL Server, MySQL, Excel files, CSVs, Azure Blobs, XML, JSON, etc. using SQL Server Integration Services, Azure Data Factories, Data Flows, Logic Apps, Azure Functions, calling REST APIs;br Minimum 3 years of experience in Shell Scripting to perform DBA tasks and OS related tasks such as automated monitoring file systems;br Minimum 3 years of experience maintaining SQL database backups and other maintenance jobs, performing ad hoc backup and restores, troubleshooting and optimizing problematic SQL queries, Query Optimization by Indexing, Partitioning and Denormalization;br Minimum 5 years of handson experience designing and developing new reports creating data driven subscriptions, maintaining, and enhancing existing reports using SQL Server Reporting Services, creating excel reports sourcing data from Azure Data Warehouse.br Minimum 5 years of experience with Agile development methodology and familiarity with tools such as Atlassian JIRA, Confluence is desired.

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-01-26

SWA Job Order End Date

2021-03-02

Sunday Edition Newspaper

Y

First Newspaper Name

Austin AmericanStatesman

First Advertisement Start Date

2021-02-07

Second Newspaper Ad Name

Austin AmericanStatesman

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-02-14

Employer Website From Date

2021-01-26

Employer Website To Date

2021-03-02

Professional Organization Ad From Date

2022-01-01 10:42:07

Professional Organization Advertisement To Date

2022-01-01 10:42:07

Job Search Website From Date

2021-01-26

Job Search Website To Date

2021-03-02

Employee Referral Program From Date

2022-01-01 10:42:07

Employee Referral Program To Date

2022-01-01 10:42:07

Local Ethnic Paper From Date

2022-01-01 10:42:07

Local Ethnic Paper To Date

2022-01-01 10:42:07

Radio/TV Ad From Date

2022-01-01 10:42:07

Radio/TV Ad To Date

2022-01-01 10:42:07

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

1995

Foreign Worker Institution of Education

PT. RAVISHANKAR SHUKLA UNIVERSITY, RAIPUR

Foreign Worker Education Institution Address 1

GREAT EASTERN RD, AMANAKA

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

RAIPUR

Foreign Worker Education Institution State/Province

CHHATTISGARH

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

492010

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Wen Chen

Preparer Title

Associate Attorney

Preparer Email

wen@algvisas.com

Employer Information Declaration Name

Venkat Gaddipati

Employer Information Declaration Title

Chief Technology Officer