Others
Scheduled A Sheepherder
N
Employer Phone
312-732-2655
Employer Number of Employees
256981
Employer Year of Commenced Business
1838
Employer Contact Name
Jennifer R Shapiro
Employer Contact Address 1
10 South Dearborn Street
Employer Contact Address 2
IL10801
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Postal Code
60603
Employer Contact Phone
312-732-2655
Agent Attorney Phone
(212) 230-2877
Prevailing Wage Tracking Number
P10019309128211
Prevailing Wage Determination Date
3/2/20
Prevailing Wage Expiration Date
6/30/20
Minimum Education
Bachelor's
Major Field Of Study
Computer Science, Engineering (any), or 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
60
Alternate Occupation Job Title
Please see Section H.14.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Must have demonstrated knowledge of data warehousing methodologies and Big Data technologies, including Hadoop, Spark, Hive, and Impala. Must have demonstrated knowledge of ETL Extract, Transform and Load methodologies to handle large volumes of data and Tableau dashboarding. Must have demonstrated knowledge of Scala and Python. Must have experience with Unix. Must have experience with relational database management system RDBMS in Oracle, SQL, and PLSQL. Must have experience with software development life cycle SDLC processes. Employer will accept any amount of professional experience with the required skills.br br Continued from Section H.10B. Minimum experience required 5 years of application development experience using data warehousing, ETL, and Big Data technologies, or related experience.
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
6/26/20
SWA Job Order End Date
7/30/20
Sunday Edition News Paper
Y
First News Paper Name
The Philadelphia Inquirer
First Advertisement Start Date
7/12/20
Second News Paper Ad Name
The Philadelphia Inquirer
Second Advertisement Type
Newspaper
Second Ad Start Date
7/19/20
Job Search Website From Date
7/13/20
Job Search Webiste To Date
7/20/20
Local Ethnic Paper From Date
7/16/20
Local Ethnic Paper To Date
7/16/20
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
Y
US Workers Considered
N/A
Foreign Worker Birth Country
INDIA
Foreign Worker Education
Bachelor's
Foreign Worker INFO Major
ELECTRONIC ENGINEERING
Foreign Worker Education Completed
2007
Foreign Worker Educational Institution
PUNJAB TECHNICAL UNIVERSITY
Foreign Worker Educational Institution Address 1
BABA BANDA SINGH BAHADUR ENGINEERING COLLEGE
Foreign Worker Educational Institution Address 2
CHANDIGARH ROAD
Foreign Worker Educational Institution City
FATEHGARH SAHIB
Foreign Worker Educational Institution State
PUNJAB
Foreign Worker Educational Institution Country
INDIA
Foreign Worker Educational Institution Postal Code
140407
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
Y
Employer Completed Application
N
Preparer Name
Jenny Nieves
Name Of Person Signing Employer Declaration
Jennifer Shapiro
Title of Person Signing Employer Declaration
Attorney in Fact Executive Director