All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22091-34671
Fiscal year: 2023
Fiscal Year
2023
Case Number
A-22091-34671
Case Status
Certified
Received Date
2022-04-01
Decision Date
2022-12-28
Refile
N
Original File Date
2023-01-01 17:57:38
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
EVICORE HEALTHCARE MSI, LLC DBA EVICORE HEALTHCARE
Employer Name Slug
evicore-healthcare-msi-llc-dba-evicore-healthcare
Employer Address 1
400 BUCKWALTER PLACE BOULEVARD
Employer Address 2
Employer City
BLUFFTON
Employer City Slug
bluffton
Employer State
SOUTH CAROLINA
Employer State Slug
south-carolina
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
29910
Employer Phone
800-918-8924
Employer Number of Employees
74000
Employer Year Commenced Business
1994
NAICS Code
541611
FW Ownership Interest
N
Employer Contact Name
Mayur Gandhi
Employer Contact Address 1
730 Cool Springs Boulevard
Employer Contact Address 2
Suite 800
Employer Contact City
Franklin
Employer Contact State/Province
TENNESSEE
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
37067
Employer Contact Phone
800-918-8924
Employer Contact Email
Mayur.Gandhi@evicore.com
Agent Attorney Name
Jack Doebley
Agent Attorney Firm Name
Landau, Hess, Simon, Choi Doebley
Agent Attorney Phone
215-925-0705
Agent Attorney Address 1
190 N. Independence Mall W.
Agent Attorney Address 2
Ste 602
Agent Attorney City
Philadelphia
Agent Attorney State/Province
PENNSYLVANIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
19106
Agent Attorney Email
jdoebley@lhscimmigration.com
PW Track Number
P10021078160623
PW SOC Code
15-1199
PW SOC Title
Data Warehousing Specialists
PW Skill Level
Level III
PW Wage
67267.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-10-06
PW Expiration Date
2022-06-30
Wage Offer From
67267.00
Wage Offer To
102500.00
Average Salary
84883.50
Wage Unit of Pay
Year
Worksite Address 1
730 Cool Springs Boulevard
Worksite Address 2
Ste. 800
Worksite City
Franklin
Worksite City Slug
franklin
Worksite State
TENNESSEE
Worksite Postal Code
37067
Job Title
SQL Data Warehouse Operations Engineer
Job Title Slug
sql-data-warehouse-operations-engineer
Minimum Education
Master's
Major Field of Study
Computer science, physics, management information systems, or closely related field
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
Bachelor's
Accept Alternative Combination Education Years
5
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
36
Accept Alternative Job Title
Database software development
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Must have experience with Writing SQL queries and complex SQL stored procedures; Performance tuning within SQL code; Extraction, Transformation, and Loading using SSIS package; Bulk Copy Program BCP process; SSIS ETL, SSAS, SSRS, data warehousing, data store, and data mining; Building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction; Development toolsapplications, including GitHub, TFS, Azure DevOps, RedGate tools, Visual Studio, and MS SQL server.br br NORE RE Section 8 AC Employer will accept a bachelors or foreign equivalent degree in computer science, physics, management information systems, or closely related field plus five years of progressive experience in database software development.
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-08
SWA Job Order End Date
2021-11-08
Sunday Edition Newspaper
Y
First Newspaper Name
The Tennessean
First Advertisement Start Date
2021-10-24
Second Newspaper Ad Name
The Tennessean
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-10-31
Employer Website From Date
2023-01-01 17:57:38
Employer Website To Date
2023-01-01 17:57:38
Professional Organization Ad From Date
2023-01-01 17:57:38
Professional Organization Advertisement To Date
2023-01-01 17:57:38
Job Search Website From Date
2021-10-27
Job Search Website To Date
2021-11-23
Employee Referral Program From Date
2023-01-01 17:57:38
Employee Referral Program To Date
2023-01-01 17:57:38
Local Ethnic Paper From Date
2021-10-29
Local Ethnic Paper To Date
2021-11-04
Radio/TV Ad From Date
2023-01-01 17:57:38
Radio/TV Ad To Date
2023-01-01 17:57:38
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
PHYSICS
Foreign Worker Years of Education Completed
2004
Foreign Worker Institution of Education
ACHARYA NAGARJUNA UNIVERSITY
Foreign Worker Education Institution Address 1
NH16, NAGARJUNA NAGAR
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
GUNTUR
Foreign Worker Education Institution State/Province
ANDHRA PRADESH
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
522510
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jack Doebley
Preparer Title
Attorney
Preparer Email
jdoebley@lhscimmigration.com
Employer Information Declaration Name
Mayur Gandhi
Employer Information Declaration Title
Software Engineering Senior Manager