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
416 932 4380
Prevailing Wage Tracking Number
P10021197466238
Prevailing Wage Determination Date
12/20/21
Prevailing Wage Expiration Date
6/30/22
Minimum Education
Bachelor's
Major Field Of Study
Comp Sci, Tech, Comp Info Sys, Comp Apps, Engr, or related field
Required Expirence Months
60
Acceptable Alternate Field Of Study
Y
Acceptable Alternate Major Field Of Study
Comp Sci, Tech, Comp Info Sys, Comp Apps, Engr, or related field
Acceptable Alternate Combination
N
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
60
Alternate Occupation Job Title
Any in which reqd experience is gained
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Must have a bachelors degree in Computer Science, Technology, Computer Information Systems, Computer Applications, Engineering, or related field, plus 5 years of progressive postbaccalaureate experience in the IT consulting industry.br br Must have 3 years of experience in each of the followingbr br Working in DevOps or Agile methodology;br Data integration using Extract, Transform, Load tool, Ab Initio, including Load Data from Multiple Sources, Data warehouse, Data mart, and Operational data store;br Analytics SQL Structured Query Languagebr Utilizing SQL database, including Teradata, DB2, Oracle, and SQL Server;br Technical delivery project management, including and operating delivery in Waterfall and Agile methodology;br Utilizing JSON, Shell, and Unix scripting;br Developing largescale ETL data from multiple data sources using Data tools and SQL tools;br Managing and maintaining ETL cluster nodes health and application support issues;br Capacity planning; andbr Execute continuous improvements to improve application performance, stability, and reduce ongoing performance issues.br br Must have willingness and ability to travel domestically approximately 80 of the time to meet client needs.
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
11/1/21
SWA Job Order End Date
12/6/21
Sunday Edition News Paper
Y
First News Paper Name
Chicago Tribune
First Advertisement Start Date
10/31/21
Second News Paper Ad Name
Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
11/7/21
Job Search Website From Date
10/29/21
Job Search Webiste To Date
11/11/21
Local Ethnic Paper From Date
11/1/21
Local Ethnic Paper To Date
11/1/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
Foreign Worker Education
Bachelor's
Foreign Worker INFO Major
COMPUTER ENGINEERING
Foreign Worker Education Completed
2015
Foreign Worker Educational Institution
VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELGAUM
Foreign Worker Educational Institution Address 1
JNANA SANGAMA, VTU MAIN RD., MACHHE
Foreign Worker Educational Institution City
BELAGAVI
Foreign Worker Educational Institution State
KARNATAKA
Foreign Worker Educational Institution Country
INDIA
Foreign Worker Educational Institution Postal Code
590018
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N
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
Y
Employer Completed Application
N
Preparer Name
Rene M CAMPBELL
Name Of Person Signing Employer Declaration
Margot BERRY
Title of Person Signing Employer Declaration
People Mobility Manager