Fiscal Year

2022

Case Number

A-21273-52653

Case Status

Certified

Received Date

2021-10-12

Decision Date

2022-04-13

Refile

N

Original File Date

2022-01-01 11:15:34

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ATOS SYNTEL INC

Employer Name Slug

atos-syntel-inc

Employer Address 1

4851 REGENT BLVD

Employer Address 2

Employer City

IRVING

Employer City Slug

irving

Employer State

TEXAS

Employer State Slug

texas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

75063

Employer Phone

2486193580

Employer Number of Employees

2974

Employer Year Commenced Business

2019

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Anand Ramanathan

Employer Contact Address 1

525 East Big Beaver Road

Employer Contact Address 2

Suite 300

Employer Contact City

Troy

Employer Contact State/Province

MICHIGAN

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

48083

Employer Contact Phone

2486193580

Employer Contact Email

odccoreteam@atos.net

Agent Attorney Name

Alex C Farris

Agent Attorney Firm Name

Ogletree Deakins

Agent Attorney Phone

8132217254

Agent Attorney Address 1

100 North Tampa Street

Agent Attorney Address 2

Suite 3600

Agent Attorney City

Tampa

Agent Attorney State/Province

FLORIDA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

33602

Agent Attorney Email

alex.farris@ogletreedeakins.com

PW Track Number

P10020254815034

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

113027.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-04-02

PW Expiration Date

2021-07-01

Wage Offer From

113027.00

Wage Offer To

0.00

Average Salary

113027.00

Wage Unit of Pay

Year

Worksite Address 1

4851 Regent Blvd.

Worksite Address 2

Worksite City

Irving

Worksite City Slug

irving

Worksite State

TEXAS

Worksite Postal Code

75063

Job Title

ETL & Database Developer

Job Title Slug

etl-database-developer

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Information Technology, Engineering (any), or related.

Required Training

N

Required Experience

Y

Required Experience Months

72

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

72

Accept Alternative Job Title

Experience designing and developing information systems, or related.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Six 6 years of required experience designing and developing information systems must include 6 years of experience in ETL tools such as Informatica, DataStage, Talend Pentaho data extraction or manipulation tool. Experience must also include Utilized partitioning, transformations, incremental caching in Informatica toolset; Experience in slowly changing dimensions in Informatica; Experience in join logic and query optimization in Informatica; Experience with stored procedures, Triggers, PLSQL in Oracle; Experience writing efficient analytic and windowing functions in Oracle; Experience writing SQL queries against any RDBMS with query optimization; Experience analyzing and troubleshooting; Experience with DevOps processes including CICD and infrastructure as code fundamentals; Utilized unit testing, software change management, and software release management; Experience with the star schema and data models in the existing data warehouse; Experience in capturing and synthesizing business requirements; Experience with Unix and Linux operating systems, basic shell scripting, and database programming using SQL.br br ROVINGTELECOMMUTING EMPLOYEE Reports to company headquarters in Irving, TX. Will work at various unknown client sites throughout the U.S. for up to 100 of the time. Must be willing to travel anywhere in the U.S. and may be assigned to work at client sites across the U.S. Can work remotely or telecommute.

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-28

SWA Job Order End Date

2021-08-02

Sunday Edition Newspaper

Y

First Newspaper Name

The Dallas Morning News

First Advertisement Start Date

2021-06-20

Second Newspaper Ad Name

The Dallas Morning News

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-06-27

Employer Website From Date

2021-06-28

Employer Website To Date

2021-09-23

Professional Organization Ad From Date

2022-01-01 11:15:34

Professional Organization Advertisement To Date

2022-01-01 11:15:34

Job Search Website From Date

2021-06-25

Job Search Website To Date

2021-07-08

Employee Referral Program From Date

2022-01-01 11:15:34

Employee Referral Program To Date

2022-01-01 11:15:34

Local Ethnic Paper From Date

2021-06-26

Local Ethnic Paper To Date

2021-06-26

Radio/TV Ad From Date

2022-01-01 11:15:34

Radio/TV Ad To Date

2022-01-01 11:15:34

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

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

MINING ENGINEERING

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

ANNA UNIVERSITY CHENNAI

Foreign Worker Education Institution Address 1

ANNA UNIVERSITY, GUINDY

Foreign Worker Education Institution Address 2

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

Alex C Farris

Preparer Title

Attorney

Preparer Email

alex.farris@ogletreedeakins.com

Employer Information Declaration Name

Anand Ramanathan

Employer Information Declaration Title

SpecialistGlobal ImmigrationHR