For visitors, travel, student and other international travel medical insurance.

Visit insubuy.com or call +1 (866) INSUBUY or +1 (972) 985-4400

Greencard Sponsors

Greencard Sponsors Case Details

Certified-Expired
360TRAINING COM (Austin, TEXAS)
Job Title: Data Warehouse Engineer
Wage Rate: $102,606.00
Employer Business Identification
Employer Name
360TRAINING COM
Fiscar Year
2022
Case Status
Certified-Expired
Case Number
A-21190-14998
Received Date
7/14/21
2007 NAICS US Code
611430
Job Title
Data Warehouse Engineer
Country of Citizenship
INDIA
Prevailing Wage Information
SOC Code
15-1199
Level
Level IV
Wage Rate
102606.0
SOC Title
Data Warehouse Engineer
Source
OES
Wage Rate & Work Location
Wage Rate
$102,606.00 per year
City
Austin
State
TEXAS
Contact & Attorney Information
Attorney Firm Name
Azarmehr Law Group
Attorney Name
Wen Chen
Attorney Location
AUSTIN, TEXAS
Others
Decision Date
1/4/22
Refile
N
Scheduled A Sheepherder
N
Employer Phone
512-236-5475
Employer Number of Employees
50
Employer Year of Commenced Business
1997
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 Postal Code
78731
Employer Contact Phone
512-236-5475
Employer Contact Email
[email protected]
Agent Attorney Phone
(512) 732-0555
Agent Attorney Phone Extension
112
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10020168658856
Prevailing Wage Determination Date
11/24/20
Prevailing Wage Expiration Date
6/30/21
Minimum Education
Bachelor's
Major Field Of Study
Information Technology, Science or Engineering
Required Training
N
Required Expirence Months
60
Required Expirence
Y
Acceptable Alternate Field Of Study
N
Acceptable Alternate Combination
N
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
N
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 of Occupations
N
Offered To Foreign Worker
Y
Foreign Worker live in Employer Premises
N
Live-in Domestic Service Worker
N
Professional Occupation
Y
College or University Teacher
N
SWA Job Order Start Date
1/26/21
SWA Job Order End Date
3/2/21
Sunday Edition News Paper
Y
First News Paper Name
Austin AmericanStatesman
First Advertisement Start Date
2/7/21
Second News Paper Ad Name
Austin AmericanStatesman
Second Advertisement Type
Newspaper
Second Ad Start Date
2/14/21
Job Search Website From Date
1/26/21
Job Search Webiste To Date
3/2/21
Campus Placement From Date
1/26/21
Campus Placement To Date
3/2/21
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
INDIA
Class Of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker INFO Major
COMPUTER SCIENCE
Foreign Worker Education Completed
1995
Foreign Worker Educational Institution
PT. RAVISHANKAR SHUKLA UNIVERSITY, RAIPUR
Foreign Worker Educational Institution Address 1
GREAT EASTERN RD, AMANAKA
Foreign Worker Educational Institution City
RAIPUR
Foreign Worker Educational Institution State
CHHATTISGARH
Foreign Worker Educational Institution Country
INDIA
Foreign Worker Educational Institution Postal Code
492010
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
Y
Foreign Worker Alternate Education/Experience
N/A
Foreign Worker Has Experience in Alternate Occupation
N/A
Foreign Worker Experience With Employer
N
Employer Paid For Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Wen Chen
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Venkat Gaddipati
Title of Person Signing Employer Declaration
Chief Technology Officer

Insurance