Agent/ Attorney Address Line 1:230 W. Monroe Street
Agent/ Attorney Address Line 2:Suite 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:P10021028039486
Prevailing Wage SOC Code :15-1132
Prevailing Wage SOC Title :Software Developers, Applications
Prevailing Wage Skill Level:Level II
Prevailing Wage:84552
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-07-29
Prevailing Wage Expiration Date :2022-06-30
Wage Offer From:93663
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:5800 Northampton Blvd.
Worksite Address Line 2:
Worksite City :Norfolk
Worksite State:VIRGINIA
Worksite Postal Code:23502
Job Title:Developer Senior
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Computer Science, or a 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:Information Technology, or a related field
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :Master's
Other Alternate Level of Education:
Acceptable Years of Experience:1
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:36
Accept Alternate Job Title:Informatica Developer, or similar
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Requires a Bachelors degree in Computer Science, Information Technology or a related field plus 3 years of experience on one platform, multi database, multi language or multi business application. Additional requirements 3 years of experience with one or more of the following relational database management systems Microsoft SQL Server, Oracle Database, or Teradata. 3 years of experience performing data migration and integration using Informatica. 3 years of experience with SQL scripting. 3 years of experience with data warehouse and table design, creation, and maintenance. 3 years of experience with interpreting performance tuning analyzers, data optimizations, tuning routines, and building indexes. 3 years of experience collaborating with DBAs, other IT professionals, and business partners to ensure design objectives are met. 3 years of experience using MS Excel, MS Word and MS PowerPoint.br br In the alternative, Employer will accept a Masters degree in Computer Science, Information Technology or a related field plus 1 year of experience on one platform, multi database, multi language or multi business application. Additional requirements 1 year of experience with one or more of the following relational database management systems Microsoft SQL Server, Oracle Database, or Teradata. 1 year of experience performing data migration and integration using Informatica. 1 year of experience with SQL scripting. 1 year of experience with data warehouse and table design, creation, and maintenance. 1 year of experience with interpreting performance tuning analyzers, data optimizations, tuning routines, and building indexes. 1 year of experience collaborating with DBAs, other IT professionals, and business partners to ensure design objectives are met. 1 year of experience using MS Excel, MS Word and MS PowerPoint.br br Employer will accept any suitable combination of education and experience as described above in Sections H.4 through H.10.
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-01
Job Oder End Date:2021-10-06
Sunday Edition Newspaper:Y
First Newspaper Name:The Virginian Pilot
First Advertisement Start Date:2021-09-05
Second Newspaper Name:The Virginian Pilot
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-09-12
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-09-02
Job Search Website to Date:2021-09-16
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-09-08
Local Ethnic Newspaper to Date:2021-09-08
Radio/TV Ad from Date:2021-09-04
Radio/TV Ad to Date:2021-09-05
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:COMPUTER SCIENCE
Year of Compelted Education:2016
Foreign Worker Istitution of Eduation:NORTHWESTERN POLYTECHNIC UNIVERSITY
Foreign Worker Education Instution Address Line 1:47671 WESTINGHOUSE DR.
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:FREMONT
Foreign Worker Educatution Institution State:CA
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:94539
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :N/A
Foreign Worker Alternate Education and Experience :Y
Foreign Worker Alternate Occupation Experience:N
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