Fiscal Year

2022

Case Number

A-21220-28642

Case Status

Certified

Received Date

2021-10-04

Decision Date

2022-04-13

Refile

N

Original File Date

2022-01-01 11:15:29

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

INGRAM MICRO

Employer Name Slug

ingram-micro

Employer Address 1

3351 MICHELSON DRIVE, SUITE 100

Employer Address 2

Employer City

IRVINE

Employer City Slug

irvine

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

92612

Employer Phone

714/566-1000

Employer Number of Employees

35000

Employer Year Commenced Business

1989

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Lisa Chan

Employer Contact Address 1

3351 Michelson Drive, Suite 100

Employer Contact Address 2

Employer Contact City

Irvine

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

92612

Employer Contact Phone

714-382-1377

Employer Contact Email

lisa.chan@ingrammicro.com

Agent Attorney Name

Blake G Miller

Agent Attorney Firm Name

FRAGOMEN, DEL REY, BERNSEN LOEWY, LLP

Agent Attorney Phone

9492610209

Agent Attorney Address 1

18401 Von Karman Ave.

Agent Attorney Address 2

Ste. 255

Agent Attorney City

Irvine

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

92612

Agent Attorney Email

BMiller@fragomen.com

PW Track Number

P10021014014037

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

109595.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-07-07

PW Expiration Date

2022-06-30

Wage Offer From

109595.00

Wage Offer To

149100.00

Average Salary

129347.50

Wage Unit of Pay

Year

Worksite Address 1

3351 Michelson Drive

Worksite Address 2

Suite 100

Worksite City

Irvine

Worksite City Slug

irvine

Worksite State

CALIFORNIA

Worksite Postal Code

92612

Job Title

Data Engineer

Job Title Slug

data-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

Y

Required Experience Months

60

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Engineering, Business Information Systems, Science and Math or related field

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

60

Accept Alternative Job Title

Data Warehousing, Business Intelligence andor Data Engineering or related occupation.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must possess expertise knowledge sufficient to adequately perform the duties of the job being offered. Expertise knowledge may be gained through employment experience or education. Such expertise knowledge cannot be quot;quantifiedquot; by quot;time.quot; Any suitable combination of education, training or experience is acceptable. Required expertise knowledge includes Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling. Extensive knowledge of Data Warehouse Business Intelligence Architecture, Data Integration ETL processes, and Databases. Experience with Tier 1 applications, databases, and data warehouses such as Oracle, Sybase IQ, MS SQL Server, SAP BW, AWS RedShift, and Informatica. Expertise on ETL such as Informatica, SAP Data Services, Microsoft SSIS, and other, data model design, and BI tools such as SAP Business Objects, SAP Lumira, MicroStrategy, Qlik, or other. Full end to end Integration and Business Intelligence Implementation project and support experience to Order to Cash, Finance, Procure to Pay, and Supply Chain Execution. Experience in Systems developments and implementation in online interactive systems. Understanding new technology and applications of same. Knowledge of new technologies and provide formal technology evaluations and proposals.br br Also, must have years of work experience with 3 Experience and knowledge of tools and platforms AWS EMR, S3, EC2, Redshift, Lambda Glacier, Informatica, and other Data Warehousing technologies. 5 Experience in Programming languages and not limited to SQL, Unix, Python Programming for Data Integration, Transformation, and Logic. 5 Business process and Data acumen especially in Finance and manufacturingsupply chain for Design and Analysis in Data Warehousing. 3 Experience with Global Data Warehousing development and Migration to Cloud SaaS. 3 years of experience of working in system design, development, support, and Data Warehousing and Business Intelligence.br br This position requires a Bachelors Degree in Computer Science, Engineering, Business Information Systems, Science and Math in or related field and 5 years of work experience in Data Warehousing, Business Intelligence andor Data Engineering or related occupation.br br 20 International travel for Projects and Support Knowledge Transfer as required.

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

SWA Job Order End Date

2021-08-14

Sunday Edition Newspaper

Y

First Newspaper Name

Los Angeles Times

First Advertisement Start Date

2021-07-18

Second Newspaper Ad Name

Los Angeles Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-25

Employer Website From Date

2022-01-01 11:15:29

Employer Website To Date

2022-01-01 11:15:29

Professional Organization Ad From Date

2022-01-01 11:15:29

Professional Organization Advertisement To Date

2022-01-01 11:15:29

Job Search Website From Date

2021-07-20

Job Search Website To Date

2021-07-26

Employee Referral Program From Date

2021-07-15

Employee Referral Program To Date

2021-07-29

Local Ethnic Paper From Date

2021-07-26

Local Ethnic Paper To Date

2021-07-26

Radio/TV Ad From Date

2022-01-01 11:15:29

Radio/TV Ad To Date

2022-01-01 11:15:29

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

ELECTRONIC ENGINEERING

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

ANNA UNIVERSITY

Foreign Worker Education Institution Address 1

12, SARDAR PATEL RD

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

BLAKE G MILLER

Preparer Title

PARTNER

Preparer Email

BMILLER@FRAGOMEN.COM

Employer Information Declaration Name

LISA CHAN

Employer Information Declaration Title

Sr. HR Coordinator