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
P10021113252309
Prevailing Wage Determination Date
9/28/21
Prevailing Wage Expiration Date
6/30/22
Minimum Education
Bachelor's
Major Field Of Study
Computer Science
Required Expirence Months
60
Acceptable Alternate Field Of Study
Y
Acceptable Alternate Major Field Of Study
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
IT Project Manager or related
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 5 years of experience in each of the followingbr br Multidimensional data modeling using LSA, including DataSource enhancements, Advanced DSOs Creation, Cubes, and ETL SAP BODS Business Objects Data Services for the EDW;br Creating data strategies and associated deliverables, including Roadmap, Data Org Design, Data Architecture, and Implementation Plan as part of a formal Data Strategy project and implementing those deliverables as part of a delivery project;br Utilizing at least one of the following ETL technologies Informatica, DataStage, SSIS or Ab Initio;br Managing data loads and building and monitoring process chains; andbr All aspects of the SDLC including requirements, design, development, testing, deployment, and production support.br br Must have 4 years of experience in performing data modeling and in data processes using Oracle and SAP HANA, including Calculation Views, Open ODS Views, or HANA SQL and stored procedures.br br Must have 3 years of experience in performing at least one of the following Data Migration, Data Validation, or Data Cleansing.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/5/21
SWA Job Order End Date
12/10/21
Sunday Edition News Paper
Y
First News Paper Name
Milwaukee Journal Sentinel
First Advertisement Start Date
8/29/21
Second News Paper Ad Name
Milwaukee Journal Sentinel
Second Advertisement Type
Newspaper
Second Ad Start Date
9/5/21
Job Search Website From Date
8/25/21
Job Search Webiste To Date
9/7/21
Local Ethnic Paper From Date
9/10/21
Local Ethnic Paper To Date
9/16/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
MECHANICAL ENGINEERING
Foreign Worker Education Completed
2010
Foreign Worker Educational Institution
PUNJAB TECHNICAL UNIVERSITY
Foreign Worker Educational Institution Address 1
KAPURTHALA HIGHWAY, VPO IBBAN
Foreign Worker Educational Institution City
KAPURTHALA
Foreign Worker Educational Institution State
PUNJAB
Foreign Worker Educational Institution Country
INDIA
Foreign Worker Educational Institution Postal Code
144603
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