All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21230-33434
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21230-33434
Case Status
Certified-Expired
Received Date
2021-08-27
Decision Date
2022-02-07
Refile
N
Original File Date
2022-01-01 10:53:45
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ICONIQ CAPITAL
Employer Name Slug
iconiq-capital
Employer Address 1
394 PACIFIC AVENUE
Employer Address 2
FLR. 2
Employer City
SAN FRANCISCO
Employer City Slug
san-francisco
Employer State
CALIFORNIA
Employer State Slug
california
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
94111
Employer Phone
415-820-3125
Employer Number of Employees
323
Employer Year Commenced Business
2011
NAICS Code
5239
FW Ownership Interest
N
Employer Contact Name
Roudabeh Pezeshkian
Employer Contact Address 1
394 Pacific Avenue
Employer Contact Address 2
Flr. 2
Employer Contact City
San Francisco
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
94111
Employer Contact Phone
415-967-7751 7751
Employer Contact Email
hr@iconiqcapital.com
Agent Attorney Name
Gali Schaham Gordon
Agent Attorney Firm Name
Agent Attorney Phone
415-284-1601
Agent Attorney Address 1
461 2nd Street
Agent Attorney Address 2
#C301
Agent Attorney City
San Francisco
Agent Attorney State/Province
CALIFORNIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
94107
Agent Attorney Email
team@gordonlawgrouppc.com
PW Track Number
P10020337935372
PW SOC Code
15-1199
PW SOC Title
Business Intelligence Analysts
PW Skill Level
Level III
PW Wage
91374.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-05-18
PW Expiration Date
2021-08-16
Wage Offer From
175000.00
Wage Offer To
0.00
Average Salary
175000.00
Wage Unit of Pay
Year
Worksite Address 1
15 E 26th Street
Worksite Address 2
Worksite City
New York
Worksite City Slug
new-york
Worksite State
NEW YORK
Worksite Postal Code
10010
Job Title
Senior Data & Business Intelligence Engineer
Job Title Slug
senior-data-business-intelligence-engineer
Minimum Education
Master's
Major Field of Study
Computer Science, Information Technology, Industrial Technology, or an Engineering Technology field
Required Training
N
Required Experience
Y
Required Experience Months
36
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
36
Accept Alternative Job Title
Assistant Vice President; Data WarehouseInformatica Developer
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
2 years of experience designing and developing data warehouse solutions.br br 2 years of experience developing ETL processes using tools such as Informatica, Talend, or Alteryx.br br 2 years of experience building SQL queries in relational databases such as Snowflake, Oracle, or DB2.br br 2 years of experience automating process flows and integrating various source systems using REST APIs.br br 2 years of experience with performance tuning of various complicated queries written in SQL.br br 2 years of experience building pipelines using various programming languages such as Python or Java.
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-06-09
SWA Job Order End Date
2021-07-14
Sunday Edition Newspaper
Y
First Newspaper Name
The New York Times
First Advertisement Start Date
2021-06-13
Second Newspaper Ad Name
The New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-06-20
Employer Website From Date
2022-01-01 10:53:45
Employer Website To Date
2022-01-01 10:53:45
Professional Organization Ad From Date
2022-01-01 10:53:45
Professional Organization Advertisement To Date
2022-01-01 10:53:45
Job Search Website From Date
2021-06-09
Job Search Website To Date
2021-06-23
Employee Referral Program From Date
2022-01-01 10:53:45
Employee Referral Program To Date
2022-01-01 10:53:45
Local Ethnic Paper From Date
2021-06-11
Local Ethnic Paper To Date
2021-06-13
Radio/TV Ad From Date
2021-06-11
Radio/TV Ad To Date
2021-06-11
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
INDUSTRIAL TECHNOLOGY
Foreign Worker Years of Education Completed
2009
Foreign Worker Institution of Education
INDIANA STATE UNIVERSITY
Foreign Worker Education Institution Address 1
200 N 7TH STREET
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
TERRE HAUTE
Foreign Worker Education Institution State/Province
IN
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
47809
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Gali Schaham Gordon
Preparer Title
Attorney
Preparer Email
gali@gordonlawgrouppc.com
Employer Information Declaration Name
Roudabeh Pezeshkian
Employer Information Declaration Title
Head of Human Capital