OPTUM SERVICES, INC.

Manager, Data Engineering

A-22202-92692 H-1B 2023 Certified
Salary

$152,256

Visa Type

H-1B

Job Title

Manager, Data Engineering

Employee's Citizenship

INDIA

Graduate School

PT. RAVISHANKAR SHUKLA UNIVERSITY

Case info

9 fields
Data Publish Year 2023
Case Number A-22202-92692
Case Status Certified
Received Date 2022-08-18
Decision Date 2023-06-12
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 OPTUM SERVICES, INC.
Employer Address_Line 1 11000 OPTUM CIRCLE
Employer Address_Line 2 -
Employer City EDEN PRAIRIE
State -
Employer State/ Province MINNESOTA
Employer Country UNITED STATES OF AMERICA
Employer Postal Code 55344
Employer Phone No. (952) 936-1616
Employer Phone Extent No. -
Total Number of Employees 350000
Employer Year of Commenced 2013
NAICS Code 541512
Foreign Worker Ownership & Interest N

HR Info

9 fields
Employer Contact Name Ciaran J McDonnell
Employer Contact Address Line1 9900 Bren Road East
Employer Contact Address Line2 -
Employer Contact City Minnetonka
Employer Contact State/ Provice MINNESOTA
Employer Contact Country UNITED STATES OF AMERICA
Employer Contact Post Code 55343
Employer Contact Phone (952) 936-1616
Employer Contact Email ciaran_mcdonnell@uhg.com

Attorney

11 fields
Agent/ Attorney Name Courtney Lewis
Agent/ Attorney Firm Name Berry Appleman Leiden LLP
Agent/ Attorney Phone (469) 290-9510
Agent/ Attorney Phone Ext. -
Agent/ Attorney Address Line 1 2400 N Glenville Drive
Agent/ Attorney Address Line 2 Building A
Agent/ Attorney City Richardson
Agent/ Attorney State/ Province TEXAS
Agent/ Attorney Country UNITED STATES OF AMERICA
Agent/ Attorney Postal Code 75082
Agent/ Attorney Email clewis@BAL.com

Position Info

89 fields
Prevailing Wage Track Number P10021112249419
Prevailing Wage SOC Code 11-3021
Prevailing Wage SOC Title Computer and Information Systems Managers
Prevailing Wage Skill Level Level IV
Prevailing Wage 152256
Prevailing Wage Unit of Pay Year
Prevailing Wage Source OES
Prevailing Wage Other Source -
Prevailing Wage Determination Date 2021-09-27
Prevailing Wage Expiration Date 2022-06-30
Wage Offer From 152256
Wage Offer To -
Wage Offer Unit of Pay Year
Workstie Address Line 1 210 Westwood Place
Worksite Address Line 2 Ste 400
Worksite City Brentwood
Worksite State TENNESSEE
Worksite Postal Code 37027
Job Title Manager, Data Engineering
Minimum Education Bachelor's
Other Degree/ Diploma -
Major Field of Study See H.14
Required Training N
Required Training Month -
Required Field of Training -
Required Experience Y
Required Expreience Months 96
Accept Alternate Field of Study Y
Accept Alternate Major See H.14
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 96
Accept Alternate Job Title See H.14
Normal Requirements of Job Opportunity N
Required Foreign Language N
Specific Skills Bachelors degree in Information Technology, Computer Engineering, Date Warehouse Engineer, Data Engineer, Data Manager AND Eight 8 years of experience in the job offered or related occupation.br br Applicants must have demonstrated experience withbr Data Warehouse architecture, design, dimensional modeling and development of data structures in OLTP or OLAP architecture in MS SQL Server Environment.br Data Warehouse Extract Transform and Load ETL Design and Development using Microsoft TSQL andor Oracle PLSQL based SQL stored procedures.br Extracting data from disparate sources and transform using Microsoft SSIS or similar ETL tools like Informatica, or Talend.br Designing and developing reports sourcing data from Data Warehouse using reporting tools like MS SQL Server Reporting Services SSRS within a healthcare settingbr Designing and developing OLAP solution using tool like Microsoft SQL Server Analysis Services SSAS Performance tuning and optimizing ETLData Warehouse code in form of SQL queries or PLSQL stored procedures.br Designing and developing dashboards for business decision support using Visual Analytics tools like Power BI or Tableau within a healthcare setting. Create and maintain source code versioning using source control tool such as TFS or Subversion.br Working in both Agile and Waterfall methodologies in all phases of Software Development Life Cycle SDLC using tools like AtlassianJira, AtlassianConfluence or VersionOne.br br Any suitable combination of education, training, or experience is acceptable.
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-06-14
Job Oder End Date 2022-07-19
Sunday Edition Newspaper Y
First Newspaper Name Tennessean
First Advertisement Start Date 2022-06-19
Second Newspaper Name Tennessean
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 -
Employer Website to Date -
Pro. Org. Ad from Date 2022-06-15
Pro.Org. Ad to Date 2022-06-22
Job Search Website from Date 2022-06-15
Job Search Website to Date 2022-06-22
Private Employment Firm from Date -
Pricate Employment Firm to Date -
Employee Referral Program from Date -
Employee Referral Program to Date -
Campus Placement from Date -
Campus Placement to Date -
Local Ethnic Newspaper from Date 2022-06-23
Local Ethnic Newspaper to Date 2022-06-29
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 COMPUTER ENGINEERING
Year of Compelted Education 2007
Foreign Worker Istitution of Eduation PT. RAVISHANKAR SHUKLA UNIVERSITY
Foreign Worker Education Instution Address Line 1 GREAT EASTERN RD, AMANAKA
Foreign Worker Education Institution Address Line 2 -
Foreign Worker Education Institution City RAIPUR
Foreign Worker Educatution Institution State CH
Foreign Worker Education Institution Country INDIA
Foreign Worker Education Training Post Code 492010
Foreign Worker Training Completion N/A
Foreign Worker Required Experience N
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 Courtney Lewis
Preparer Title Associate Attorney
Preparer Email clewis@BAL.com
Employer Information Declaration Name CiaranJennifer McDonnellPriebe
Employer Declaration Title Immigration Team Leaders