All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22059-17232
Fiscal year: 2023
Fiscal Year
2023
Case Number
A-22059-17232
Case Status
Certified
Received Date
2022-03-01
Decision Date
2022-11-21
Refile
N
Original File Date
2023-01-01 18:09:25
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ECOLAB INC.
Employer Name Slug
ecolab-inc
Employer Address 1
1 ECOLAB PLACE
Employer Address 2
Employer City
ST.PAUL
Employer City Slug
stpaul
Employer State
MINNESOTA
Employer State Slug
minnesota
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
55102
Employer Phone
651-250-2256
Employer Number of Employees
48000
Employer Year Commenced Business
1923
NAICS Code
3251
FW Ownership Interest
N
Employer Contact Name
Vanessa Marzolf
Employer Contact Address 1
1 Ecolab Place
Employer Contact Address 2
Employer Contact City
St.Paul
Employer Contact State/Province
MINNESOTA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
55102
Employer Contact Phone
651-250-4797
Employer Contact Email
Vanessa.Marzolf@Ecolab.com
Agent Attorney Name
Piyumi M Samaratunga
Agent Attorney Firm Name
Constangy, Brooks, Smith Prophete LLP
Agent Attorney Phone
6123516804
Agent Attorney Address 1
Constangy Brooks Smith Prophete LLP
Agent Attorney Address 2
225 South 6th Street, Suite 1830
Agent Attorney City
Minneapolis
Agent Attorney State/Province
MINNESOTA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
55402
Agent Attorney Email
psamaratunga@constangy.com
PW Track Number
P10021035054769
PW SOC Code
15-1121
PW SOC Title
Computer Systems Analysts
PW Skill Level
Level III
PW Wage
90709.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-06-22
PW Expiration Date
2021-09-20
Wage Offer From
107567.00
Wage Offer To
0.00
Average Salary
107567.00
Wage Unit of Pay
Year
Worksite Address 1
1601 W Diehl Road
Worksite Address 2
Worksite City
Naperville
Worksite City Slug
naperville
Worksite State
ILLINOIS
Worksite Postal Code
60563
Job Title
Lead IT Business Process Analyst (Analytics Engineer)
Job Title Slug
lead-it-business-process-analyst-analytics-engineer
Minimum Education
Bachelor's
Major Field of Study
Science, Pharmacy, Computer Science, Statistics, Economics, Mathematics, or a closely related field
Required Training
N
Required Experience
Y
Required Experience Months
48
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
48
Accept Alternative Job Title
Associate Projects, or related
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Requires a Bachelors degree or foreign equivalent in Science, Pharmacy, Computer Science, Statistics, Economics, Mathematics, or a closely related field and four 4 years postbachelors progressive experience in all of the following Designing analytical data layers and conducting ETLELT operations with large datasets; Building scalable and robust data solutions to surface necessary data and business performance metrics; High level of ability using ANSI SQL, DAX, and Power Query M languages; Constructing both global and departmental analytical databases using Cloud Data Warehouses Snowflake enterprise edition, Hadoop, Azure, etc; Constructing enterprisegrade logical and physical data models based on various business source systems SAP, Workday, Concur, Salesforce, etc.; Supporting on and offshore development teams by evangelizing analytics engineering principles, standards, and best practices; Leading dimensional clustered star modeling within an enterprise data warehouse; Domain knowledge of SAP modules SD, CRM, MM, etc..
Combination Occupation
N
Offered to Applicant Foreign Worker
Y
Foreign Worker Live on Premises
N
Foreign Worker Live in Domestic Service
N
Foreign Worker Live in Domestic Service Count
Professional Occupation
Y
Application for College/University Teacher
N
SWA Job Order Start Date
2021-09-14
SWA Job Order End Date
2021-10-14
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago Sun Times
First Advertisement Start Date
2021-10-10
Second Newspaper Ad Name
Chicago Sun Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-10-17
Employer Website From Date
2021-09-08
Employer Website To Date
2021-11-17
Professional Organization Ad From Date
2023-01-01 18:09:25
Professional Organization Advertisement To Date
2023-01-01 18:09:25
Job Search Website From Date
2021-10-06
Job Search Website To Date
2021-10-12
Employee Referral Program From Date
2023-01-01 18:09:25
Employee Referral Program To Date
2023-01-01 18:09:25
Local Ethnic Paper From Date
2021-10-13
Local Ethnic Paper To Date
2021-10-13
Radio/TV Ad From Date
2023-01-01 18:09:25
Radio/TV Ad To Date
2023-01-01 18:09:25
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Bachelor's
Foreign Worker Information: Major
PHARMACY
Foreign Worker Years of Education Completed
2003
Foreign Worker Institution of Education
RAJIV GANDHI UNIVERSITY OF HEALTH SCIENCES
Foreign Worker Education Institution Address 1
4TH T BLOCK EAST, PATTABHIRAMA NAGAR, JAYANAGAR
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
BENGALURU
Foreign Worker Education Institution State/Province
KARNATAKA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
560041
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Piyumi Samaratunga
Preparer Title
Attorney
Preparer Email
psamaratunga@constangy.com
Employer Information Declaration Name
Vanessa Marzolf
Employer Information Declaration Title
Global Mobility Consultant