Others
Scheduled A Sheepherder
N
Employer Phone
312-693-0161
Employer Number of Employees
50000
Employer Year of Commenced Business
2000
Employer Contact Name
Margot Berry
Employer Contact Address 1
161 North Clark Street
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Postal Code
60601
Employer Contact Phone
512-732-5469
Agent Attorney Phone
(312) 263-6101
Prevailing Wage Tracking Number
P10021118267384
Prevailing Wage Determination Date
10/5/21
Prevailing Wage Expiration Date
6/30/22
Minimum Education
Bachelor's
Major Field Of Study
Computer Science, Information Systems/Technology, Engineering (any), or in a closely related field
Acceptable Alternate Field Of Study
N
Acceptable Alternate Combination
N
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
48
Alternate Occupation Job Title
Technical Lead, System Analyst or in a related IT position
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
This position requires at least a bachelors degree, or its foreign equivalent, in Computer Science, Information SystemsTechnology, Engineering any, or in a closely related field, plus 4 years of experience as a Technical Lead, System Analyst or in a related IT position, including the following experience 4 years of experience in using software engineering practices for Waterfall or Agile methodologies, including Scrum, Kanban, or SAFe leveraging tools such as JIRA to deliver data projects; 4 years of experience in working with ETL Extract, Transform and Load tools such as Informatica, SAS and reporting tools such as Microsoft SSAS and Cognos to lead and manage deliverables for data analytics solution; 4 years of experience with Database such as Teradata or Oracle or DB2 design and architecture to support any new data warehouse implementation on Cloud for insurance applications; 4 years of experience in profiling data and defining data models to meet the business requirements of data analytics solution; 4 years of experience in defining, maintaining and monitoring automated batch schedules to refresh Enterprise Data warehouses and reports using scheduling tools like CA Workstation ESP; 2 years of experience in working with Bigdata sources like Apache HDFS using scripting languages Apache Spark, Python to build analytics reporting solutions for Property and Casualty Insurance applications.
Combination of Occupations
N
Offered To Foreign Worker
Y
Foreign Worker live in Employer Premises
N
Live-in Domestic Service Worker
N
Professional Occupation
Y
College or University Teacher
N
SWA Job Order Start Date
10/19/21
SWA Job Order End Date
11/23/21
Sunday Edition News Paper
Y
First News Paper Name
BOSTON GLOBE
First Advertisement Start Date
10/24/21
Second News Paper Ad Name
BOSTON GLOBE
Second Advertisement Type
Newspaper
Second Ad Start Date
10/31/21
Job Search Website From Date
10/25/21
Job Search Webiste To Date
11/8/21
Local Ethnic Paper From Date
10/29/21
Local Ethnic Paper To Date
10/29/21
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
INDIA
Class Of Admission
Not in USA
Foreign Worker Education
Bachelor's
Foreign Worker INFO Major
COMPUTER ENGINEERING
Foreign Worker Education Completed
2011
Foreign Worker Educational Institution
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Foreign Worker Educational Institution Address 1
ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY, KUKATPALLY
Foreign Worker Educational Institution City
HYDERABAD
Foreign Worker Educational Institution State
TELANGANA
Foreign Worker Educational Institution Country
INDIA
Foreign Worker Educational Institution Postal Code
500085
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N/A
Foreign Worker Alternate Education/Experience
N/A
Foreign Worker Has Experience in Alternate Occupation
Y
Foreign Worker Experience With Employer
N
Employer Paid For Education
N
Foreign Worker Currently Employed
N
Employer Completed Application
N
Preparer Name
Magdalena K Faust
Name Of Person Signing Employer Declaration
Margot Berry
Title of Person Signing Employer Declaration
People Mobility Manager