Others
Scheduled A Sheepherder
N
Employer Phone
415-507-5000
Employer Number of Employees
5344
Employer Year of Commenced Business
1982
Employer Contact Name
Michael MacDonald
Employer Contact Address 1
The Landmark One Market Street
Employer Contact Address 2
Suite 400
Employer Contact City
San Francisco
Employer Contact State/Province
CALIFORNIA
Employer Contact Postal Code
94105
Employer Contact Phone
415-539-4618
Agent Attorney Phone
(415) 771-7500
Prevailing Wage Tracking Number
P10021341749181
Prevailing Wage Determination Date
6/10/22
Prevailing Wage Expiration Date
9/8/22
Minimum Education
Master's
Major Field Of Study
See H.14
Required Expirence Months
60
Acceptable Alternate Field Of Study
Y
Acceptable Alternate Major Field Of Study
See H.14
Acceptable Alternate Combination
N
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
60
Alternate Occupation Job Title
See H.14
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Masters degree in Management Information Systems, Statistics, or related field and 5 years of experience in the job offered or in a business systems analystengineerrelated occupation. Some telecommuting is permitted.br br Position requires at least 4 years of experience in each of the following skillsbr 1 Monitored alerts and data workflows, performed root cause analysis using ETL logs using Perl, Oracle, BI Publisher; andbr 2 Performed application deployment and user acceptance test activities in coordination with client.br br Position also requires at least 2 years of experience in each of the following skillsbr 3 Worked with stakeholders to gather feedback, define metrics, and design reconciliation framework and dashboard to enable support teams to proactively resolve anomalies using Tableau and Hive;br 4 Worked closely with business stakeholders and technical teams to lead development of an endtoend automation framework for an account and user set up in Dev and Stage environment using Jenkins, shell script, Salesforce, SAP, Tableau;br 5 Written product journal conducted biweekly sprint demo for stakeholders and thirdparty vendors; andbr 6 Collaborated with multiple stakeholders and technical team to design a central accuracy system by conducting deep dive sessions, impact analysis and proof of concepts using Oracle, S3, Hive, AWS, Redshift and Tableau.br br Position also requires at least 1 year of experience in each of the following skillsbr 7 Create customer facing finance report dashboards using Looker, Hive, Redshift; andbr 8 Automate data flow trigger using Python scripts, Hive, AWS, and Redshift.
Combination of Occupations
N
Offered To Foreign Worker
Y
Foreign Worker live in Employer Premises
N
Live-in Domestic Service Worker
N
Professional Occupation
Y
College or University Teacher
N
SWA Job Order Start Date
7/18/22
SWA Job Order End Date
8/19/22
Sunday Edition News Paper
Y
First News Paper Name
San Francisco Chronicle
First Advertisement Start Date
7/17/22
Second News Paper Ad Name
San Francisco Chronicle
Second Advertisement Type
Newspaper
Second Ad Start Date
7/24/22
Professional Organization Ad From Date
7/15/22
Professional Organization Ad To Date
7/24/22
Job Search Website From Date
7/5/22
Job Search Webiste To Date
7/19/22
Local Ethnic Paper From Date
7/20/22
Local Ethnic Paper To Date
7/20/22
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
INDIA
Foreign Worker Education
Master's
Foreign Worker INFO Major
MANAGEMENT INFORMATION SYSTEMS
Foreign Worker Education Completed
2016
Foreign Worker Educational Institution
STATE UNIVERSITY OF NEW YORK AT BUFFALO
Foreign Worker Educational Institution Address 1
STATE UNIVERSITY OF NEW YORK AT BUFFALO
Foreign Worker Educational Institution City
BUFFALO
Foreign Worker Educational Institution State
NY
Foreign Worker Educational Institution Country
UNITED STATES OF AMERICA
Foreign Worker Educational Institution Postal Code
14260
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N
Foreign Worker Alternate Education/Experience
N/A
Foreign Worker Has Experience in Alternate Occupation
Y
Foreign Worker Experience With Employer
N
Employer Paid For Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Yvonne A Toy
Name Of Person Signing Employer Declaration
Michael MacDonald
Title of Person Signing Employer Declaration
Global Mobility Program Manager