Agent/ Attorney Firm Name:Fragomen, Del Rey, Bernsen Loewy LLP
Agent/ Attorney Phone:732-862-5000
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:90 Matawan Road
Agent/ Attorney Address Line 2:4th Floor
Agent/ Attorney City:Matawan
Agent/ Attorney State/ Province:NEW JERSEY
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:7747
Agent/ Attorney Email:wralston@fragomen.com
Position Info
Prevailing Wage Track Number:P10020259824883
Prevailing Wage SOC Code :15-1132
Prevailing Wage SOC Title :Software Developers, Applications
Prevailing Wage Skill Level:N/A
Prevailing Wage:101871
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:Other
Prevailing Wage Other Source:US MBD MERCER/GARTNER - 8/26/2020
Prevailing Wage Determination Date :2021-01-14
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:101871
Wage Offer To:131580
Wage Offer Unit of Pay:Year
Workstie Address Line 1:300 East 5th Avenue
Worksite Address Line 2:Suite # 201
Worksite City :Naperville
Worksite State:ILLINOIS
Worksite Postal Code:60563
Job Title:Developer
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Computer Science, Engineering, Mathematics, 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:N
Accept Alternate Major:
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :Master's
Other Alternate Level of Education:
Acceptable Years of Experience:2
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:60
Accept Alternate Job Title:Will accept any suitable combination of education, training or experience
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Experience must involve 2 years in the following Architect SQL server Tables and establish relations Data Modelling, data conversions, Data Normalization, Entity Relationship Models; Database design using SQL server, Design Tables, indexes, views, establish relationships using SAP HANA; Design functionalities and creating solutions using SQL; SQL Server Database upgrades, SQL server data center migration, SQL server database migration to SAP HANA which involves rewriting scripts from SQL to SAP HANA; Design physical and logical database models using MS Visio, Erwin, IBM Infosphere; Performance Tuning and Optimization of queries using SQL Server Profiler, Execution Plans in SSMS; Data Transformation, Data cleansing, Error Handling using DTS, SSIS packages; Advanced SQL server concepts Window functions, ranking functions, math functions, String manipulations, aggregations, rollups which are useful in handling transactions; Complex TSQL Queries and SQL Programming extensively using Stored Procedures, Joins, Cursors, CTEs, Exception Handling, Dynamic SQL; Data Analysis, Data Validations, data preprocessing, create data sets, reports using SQL; Develop PowerShell scripts to automate processjobs; Develop Drill down, Tabular reports, monthly usage based reports using SQL programming, SSRS, PowerPivot; Object Oriented Programming skills using C#.net, Java; Troubleshooting issues using SQL Management Studio, Visual Studio, SSIS processes and SQL Agents; Debug code to fix bugs using IntelliJ; Run DBCC checks and fix data corruption in SQL server databases; Perform testing by developing test scripts using SQL to ensure data integrity such that financial target values does not mismatch; Resolve production issues and monitor status using various Ticketing tools such as CCM, JIRA; and Implement userbased security by creating roles, mapping users to roles using SQL Server thereby enforcing data security.
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-02-16
Job Oder End Date:2021-03-23
Sunday Edition Newspaper:Y
First Newspaper Name:Chicago Tribune
First Advertisement Start Date:2021-02-21
Second Newspaper Name:Chicago Tribune
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-02-28
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-02-11
Employer Website to Date:2021-03-25
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-02-11
Job Search Website to Date:2021-02-16
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-02-11
Employee Referral Program to Date:2021-03-25
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:
Local Ethnic Newspaper to Date:
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
Foreign Worker Education:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:INFORMATION TECHNOLOGY
Year of Compelted Education:2010
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/A
Foreign Worker Alternate Education and Experience :N
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:C. William Ralston
Preparer Title:Senior Associate
Preparer Email :wralston@fragomen.com
Employer Information Declaration Name:Kirste Meyers Davis
Employer Declaration Title:Senior Manager, Local HR Services Americas
