All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20234-90744
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20234-90744
Case Status
Certified
Received Date
2020-12-18
Decision Date
2021-06-10
Refile
N
Original File Date
2021-01-01 09:35:18
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ROCKET SOFTWARE
Employer Name Slug
rocket-software
Employer Address 1
77 FOURTH AVENUE
Employer Address 2
Employer City
WALTHAM
Employer City Slug
waltham
Employer State
MASSACHUSETTS
Employer State Slug
massachusetts
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
2451
Employer Phone
617-684-2285
Employer Number of Employees
640
Employer Year Commenced Business
1990
NAICS Code
511210
FW Ownership Interest
N
Employer Contact Name
Emily Hanchett
Employer Contact Address 1
Rocket Software Inc.
Employer Contact Address 2
77 Fourth Avenue
Employer Contact City
Waltham
Employer Contact State/Province
MASSACHUSETTS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
2451
Employer Contact Phone
7816842103
Employer Contact Email
hr@rocketsoftware.com
Agent Attorney Name
AMANDA M NORDBY
Agent Attorney Firm Name
FRAGOMEN, DEL REY, BERNSEN LOEWY, LLP
Agent Attorney Phone
6175740400
Agent Attorney Address 1
100 High Street
Agent Attorney Address 2
3rd Floor
Agent Attorney City
Boston
Agent Attorney State/Province
MASSACHUSETTS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
2110
Agent Attorney Email
ATTY.LESTERTEAM@fragomen.com
PW Track Number
P10020064377130
PW SOC Code
15-1199
PW SOC Title
BUSINESS INTELLIGENCE ANALYSTS
PW Skill Level
Level IV
PW Wage
111238.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-05-19
PW Expiration Date
2020-08-17
Wage Offer From
115000.00
Wage Offer To
125000.00
Average Salary
120000.00
Wage Unit of Pay
Year
Worksite Address 1
77 4th Ave.
Worksite Address 2
Worksite City
Waltham
Worksite City Slug
waltham
Worksite State
MASSACHUSETTS
Worksite Postal Code
2451
Job Title
Senior Analytics Developer
Job Title Slug
senior-analytics-developer
Minimum Education
Bachelor's
Major Field of Study
COMPUTER SCIENCE
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Information Systems, Information Technology or a directly related field
Accept Alternative Combination
Y
Accept Alternative Combination Education
Master's
Accept Alternative Combination Education Years
2
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
ETL DEVELOPMENT EXPERIENCE.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
EXPERIENCE MUST INCLUDEbr TWO 2 YEARS OF THE FOLLOWING EXPERIENCE MAY BE GAINED CONCURRENTLYbr ENDTOEND LIFE CYCLE EXPERIENCE IN DATA MIGRATION PROJECTS UTILIZING AGILE AND WATER FALL METHODOLOGIES;br SUPPORTING FOR DATA TRANSFORM;br HANDSON EXPERIENCE UTILIZING AND SUPPORTING ETL TOOLS, INCLUDING DELL BOOMI OR INFORMATICA;br DESIGNING AND DEVELOPING DATAFLOWS AND DATASETS USING BI PLATFORM EINSTEIN ANALYTICS DATA MANAGEMENT;br UTILIZING JSON SCRIPTS, SAQL AND SOQL LANGUAGES TO HARD CODE DATAFLOWS AND DASHBOARD USER INTERFACE;br ARTICULATING EINSTEIN ANALYTICS DESIGN AND IMPLEMENTATION BEST PRACTICES TO ENHANCE THE DASHBOARD PERFORMANCE;br PERFORMING INTEGRATIONS WITH NONE SALESFORCE SYSTEMS SUCH AS ORACLE. ARCHITECT FOR COMPLEX DATA STRUCTURE;br DESIGNING DATA SECURITY STRATEGY IN EINSTEIN ANALYTICS AND ETL FOR DATA TRANSFORMATION;br USER ACCEPTANCE TESTING AND PRODUCTION SUPPORT;br JIRA;br GATHERING BUSINESS REQUIREMENTS, INTERPRETING FUNCTIONAL SPECIFICATIONS;br PROVIDING CONSULTANCY ADVISORIES TO BUSINESS;br HANDSON DEVELOPMENT EXPERIENCE ON SALESFORCE EINSTEIN ANALYTICS BI PLATFORM;br DEVELOPING ETL PROCESSES AND PROCEDURES TO MIGRATE DATA FROM ERP, CRM OR FLAT FILES TO BI PLATFORMS;br br EXPERIENCE MAY BE GAINED BEFORE, DURING OR AFTER THE COMPLETION OF AN ADVANCED DEGREE PROGRAM.br br Any suitable combination of education, training, or experience is acceptable.
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
2020-06-23
SWA Job Order End Date
2020-07-24
Sunday Edition Newspaper
Y
First Newspaper Name
THE BOSTON GLOBE
First Advertisement Start Date
2020-09-06
Second Newspaper Ad Name
THE BOSTON GLOBE
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-09-13
Employer Website From Date
2021-01-01 09:35:18
Employer Website To Date
2021-01-01 09:35:18
Professional Organization Ad From Date
2021-01-01 09:35:18
Professional Organization Advertisement To Date
2021-01-01 09:35:18
Job Search Website From Date
2020-07-08
Job Search Website To Date
2020-07-21
Employee Referral Program From Date
2021-01-01 09:35:18
Employee Referral Program To Date
2021-01-01 09:35:18
Local Ethnic Paper From Date
2020-07-08
Local Ethnic Paper To Date
2020-07-08
Radio/TV Ad From Date
2021-01-01 09:35:18
Radio/TV Ad To Date
2021-01-01 09:35:18
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
Master's
Foreign Worker Information: Major
INFORMATION TECHNOLOGY AND MANAGEMENT
Foreign Worker Years of Education Completed
2015
Foreign Worker Institution of Education
THE UNIVERSITY OF TEXAS AT DALLAS
Foreign Worker Education Institution Address 1
800 WEST CAMPBELL ROAD
Foreign Worker Education Institution Address 2
OFFICE OF THE REGISTRER
Foreign Worker Education Institution City
RICHARDSON
Foreign Worker Education Institution State/Province
TX
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
75080
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
AMANDA M NORDBY
Preparer Title
ASSOCIATE
Preparer Email
ATTY.LESTERTEAM@FRAGOMEN.COM
Employer Information Declaration Name
EMILY HANCHETT
Employer Information Declaration Title
HR OPERATIONS ASSOCIATE