AETNA RESOURCES, LLC

Advisor, Data Engineering

A-22230-08371 H-1B 2023 Certified

Salary

$107,557

Visa Type

H-1B

Job Title

Advisor, Data Engineering

Employee's Citizenship

INDIA

Graduate School

GURU GHASIDAS UNIVERSITY

Case info Company Info HR Info Attorney Position Info Employee Info

Case info

9 fields

Data Publish Year 2023

Case Number A-22230-08371

Case Status Certified

Received Date 2022-08-22

Decision Date 2023-05-24

Refile N

Original File Date -

Previous State Work Force Agency (SWA) Case Number Stete -

Schedule A or a Sheepherder Occupation N

Company Info

14 fields

Employer Name AETNA RESOURCES, LLC

Employer Address_Line 1 1 CVS DRIVE

Employer Address_Line 2 -

Employer City WOONSOCKET

State -

Employer State/ Province RHODE ISLAND

Employer Country UNITED STATES OF AMERICA

Employer Postal Code 2895

Employer Phone No. 8008723862

Employer Phone Extent No. -

Total Number of Employees 300000

Employer Year of Commenced 1853

NAICS Code 524114

Foreign Worker Ownership & Interest N

HR Info

9 fields

Employer Contact Name Paul R Messenger

Employer Contact Address Line1 1 CVS Drive

Employer Contact Address Line2 -

Employer Contact City Woonsocket

Employer Contact State/ Provice RHODE ISLAND

Employer Contact Country UNITED STATES OF AMERICA

Employer Contact Post Code 2895

Employer Contact Phone 401-770-1621

Employer Contact Email Paul.Messenger@CVSHealth.com

Attorney

11 fields

Agent/ Attorney Name Amanda R Goodman

Agent/ Attorney Firm Name Ogletree, Deakins, Nash, Smoak Stewart, P.C.

Agent/ Attorney Phone 512-344-4707

Agent/ Attorney Phone Ext. -

Agent/ Attorney Address Line 1 301 Congress Avenue

Agent/ Attorney Address Line 2 Suite 1150

Agent/ Attorney City Austin

Agent/ Attorney State/ Province TEXAS

Agent/ Attorney Country UNITED STATES OF AMERICA

Agent/ Attorney Postal Code 78701

Agent/ Attorney Email amanda.goodman@ogletreedeakins.com

Position Info

89 fields

Prevailing Wage Track Number P10021271612059

Prevailing Wage SOC Code 15-1199

Prevailing Wage SOC Title Database Architects

Prevailing Wage Skill Level Level IV

Prevailing Wage 107557

Prevailing Wage Unit of Pay Year

Prevailing Wage Source OES

Prevailing Wage Other Source -

Prevailing Wage Determination Date 2022-05-09

Prevailing Wage Expiration Date 2022-08-07

Wage Offer From 131300

Wage Offer To -

Wage Offer Unit of Pay Year

Workstie Address Line 1 151 Farmington Avenue

Worksite Address Line 2 -

Worksite City Hartford

Worksite State CONNECTICUT

Worksite Postal Code 6156

Job Title Advisor, Data Engineering

Minimum Education Bachelor's

Other Degree/ Diploma -

Major Field of Study Information Technology

Required Training N

Required Training Month -

Required Field of Training -

Required Experience N

Required Expreience Months -

Accept Alternate Field of Study Y

Accept Alternate Major Software Engineering. See H14.

Alternate Combination of Education/ Experience N

Required Alternate Level of Education -

Other Alternate Level of Education -

Acceptable Years of Experience -

Accept Foreign Educationa Y

Acceptable Alternate Occupation Y

Acceptable Alternate Occupation Month 60

Accept Alternate Job Title See H.14

Normal Requirements of Job Opportunity N

Required Foreign Language N

Specific Skills Bachelors degree or foreign equivalent in Information Technology, Computer Science, Software Engineering, Electronics Engineering, Engineering, or a related field, and five 5 years of progressive postbaccalaureate experience with manipulating and analyzing large data sets from multiple data sources. Position also requires two 2 years of experience with each of the following Hadoop andor HDFS; Sqoop; development of extract, transform and load ETL pipelines using SQL andor HQL; Git and shell scripting; and Python or Scala.br br Employer will accept any suitable combination of education, training or experience.

Combination Occupation N

Offered to Applied Foreign Worker Y

ForeignWorker Live on Premises N

Live in Domestic Service Worker N

Employment Contract -

Professional Occupation Y

College/ University Teacher N

Competitive Process -

Basic Recruitment Process -

Teacher Select Date -

Teacher Publish Journal Name -

Additional Recruitment Information -

Job Oder Start Date 2022-05-23

Job Oder End Date 2022-06-26

Sunday Edition Newspaper Y

First Newspaper Name Hartford Courant

First Advertisement Start Date 2022-06-19

Second Newspaper Name Hartford Courant

Second Advertisement Type Newspaper

Second Ad Start Date 2022-06-26

Job Fair From Date -

Job Fair to Date -

On Campus Recruiting from Date -

On Campus Recruiting to Date -

Employer Website from Date 2022-05-30

Employer Website to Date 2022-07-01

Pro. Org. Ad from Date -

Pro.Org. Ad to Date -

Job Search Website from Date 2022-06-17

Job Search Website to Date 2022-07-01

Private Employment Firm from Date -

Pricate Employment Firm to Date -

Employee Referral Program from Date 2022-05-30

Employee Referral Program to Date 2022-07-01

Campus Placement from Date -

Campus Placement to Date -

Local Ethnic Newspaper from Date -

Local Ethnic Newspaper to Date -

Radio/TV Ad from Date -

Radio/TV Ad to Date -

Employer Received the Payment N

Payment Details -

Bargaining Representative Notified N/A

Posted Notice at Worksite Y

Layoff in Past Six Months N

US Worker Considered -

Country of Citizenship INDIA

Foreign Worker Birth Country INDIA

Class of Admission H-1B

Employee Info

24 fields

Foreign Worker Education Bachelor's

Foreign Worker Education Other -

Foreign Worker Major INFORMATION TECHNOLOGY

Year of Compelted Education 2008

Foreign Worker Istitution of Eduation GURU GHASIDAS UNIVERSITY

Foreign Worker Education Instution Address Line 1 C.G., KONI

Foreign Worker Education Institution Address Line 2 -

Foreign Worker Education Institution City BILASPUR

Foreign Worker Educatution Institution State CHHATTISGARH

Foreign Worker Education Institution Country INDIA

Foreign Worker Education Training Post Code 495009

Foreign Worker Training Completion N/A

Foreign Worker Required Experience N/A

Foreign Worker Alternate Education and Experience N/A

Foreign Worker Alternate Occupation Experience Y

Foreign Worker Experience with Employer N

Foreign Worker Employer Pay for Education N

Foreign Worker Currently Employed Y

Employer Completed Application N

Preparer Name Amanda R Goodman

Preparer Title Of Counsel

Preparer Email amanda.goodman@ogletreedeakins.com

Employer Information Declaration Name Paul R Messenger

Employer Declaration Title Immigration Program Lead, HRSS TA Ops