SILLIKER INC.
Senior Data Analyst/ETL Developer
A-22228-06801
H-1B
2023
Certified
Salary
$111,197
Visa Type
H-1B
Job Title
Senior Data Analyst/ETL Developer
Employee's Citizenship
INDIA
Graduate School
ANNA UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22228-06801
Case Status
Certified
Received Date
2022-08-31
Decision Date
2023-06-16
Refile
N
Original File Date
-
Previous State Work Force Agency (SWA) Case Number Stete
-
Schedule A or a Sheepherder Occupation
N
Company Info
14 fields
Employer Name
SILLIKER INC.
Employer Address_Line 1
401 N. MICHIGAN AVENUE
Employer Address_Line 2
STE. 1400
Employer City
CHICAGO
State
-
Employer State/ Province
ILLINOIS
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60611
Employer Phone No.
312-938-5151
Employer Phone Extent No.
-
Total Number of Employees
1374
Employer Year of Commenced
1967
NAICS Code
541380
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Dalynn Faber
Employer Contact Address Line1
401 N. Michigan Avenue
Employer Contact Address Line2
Ste. 1400
Employer Contact City
Chicago
Employer Contact State/ Provice
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
60611
Employer Contact Phone
312-938-5219
Employer Contact Email
dalynn.faber@mxns.com
Attorney
11 fields
Agent/ Attorney Name
Rita N Georges
Agent/ Attorney Firm Name
Serotte Law Firm LLC
Agent/ Attorney Phone
7168812600
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
370 Franklin Street
Agent/ Attorney Address Line 2
-
Agent/ Attorney City
Buffalo
Agent/ Attorney State/ Province
NEW YORK
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
14202
Agent/ Attorney Email
rgeorges@serottelaw.com
Position Info
89 fields
Prevailing Wage Track Number
P10021317704216
Prevailing Wage SOC Code
15-1121
Prevailing Wage SOC Title
Computer Systems Analysts
Prevailing Wage Skill Level
Level IV
Prevailing Wage
111197
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-05-23
Prevailing Wage Expiration Date
2022-08-21
Wage Offer From
111197
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
401 N. Michigan Avenue
Worksite Address Line 2
Suite 1400
Worksite City
Chicago
Worksite State
ILLINOIS
Worksite Postal Code
60611
Job Title
Senior Data Analyst/ETL Developer
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
Mechanical Engineering
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
Y
Required Expreience Months
60
Accept Alternate Field of Study
Y
Accept Alternate Major
Computer Science, Software Engineering or a closely related field
Alternate Combination of Education/ Experience
N
Required Alternate Level of Education
-
Other Alternate Level of Education
-
Acceptable Years of Experience
-
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
60
Accept Alternate Job Title
Related
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
Experience must have included Use of PostgreSql, SQL Server, ORACLE, and Teradata Databases; Developing ETL jobs on Datastage and Pentaho Data Integration ETL Tools; Conducting unit, functional, regression and integration testing; Data Migration between different databases; Working with UNIX, LINUX and Shell Scripts; Working in Cloud services including Microsoft Azure and Amazon AWS; Use of Version Control tool Github; and Use of Business Intelligence reporting tools including Microstrategy and Tableau.
Combination Occupation
N
Offered to Applied Foreign Worker
Y
ForeignWorker Live on Premises
N
Live in Domestic Service Worker
N
Employment Contract
-
Professional Occupation
Y
College/ University Teacher
N
Competitive Process
-
Basic Recruitment Process
-
Teacher Select Date
-
Teacher Publish Journal Name
-
Additional Recruitment Information
-
Job Oder Start Date
2022-06-13
Job Oder End Date
2022-07-13
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago SunTimes
First Advertisement Start Date
2022-06-19
Second Newspaper Name
Chicago SunTimes
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-06-26
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
-
Employer Website to Date
-
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-06-19
Job Search Website to Date
2022-06-27
Private Employment Firm from Date
2022-06-13
Pricate Employment Firm to Date
2022-06-24
Employee Referral Program from Date
-
Employee Referral Program to Date
-
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
2022-06-24
Local Ethnic Newspaper to Date
2022-06-24
Radio/TV Ad from Date
-
Radio/TV Ad to Date
-
Employer Received the Payment
N
Payment Details
-
Bargaining Representative Notified
N/A
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
US Worker Considered
-
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Employee Info
24 fields
Foreign Worker Education
Bachelor's
Foreign Worker Education Other
-
Foreign Worker Major
MECHANICAL ENGINEERING
Year of Compelted Education
2006
Foreign Worker Istitution of Eduation
ANNA UNIVERSITY
Foreign Worker Education Instution Address Line 1
GUINDY
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
CHENNAI
Foreign Worker Educatution Institution State
TAMIL NADU
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Training Post Code
600025
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N
Foreign Worker Alternate Education and Experience
N/A
Foreign Worker Alternate Occupation Experience
Y
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pay for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Rita N Georges
Preparer Title
Attorney
Preparer Email
perm@serottelaw.com
Employer Information Declaration Name
Dalynn Faber
Employer Declaration Title
Recruiter