Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:Arch Insurance Group Inc.
Employer Address_Line 1:One Liberty Plaza
Employer Address_Line 2:Floor 53
Employer City :New York
State:
Employer State/ Province:NEW YORK
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:10006
Employer Phone No.:6465638532
Employer Phone Extent No.:
Total Number of Employees:1300
Employer Year of Commenced :
NAICS Code:524126
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Kelsey McElroy
Employer Contact Address Line1:One Liberty Plaza
Employer Contact Address Line2:Floor 53
Employer Contact City:New York
Employer Contact State/ Provice:NEW YORK
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:10006
Employer Contact Phone:6465638532
Employer Contact Email:kmcelroy@archinsurance.com
Attorney
Agent/ Attorney Name:Murali Bashyam
Agent/ Attorney Firm Name:Bashyam Shah LLP
Agent/ Attorney Phone:919-833-0840
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:P O Box 2477
Agent/ Attorney Address Line 2:
Agent/ Attorney City:Raleigh
Agent/ Attorney State/ Province:NORTH CAROLINA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:27602
Agent/ Attorney Email:murali@bashyamshah.com
Position Info
Prevailing Wage Track Number:P10020091449395
Prevailing Wage SOC Code :15-1132
Prevailing Wage SOC Title :Software Developers, Applications
Prevailing Wage Skill Level:Level IV
Prevailing Wage:143936
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2020-07-09
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:143936
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:210 Hudson Street, Suite 300
Worksite Address Line 2:
Worksite City :Jersey City
Worksite State:NEW JERSEY
Worksite Postal Code:7311
Job Title:Data Integrator IV
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Computer Science, Business 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:96
Accept Alternate Job Title:related software development experience
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Must havebr 8 years of experience with theoretical and practical application, best practices, methods and techniques pertaining to building Enterprise Data Warehouses, Transactional Data Marts, Data Analysis, BI, and ETL techniques.br 8 years of experience developing software applications on the assigned software platform or technology using At least one of the following Databases MS SQL Server, Oracle, Mongo DB; At least one of the following Reporting BI Tools Tableau, PowerBI, R, Oracle Reports, Crystal Reports, Business Objects, Oracle Business Intelligence Foundation BIDiscoverer, XMLBI Publisher, OBIEE, MS Excel.br 8 years of experience using source code change management and related tools which must include at least one of the following Serena Version Control, MS Visual Source Safe, MS Team Foundation Server, Jira.br 8 years of customer service skills demonstrated by supporting internal business users andor external customers using any communication tools email, phone, video conference, inperson meetings.br 8 years of production support processes including incident and problem management, troubleshooting and resolving production issues.br 8 years of related experience in IT corporate systems environments, which can include global companies andor publicly traded companies.br 8 years of experience in designing and implementing transactional data marts or data warehouse.br 8 years of experience with writing and debugging complex SQL queries.br 8 years of experience working with and managing distributed teams.br 8 years of experience working on multiple projectstasks simultaneously to meet project deadlines as required.br 7 years of experience using Agile software development principles, process and tools which must include at least one of the following AGILE SCRUM, Pair Programming, Scaled Agile SAFe.br 3 years of experience managing complex data environments in a lead role architecting, designing and implementing solutions based on business requirements.
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:2020-09-09
Job Oder End Date:2020-10-11
Sunday Edition Newspaper:Y
First Newspaper Name:The StarLedger
First Advertisement Start Date:2020-10-18
Second Newspaper Name:The StarLedger
Second Advertisement Type:Newspaper
Second Ad Start Date:2020-10-25
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2020-08-19
Employer Website to Date:2020-09-23
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2020-10-13
Job Search Website to Date:2020-10-27
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2020-08-19
Employee Referral Program to Date:2020-09-23
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
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:MANAGEMENT INFORMATION SYSTEMS
Year of Compelted Education:2017
Foreign Worker Istitution of Eduation:STATE UNIVERSITY OF NEW YORK AT BUFFALO
Foreign Worker Education Instution Address Line 1:12 CAPEN HALL
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:BUFFALO
Foreign Worker Educatution Institution State:NY
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:14260
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:Murali BASHYAM
Preparer Title:Attorney of Record
Preparer Email :murali@bashyamshah.com
Employer Information Declaration Name:Kelsey MCELROY
Employer Declaration Title:Human Resources Business Partner
