JOHN HANCOCK LIFE INSURANCE COMPANY U.S.A.

Senior Data Engineer - Master Data Management

A-22279-34684 H-1B 2023 Certified

Salary

$164,091

Visa Type

H-1B

Job Title

Senior Data Engineer - Master Data Management

Employee's Citizenship

INDIA

Graduate School

VELLORE INSTITUTE OF TECHNOLOGY

Case info Company Info HR Info Attorney Position Info Employee Info

Case info

9 fields

Data Publish Year 2023

Case Number A-22279-34684

Case Status Certified

Received Date 2022-10-11

Decision Date 2023-08-25

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 JOHN HANCOCK LIFE INSURANCE COMPANY U.S.A.

Employer Address_Line 1 JOHN HANCOCK PLACE

Employer Address_Line 2 P.O. BOX 111

Employer City BOSTON

State -

Employer State/ Province MASSACHUSETTS

Employer Country UNITED STATES OF AMERICA

Employer Postal Code 2117

Employer Phone No. 617-572-6000

Employer Phone Extent No. -

Total Number of Employees 4580

Employer Year of Commenced 1887

NAICS Code 524113

Foreign Worker Ownership & Interest N

HR Info

9 fields

Employer Contact Name Corrine L Weber

Employer Contact Address Line1 John Hancock Place

Employer Contact Address Line2 P.O. Box 111

Employer Contact City Boston

Employer Contact State/ Provice MASSACHUSETTS

Employer Contact Country UNITED STATES OF AMERICA

Employer Contact Post Code 2117

Employer Contact Phone 617-572-7665

Employer Contact Email clweber@jhancock.com

Attorney

11 fields

Agent/ Attorney Name William L Coffman

Agent/ Attorney Firm Name Mintz Levin Cohn Ferris Glovsky Popeo PC

Agent/ Attorney Phone 6175426000

Agent/ Attorney Phone Ext. -

Agent/ Attorney Address Line 1 One Financial Center

Agent/ Attorney Address Line 2 Floor 41

Agent/ Attorney City Boston

Agent/ Attorney State/ Province MASSACHUSETTS

Agent/ Attorney Country UNITED STATES OF AMERICA

Agent/ Attorney Postal Code 2111

Agent/ Attorney Email wlcoffman@mintz.com

Position Info

89 fields

Prevailing Wage Track Number P10022011821647

Prevailing Wage SOC Code 15-1243.01

Prevailing Wage SOC Title Data Warehousing Specialists

Prevailing Wage Skill Level Level IV

Prevailing Wage 164091

Prevailing Wage Unit of Pay Year

Prevailing Wage Source OES

Prevailing Wage Other Source -

Prevailing Wage Determination Date 2022-07-19

Prevailing Wage Expiration Date 2023-06-30

Wage Offer From 164091

Wage Offer To -

Wage Offer Unit of Pay Year

Workstie Address Line 1 200 Berkeley Street

Worksite Address Line 2 -

Worksite City Boston

Worksite State MASSACHUSETTS

Worksite Postal Code 2116

Job Title Senior Data Engineer - Master Data Management

Minimum Education Bachelor's

Other Degree/ Diploma -

Major Field of Study Computer Science, Computer Engineering, Electronic Engineering, Information Systems or related field

Required Training N

Required Training Month -

Required Field of Training -

Required Experience N

Required Expreience Months -

Accept Alternate Field of Study N

Accept Alternate Major -

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 Any information technology position that meets the requirements listed in H.14

Normal Requirements of Job Opportunity N

Required Foreign Language N

Specific Skills All Requirementsbr br Bachelors degree or foreign equivalent in Computer Science, Computer Engineering, Electronic Engineering, Information Systems or related field and 5 years experience in an information technology position. Experience must includebr br 5 years experience with Master Data Management MDM using IBM Infosphere MDM;br 5 years experience performance tuning of Probabilistic matching engine used by IBM MDM, SQL queries, Informatica mappings, etc.;br 5 years experience with Azure cloud platforms, event streaming platforms and Kubernetes and containerization of services;br 4 years experience with database design and development experience using DB2, SQL and PLSQL Database Objects, Oracle, MS SQL server, Metadata API and developing and maintaining application and DB security features;br 4 years experience with data quality including data profiling, data analysis and data cleansing and standardization techniques using IBM infosphere Information server tools;br 4 years experience mentoring a team of developers;br 2 years experience with IBM platform technologies;br 2 years experience with modern software architectures and APIdriven development;br 2 years experience with front end design and integration with reference data management and data quality and address verification interface frameworks;br 2 years experience with Informatica;br 2 years experience with data warehousing technologies;br 2 years experience with scripting languages.br Experience may be gained concurrently.

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-08-04

Job Oder End Date 2022-09-06

Sunday Edition Newspaper Y

First Newspaper Name The Boston Globe

First Advertisement Start Date 2022-08-14

Second Newspaper Name The Boston Globe

Second Advertisement Type Newspaper

Second Ad Start Date 2022-08-21

Job Fair From Date -

Job Fair to Date -

On Campus Recruiting from Date -

On Campus Recruiting to Date -

Employer Website from Date 2022-08-04

Employer Website to Date 2022-09-06

Pro. Org. Ad from Date -

Pro.Org. Ad to Date -

Job Search Website from Date 2022-08-04

Job Search Website to Date 2022-09-06

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-08-15

Local Ethnic Newspaper to Date 2022-08-15

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 ELECTRONIC ENGINEERING

Year of Compelted Education 2005

Foreign Worker Istitution of Eduation VELLORE INSTITUTE OF TECHNOLOGY

Foreign Worker Education Instution Address Line 1 VIT, VELLORE CAMPUS, TIRUVALAM ROAD, KATPADI

Foreign Worker Education Institution Address Line 2 -

Foreign Worker Education Institution City VELLORE

Foreign Worker Educatution Institution State TAMIL NADU

Foreign Worker Education Institution Country INDIA

Foreign Worker Education Training Post Code 632014

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 William L Coffman

Preparer Title Attorney

Preparer Email wlcoffman@mintz.com

Employer Information Declaration Name Phil Colby

Employer Declaration Title Director IT People Leader