Fiscal Year

2023

Case Number

A-21319-72917

Case Status

Certified

Received Date

2022-02-23

Decision Date

2022-11-15

Refile

N

Original File Date

2023-01-01 18:11:15

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

FMR LLC

Employer Name Slug

fmr-llc

Employer Address 1

245 SUMMER STREET

Employer Address 2

Employer City

BOSTON

Employer City Slug

boston

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

2210

Employer Phone

617-563-6780

Employer Number of Employees

40000

Employer Year Commenced Business

1946

NAICS Code

523999

FW Ownership Interest

N

Employer Contact Name

Erin Garlock

Employer Contact Address 1

100 New Millennium Way

Employer Contact Address 2

Employer Contact City

Durham

Employer Contact State/Province

NORTH CAROLINA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

27709

Employer Contact Phone

919-458-3184

Employer Contact Email

HRImmigrat@fmr.com

Agent Attorney Name

Russell B Swapp

Agent Attorney Firm Name

Seyfarth Shaw LLP

Agent Attorney Phone

(617) 946-4905

Agent Attorney Address 1

2 Seaport Lane Seaport East

Agent Attorney Address 2

Suite 1200

Agent Attorney City

Boston

Agent Attorney State/Province

MASSACHUSETTS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

2210

Agent Attorney Email

dlsmith@seyfarth.com

PW Track Number

P10021085177930

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

N/A

PW Wage

106400.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2022-01-04

PW Expiration Date

2022-06-30

Wage Offer From

119350.00

Wage Offer To

142000.00

Average Salary

130675.00

Wage Unit of Pay

Year

Worksite Address 1

100300 New Millennium Way

Worksite Address 2

Worksite City

Durham

Worksite City Slug

durham

Worksite State

NORTH CAROLINA

Worksite Postal Code

27709

Job Title

Principal Software Engineer/Developer

Job Title Slug

principal-software-engineerdeveloper

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Engineering, Information Technology

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Information Systems, Mathematics, Physics, or a closely related field

Accept Alternative Combination

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

3

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Job offered or implementing Oracle PLSQL, Informatica, and CONTD IN H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

CONTD FROM H.10B Java applications in a financial services environment.br br Education and Experiencebr br Bachelors degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five 5 years of experience in the job offered or five 5 years of experience implementing Oracle PLSQL, Informatica, and Java applications in a financial services environment.br br Or, alternatively, Masters degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three 3 years of experience in the job offered or three 3 years of experience implementing Oracle PLSQL, Informatica, and Java applications in a financial services environment.br br Skills and Knowledgebr br Candidate must also possessbr br Demonstrated Expertise DE performing business intelligence data warehousing development, using Oracle and Informatica; analyzing data formulas within a Database DB calculation engine using SQL; writing SQL queries and scripts to extract data from large data sets within relational database environments; writing stored procedures to insert and maintain data, using Informatica and Oracle PLSQL; and performing data transformations using Informatica.br br DE performing relational and dimensional data modeling and analysis of datasets for DB data services using Informatica; performing database creation and ETL design according to DB data conversion standards, using, Oracle and SQL; and translating business requirements into technical designs in a fastpaced Agile delivery model.br br DE extracting data from data stores and flat files and loading it into relational database environments Oracle; copying data to reporting relation databases, using Informatica Power Center, and stored procedures and functions; scheduling and executing batch jobs using ControlM; and performing database releases according to Continuous IntegrationContinuous Delivery CICD practices, using Service Now and UDeploy.br br DE performing PLSQL application development and live production deployment; designing and developing backend applications to load data into data warehouses on Oracle, using Oracle PLSQL, Informatica, and Java; designing and developing ControlM jobs to automate and schedule endtoend processes; and finetuning SQL queries to optimize application performance.

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-10-22

SWA Job Order End Date

2021-11-29

Sunday Edition Newspaper

Y

First Newspaper Name

Raleigh News Observer

First Advertisement Start Date

2021-11-14

Second Newspaper Ad Name

Raleigh News Observer

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-11-21

Employer Website From Date

2021-10-22

Employer Website To Date

2021-11-29

Professional Organization Ad From Date

2023-01-01 18:11:15

Professional Organization Advertisement To Date

2023-01-01 18:11:15

Job Search Website From Date

2021-10-22

Job Search Website To Date

2021-11-05

Employee Referral Program From Date

2021-10-22

Employee Referral Program To Date

2021-11-05

Local Ethnic Paper From Date

2023-01-01 18:11:15

Local Ethnic Paper To Date

2023-01-01 18:11:15

Radio/TV Ad From Date

2023-01-01 18:11:15

Radio/TV Ad To Date

2023-01-01 18:11:15

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

INFORMATION TECHNOLOGY

Foreign Worker Years of Education Completed

2009

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY

Foreign Worker Education Institution Address 2

KUKATPALLY

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Russell B Swapp

Preparer Title

Attorney

Preparer Email

dlsmith@seyfarth.com

Employer Information Declaration Name

Erin Garlock

Employer Information Declaration Title

Immigration Services Lead