Fiscal Year

2024

Case Number

A-22333-64148

Case Status

Certified-Expired

Received Date

2023-01-26

Decision Date

2024-02-23

Refile

N

Original File Date

2024-01-01 00:47:19

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

52000

Employer Year Commenced Business

1946

NAICS Code

52399

FW Ownership Interest

N

Employer Contact Name

Christina Jackson

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

(800) 835-5099

Employer Contact Email

christina.jackson@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

P10022007816244

PW SOC Code

15-1299.09

PW SOC Title

Information Technology Project Managers

PW Skill Level

N/A

PW Wage

111413.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2022-07-13

PW Expiration Date

2023-06-30

Wage Offer From

120000.00

Wage Offer To

142000.00

Average Salary

131000.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 OBIEE, Informatica, and SQL applications CONTD IN H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

CONTD FROM H.10B in a financial or health care 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 OBIEE, Informatica, and SQL applications in a financial or health care 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 OBIEE, Informatica, and SQL applications in a financial or health care services environment.br br Skills and Knowledgebr br Candidate must also possessbr br Demonstrated Expertise DE performing Business Intelligence BI data warehousing development, using OBIEE 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; creating reports using OBIEE against relational DB and data warehouses; 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 relational databases and OBIEE; writing stored procedures and functions; and performing database releases according to Continuous IntegrationContinuous Delivery CICD practices, using Service Now or UDeploy.br br DE performing PLSQL application development and production deployment; designing and developing backend applications to load data into data warehouses on Oracle, using Oracle PLSQL, and Informatica; 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

2022-09-07

SWA Job Order End Date

2022-10-12

Sunday Edition Newspaper

Y

First Newspaper Name

Raleigh News Observer

First Advertisement Start Date

2022-09-25

Second Newspaper Ad Name

Raleigh News Observer

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-10-02

Employer Website From Date

2022-09-07

Employer Website To Date

2022-10-12

Professional Organization Ad From Date

2024-01-01 00:47:19

Professional Organization Advertisement To Date

2024-01-01 00:47:19

Job Search Website From Date

2022-09-07

Job Search Website To Date

2022-09-21

Employee Referral Program From Date

2022-09-07

Employee Referral Program To Date

2022-09-21

Local Ethnic Paper From Date

2024-01-01 00:47:19

Local Ethnic Paper To Date

2024-01-01 00:47:19

Radio/TV Ad From Date

2024-01-01 00:47:19

Radio/TV Ad To Date

2024-01-01 00:47:19

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

Master's

Foreign Worker Information: Major

COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2010

Foreign Worker Institution of Education

UNIVERSITY OF ILLINOIS

Foreign Worker Education Institution Address 1

ONE UNIVERSITY PLAZA

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

SPRINGFIELD

Foreign Worker Education Institution State/Province

IL

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

62703

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

Christina Jackson

Employer Information Declaration Title

Senior Immigration Specialist