DEERE COMPANY
Software Engineer - Reporting & Analytics
A-22262-23651
H-1B
2023
Certified
Salary
$117,374
Visa Type
H-1B
Job Title
Software Engineer - Reporting & Analytics
Employee's Citizenship
INDIA
Graduate School
CHICAGO STATE UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22262-23651
Case Status
Certified
Received Date
2022-09-19
Decision Date
2023-07-05
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
DEERE COMPANY
Employer Address_Line 1
ONE JOHN DEERE PLACE
Employer Address_Line 2
-
Employer City
MOLINE
State
-
Employer State/ Province
ILLINOIS
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
61265
Employer Phone No.
309-765-4160
Employer Phone Extent No.
-
Total Number of Employees
75550
Employer Year of Commenced
1837
NAICS Code
333111
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Jennifer M Casey
Employer Contact Address Line1
Deere Company
Employer Contact Address Line2
1300 River Drive, Suite 200
Employer Contact City
Moline
Employer Contact State/ Provice
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
61265
Employer Contact Phone
309-765-5603
Employer Contact Email
CaseyJenniferM@JohnDeere.com
Attorney
11 fields
Agent/ Attorney Name
Susie Shin
Agent/ Attorney Firm Name
Zulkie Partners LLC
Agent/ Attorney Phone
(312) 831-2127
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
135 South La Salle Street
Agent/ Attorney Address Line 2
Ste. 3425
Agent/ Attorney City
Chicago
Agent/ Attorney State/ Province
ILLINOIS
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
60603
Agent/ Attorney Email
sshin@zulkiepartners.com
Position Info
89 fields
Prevailing Wage Track Number
P10021335735343
Prevailing Wage SOC Code
15-1132
Prevailing Wage SOC Title
Software Developers, Applications
Prevailing Wage Skill Level
Level IV
Prevailing Wage
117374
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-06-06
Prevailing Wage Expiration Date
2022-09-04
Wage Offer From
120000
Wage Offer To
130000
Wage Offer Unit of Pay
Year
Workstie Address Line 1
1400 13th Street
Worksite Address Line 2
-
Worksite City
East Moline
Worksite State
ILLINOIS
Worksite Postal Code
61244
Job Title
Software Engineer - Reporting & Analytics
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
Computer Science or 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
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
Data Analyst or related position
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
Required skills Develop SSIS ETL packages 1 yr; Work on PowerBI to transform the PDF format reports to the dashboard visualizations 1 yr; Work on Azure DevOps 1 yr; MigrateCreate On #x13; Prem CRDM reports from SSRS reports to Power BITableau dashboards 1 yr; Create Database views, accounts and user roles and permissions on SQL Servers 1 yr; Work on Improving Performance of ETL packages by SQL query tuning 1 yr; Maintain and integrate SQL Server databases 1 yr; Develop ETL framework and pipelines using Azure Data Factory ADF on Microsoft Azure DevOps cloud technology Azure DevOps, ADF and Maintained SQL Server jobs in Cisco Tidal 2 yrs; Develop dashboards and multiple reports using Microsoft Power BI, DAX 1 yr.
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-27
Job Oder End Date
2022-08-01
Sunday Edition Newspaper
Y
First Newspaper Name
The QuadCity Times
First Advertisement Start Date
2022-07-03
Second Newspaper Name
The QuadCity Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-07-10
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
2022-06-19
Employer Website to Date
2022-08-19
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-06-20
Job Search Website to Date
2022-08-19
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
2022-06-19
Employee Referral Program to Date
2022-08-19
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
24 fields
Foreign Worker Education
Master's
Foreign Worker Education Other
-
Foreign Worker Major
COMPUTER SCIENCE
Year of Compelted Education
2015
Foreign Worker Istitution of Eduation
CHICAGO STATE UNIVERSITY
Foreign Worker Education Instution Address Line 1
9501 S. KING DRIVE
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
CHICAGO
Foreign Worker Educatution Institution State
IL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code
60628
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
Susie Shin
Preparer Title
Principal
Preparer Email
sshin@zulkiepartners.com
Employer Information Declaration Name
Cindy P Savely
Employer Declaration Title
Mobility Rep