All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
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