All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-22101-39146

Fiscal year: 2024

Fiscal Year

2024

Case Number

A-22101-39146

Case Status

Certified-Expired

Received Date

2022-07-11

Decision Date

2023-10-19

Refile

N

Original File Date

2024-01-01 00:07:47

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

OCHSNER CLINIC FOUNDATION

Employer Name Slug

ochsner-clinic-foundation

Employer Address 1

1514 JEFFERSON HIGHWAY

Employer Address 2

Employer City

NEW ORLEANS

Employer City Slug

new-orleans

Employer State

LOUISIANA

Employer State Slug

louisiana

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

70121

Employer Phone

504-842-7898

Employer Number of Employees

34000

Employer Year Commenced Business

2001

NAICS Code

622110

FW Ownership Interest

N

Employer Contact Name

Sandra Hartley

Employer Contact Address 1

1514 Jefferson Highway

Employer Contact Address 2

Employer Contact City

New Orleans

Employer Contact State/Province

LOUISIANA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

70121

Employer Contact Phone

504-842-7898

Employer Contact Email

sahartley@ochsner.org

Agent Attorney Name

Jeremy S Zollinger

Agent Attorney Firm Name

Zollinger Immigration

Agent Attorney Phone

504-881-1300

Agent Attorney Address 1

1100 Poydras Street

Agent Attorney Address 2

Suite 1485

Agent Attorney City

New Orleans

Agent Attorney State/Province

LOUISIANA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

70163

Agent Attorney Email

jzollinger@zollingerlaw.com

PW Track Number

P10021289649314

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialist

PW Skill Level

Level III

PW Wage

64584.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-04-18

PW Expiration Date

2022-07-17

Wage Offer From

77875.00

Wage Offer To

112632.00

Average Salary

95253.50

Wage Unit of Pay

Year

Worksite Address 1

1450 Poydras Street

Worksite Address 2

Worksite City

New Orleans

Worksite City Slug

new-orleans

Worksite State

LOUISIANA

Worksite Postal Code

70112

Job Title

Senior IS Data Integration Developer

Job Title Slug

senior-is-data-integration-developer

Minimum Education

Bachelor's

Major Field of Study

Computer Science or related IT field.

Required Training

N

Required Experience

Y

Required Experience Months

48

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

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

MUST HAVE EITHER A BACHELORS DEGREE IN COMPUTER SCIENCE OR A RELATED IT FIELD AND AT LEAST 4 YEARS OF EXPERIENCE WITH DATA EXTRACTION OR ETL USING AN ENTERPRISE TOOL, SUCH AS INFORMATICA POWERCENTER 9.X, 10.X, INFORMATICA B2B, DATA STAGE, SSIS SQL SERVER INTEGRATION SERVICES, BUSINESS OBJECTS, OBIEE ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION; OR B 7 YEARS OF EXPERIENCE WITH DATA EXTRACTION OR ETL USING AN ENTERPRISE TOOL, SUCH AS INFORMATICA POWERCENTER 9.X, 10.X, INFORMATICA B2B, DATA STAGE, SSIS SQL SERVER INTEGRATION SERVICES, BUSINESS OBJECTS, OBIEE.br EXPERIENCE MUST INCLUDE 3 YEARS OF SQL DEVELOPMENT USING A TOOL LIKE ORACLE SQL DEVELOPER OR TOAD.br EXPERIENCE MUST INCLUDE 1 YEAR OF EXPERIENCE DEVELOPING ON A MASSIVELY PARALLEL PROCESSING MPP DATABASE, SUCH AS NETEZZA DATABASES.br EXPERIENCE MUST INCLUDE 3 YEARS OF SQL EXPERIENCE, DATA ANALYSIS AND DATA PROFILING.

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-01-26

SWA Job Order End Date

2022-02-25

Sunday Edition Newspaper

Y

First Newspaper Name

Times Picayune

First Advertisement Start Date

2022-01-30

Second Newspaper Ad Name

Times Picayune

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-02-06

Employer Website From Date

2022-04-10

Employer Website To Date

2022-05-10

Professional Organization Ad From Date

2024-01-01 00:07:47

Professional Organization Advertisement To Date

2024-01-01 00:07:47

Job Search Website From Date

2022-05-10

Job Search Website To Date

2022-05-10

Employee Referral Program From Date

2024-01-01 00:07:47

Employee Referral Program To Date

2024-01-01 00:07:47

Local Ethnic Paper From Date

2022-02-02

Local Ethnic Paper To Date

2022-02-02

Radio/TV Ad From Date

2024-01-01 00:07:47

Radio/TV Ad To Date

2024-01-01 00:07:47

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

2008

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

F9VR8HZ, ASHOK NAGAR, KUKATPALLY

Foreign Worker Education Institution Address 2

HOUSING BOARD COLONY, 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

Jeremy S Zollinger

Preparer Title

Attorney

Preparer Email

jzollinger@zollingerlaw.com

Employer Information Declaration Name

Sandra P Hartley

Employer Information Declaration Title

Compliance Risk Senior Consultant