All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19339-91177
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-19339-91177
Case Status
Certified-Expired
Received Date
2019-12-18
Decision Date
2020-10-16
Refile
N
Original File Date
2021-01-01 08:46:21
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
SILLIKER INC.
Employer Name Slug
silliker-inc
Employer Address 1
401 N. MICHIGAN AVENUE
Employer Address 2
STE. 1400
Employer City
CHICAGO
Employer City Slug
chicago
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60611
Employer Phone
312-938-5151
Employer Number of Employees
1132
Employer Year Commenced Business
1967
NAICS Code
541380
FW Ownership Interest
N
Employer Contact Name
Corrine Castillo
Employer Contact Address 1
111 E. Wacker Drive
Employer Contact Address 2
Ste. 2300
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60601
Employer Contact Phone
312-938-5219
Employer Contact Email
corrine.castillo@mxns.com
Agent Attorney Name
Stephen M Hader
Agent Attorney Firm Name
Moore Van Allen, PLLC
Agent Attorney Phone
704-331-1139
Agent Attorney Address 1
100 North Tryon Street
Agent Attorney Address 2
Suite 4700
Agent Attorney City
Charlotte
Agent Attorney State/Province
NORTH CAROLINA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
28202
Agent Attorney Email
shader@mvalaw.com
PW Track Number
P10019114058693
PW SOC Code
15-1199
PW SOC Title
Computer Occupations, All Other
PW Skill Level
Level I
PW Wage
58552.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-08-08
PW Expiration Date
2020-06-30
Wage Offer From
120000.00
Wage Offer To
0.00
Average Salary
120000.00
Wage Unit of Pay
Year
Worksite Address 1
111 E. Wacker Drive
Worksite Address 2
Suite 2300
Worksite City
Chicago
Worksite City Slug
chicago
Worksite State
ILLINOIS
Worksite Postal Code
60601
Job Title
ETL Data Analyst
Job Title Slug
etl-data-analyst
Minimum Education
None
Major Field of Study
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
N
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
Technical Consultant, Senior Project Lead
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
experience and expertise in ETL architecture for integrating data at real time and batch processing to EDW and complex PL SQL solutions to migrate large volumes of data to new servers. Requires handson experience in design, development, testing, implementation for data conversion, transformation, integration tasks; translating business requirements into technical specifications for EDW; system studyanalysis for Star Schema with fact and dimension tables; data modeling for staging, transition, production warehouses; PLSQL stored procedures; shell scripting; source systems such as Flat files, Oracle; ODI 11g, Pentaho Data Integration tools. Employer will accept any suitable combination of education, training or experience.
Combination Occupation
N
Offered to Applicant Foreign Worker
Y
Foreign Worker Live on Premises
N
Foreign Worker Live in Domestic Service
N
Foreign Worker Live in Domestic Service Count
Professional Occupation
Y
Application for College/University Teacher
N
SWA Job Order Start Date
2019-09-30
SWA Job Order End Date
2019-10-31
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago SunTimes
First Advertisement Start Date
2019-10-06
Second Newspaper Ad Name
Chicago SunTimes
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-10-13
Employer Website From Date
2019-10-01
Employer Website To Date
2019-10-17
Professional Organization Ad From Date
2021-01-01 08:46:21
Professional Organization Advertisement To Date
2021-01-01 08:46:21
Job Search Website From Date
2019-10-07
Job Search Website To Date
2019-10-21
Employee Referral Program From Date
2021-01-01 08:46:21
Employee Referral Program To Date
2021-01-01 08:46:21
Local Ethnic Paper From Date
2019-10-09
Local Ethnic Paper To Date
2019-10-09
Radio/TV Ad From Date
2021-01-01 08:46:21
Radio/TV Ad To Date
2021-01-01 08:46:21
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
Foreign Worker Education
None
Foreign Worker Information: Major
Foreign Worker Years of Education Completed
Foreign Worker Institution of Education
Foreign Worker Education Institution Address 1
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
Foreign Worker Education Institution State/Province
Foreign Worker Education Institution Country
Foreign Worker Education Institution Postal Code
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
N
Employer Completed Application
N
Preparer Name
Stephen M Hader
Preparer Title
Member
Preparer Email
shader@mvalaw.com
Employer Information Declaration Name
Corrine Castillo
Employer Information Declaration Title
Corporate Recruiter