Agent/ Attorney Address Line 1:230 W. Monroe Street
Agent/ Attorney Address Line 2:2800
Agent/ Attorney City:Chicago
Agent/ Attorney State/ Province:ILLINOIS
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:60606
Agent/ Attorney Email:ian.love@giafirm.com
Position Info
Prevailing Wage Track Number:P10021055096925
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Database Architects
Prevailing Wage Skill Level:Level II
Prevailing Wage:76045
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-08-11
Prevailing Wage Expiration Date :2022-06-30
Wage Offer From:106605
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:8600 W. Bryn Mawr Ave., S. Tower
Worksite Address Line 2:Suite 800
Worksite City :Chicago
Worksite State:ILLINOIS
Worksite Postal Code:60631
Job Title:Engineer III
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Information Systems or related field
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:Y
Accept Alternate Major:Computer Science or 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:36
Accept Alternate Job Title:Computer Programmer or similar
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Requires a Bachelors degree in Computer Science, Information Systems or a related field, plus 3 years of experience with each of the following analysis, design, development, implementation and support of RDBMS in production, development and test environments using MS SQL and Sybase ASE tools in client server environments; database development activities including purging data older than 3 years and test data deletion during production; release activity for database deployments, environment support, and production deployment support; setting up and implementing database models using Liquibase; designing and modeling functional modules for applications using Enterprise Architect; conceptual modeling and logical modeling using Enterprise Architect; designing, modeling, and mapping using stored procedures; SQL development activity for Batch jobs.
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:2021-09-27
Job Oder End Date:2021-11-01
Sunday Edition Newspaper:Y
First Newspaper Name:Chicago SunTimes
First Advertisement Start Date:2021-10-10
Second Newspaper Name:Chicago SunTimes
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-10-17
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:2021-10-07
Job Search Website to Date:2021-10-21
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-10-11
Local Ethnic Newspaper to Date:2021-10-11
Radio/TV Ad from Date:2021-10-09
Radio/TV Ad to Date:2021-10-10
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
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:INFORMATION SYSTEMS
Year of Compelted Education:2009
Foreign Worker Istitution of Eduation:TEXAS AM INTERNATIONAL UNIVERSITY
Foreign Worker Education Instution Address Line 1:5201 UNIVERSITY BOULEVARD
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:LAREDO
Foreign Worker Educatution Institution State:TX
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:78041
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :N/A
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:Ian M Love
Preparer Title:Attorney
Preparer Email :ian.love@giafirm.com
Employer Information Declaration Name:Dawn R Hanson
