Fiscal Year

2020

Case Number

A-19211-37078

Case Status

Certified-Expired

Received Date

2019-10-25

Decision Date

2020-03-25

Refile

N

Original File Date

2020-01-01 07:44:53

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

SVB FINANCIAL GROUP

Employer Name Slug

svb-financial-group

Employer Address 1

3003 TASMAN DRIVE

Employer Address 2

Employer City

SANTA CLARA

Employer City Slug

santa-clara

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

95054

Employer Phone

408-654-7400

Employer Number of Employees

1741

Employer Year Commenced Business

1983

NAICS Code

522110

FW Ownership Interest

N

Employer Contact Name

Claudia Derp

Employer Contact Address 1

3003 TASMAN DRIVE

Employer Contact Address 2

Employer Contact City

SANTA CLARA

Employer Contact State/Province

CALIFORNIA CA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

95054

Employer Contact Phone

408-654-5553 408

Employer Contact Email

CDerp@svb.com

Agent Attorney Name

Jennifer M Chan

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

415-228-3939

Agent Attorney Address 1

555 Mission Street

Agent Attorney Address 2

Suite 900

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94105

Agent Attorney Email

jenniferchan@balglobal.com

PW Track Number

P10018351729118

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analysts

PW Skill Level

Level IV

PW Wage

139277.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-04-12

PW Expiration Date

2019-07-11

Wage Offer From

147825.00

Wage Offer To

167825.00

Average Salary

157825.00

Wage Unit of Pay

Year

Worksite Address 1

3003 Tasman Drive

Worksite Address 2

Worksite City

Santa Clara

Worksite City Slug

santa-clara

Worksite State

CALIFORNIA

Worksite Postal Code

95054

Job Title

Principal Data Warehouse Lead

Job Title Slug

principal-data-warehouse-lead

Minimum Education

Bachelor's

Major Field of Study

Engineering

Required Training

N

Required Experience

Y

Required Experience Months

132

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

132

Accept Alternative Job Title

related capacityies

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Bachelors degree in Engineering, followed by 11 years of professional experience in the job offered or related capacityies. Experience must includebr br 1. Data Warehouse concepts and implementationbr 2. Combined ETL, Data Warehousing, Business Intelligence related DW BI experiencebr 3. Leading ETL teams, allocatingreviewingevaluating team deliverables and provide feedbackbr 4. Training, mentoring and guiding the ETL team in solution development, ensuring team deliverables adhere to ETL standards and code best practicesbr 5. Business Objects Data Services or equivalent ETL tool Informatica, Datastage SAS Data Integration Studio andor Talend Big Data Studiobr 6. Designing near realtime EDW solutions, extracting data from conventional and Cloud data sourcesbr 7. Big Data solution area Hadoop HDFS, HBASE, Hive andor Spark, Data Lake, Data Ingestion, MapReduce andor stream processingbr 8. Handson knowledge and experience in Source data analysis, Solution Designing, Model and build high volume, scalable and reliable EDW solutionsbr 9. Architecting ETL solution, perform requirement analysis, applications systems design, ETL performance tuning, integration, micro design creation and with detailed understanding of applicable programming methodologiesbr 10. SQL, Oracle PLSQL, Unix andor Linux with shell scripting experiencebr 11. Developing BI ReportsCubes, performing project gap analysis, managing quality metadata and experience in using data modeling tools like ERWINbr 12. Performing project migration, DSNODBC configuration, hotfixpatching and license auditsbr 13. Utilizing or managing job scheduling tools such as Redwood Cronacle, UC4, UNIX andor Datastage Director

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-05-24

SWA Job Order End Date

2019-06-25

Sunday Edition Newspaper

Y

First Newspaper Name

The Mercury News

First Advertisement Start Date

2019-06-30

Second Newspaper Ad Name

The Mercury News

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-07-07

Employer Website From Date

2019-05-01

Employer Website To Date

2019-07-19

Professional Organization Ad From Date

2020-01-01 07:44:53

Professional Organization Advertisement To Date

2020-01-01 07:44:53

Job Search Website From Date

2019-05-24

Job Search Website To Date

2019-06-20

Employee Referral Program From Date

2020-01-01 07:44:53

Employee Referral Program To Date

2020-01-01 07:44:53

Local Ethnic Paper From Date

2019-07-12

Local Ethnic Paper To Date

2019-07-12

Radio/TV Ad From Date

2020-01-01 07:44:53

Radio/TV Ad To Date

2020-01-01 07:44:53

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

CHEMICAL ENGINEERING

Foreign Worker Years of Education Completed

2005

Foreign Worker Institution of Education

ANNA UNIVERSITY

Foreign Worker Education Institution Address 1

COIMBATORE INSTITUTE OF TECHNOLOGY

Foreign Worker Education Institution Address 2

AVINASHI ROAD CIVIL AERODROME POST, PEELAMEDU

Foreign Worker Education Institution City

COIMBATORE

Foreign Worker Education Institution State/Province

TAMILNADU

Foreign Worker Education Institution Country

Foreign Worker Education Institution Postal Code

641014

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jennifer M Chan

Preparer Title

Associate

Preparer Email

jenniferchan@balglobal.com

Employer Information Declaration Name

Bryan Larson

Employer Information Declaration Title

Staffing Program Manager