All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22223-04314
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22223-04314
Case Status
Certified-Expired
Received Date
2022-11-21
Decision Date
2023-10-05
Refile
N
Original File Date
2024-01-01 00:02:40
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
OKTA, INC
Employer Name Slug
okta-inc
Employer Address 1
100 1ST STREET
Employer Address 2
6TH FLOOR
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
94105
Employer Phone
8887227871
Employer Number of Employees
4150
Employer Year Commenced Business
2009
NAICS Code
541511
FW Ownership Interest
N
Employer Contact Name
Julianna Ortiz
Employer Contact Address 1
300 Park Avenue
Employer Contact Address 2
Suite 400
Employer Contact City
San Jose
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
95110
Employer Contact Phone
408-892-3836
Employer Contact Email
Julianna.Ortiz@okta.com
Agent Attorney Name
Lynn T Bonnello
Agent Attorney Firm Name
Berry Appleman Leiden LLP
Agent Attorney Phone
4692909371
Agent Attorney Address 1
4555 Great America Pkwy, Suite 210
Agent Attorney Address 2
Agent Attorney City
Santa Clara
Agent Attorney State/Province
CALIFORNIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
95054
Agent Attorney Email
lbonnello@bal.com
PW Track Number
P10021183442450
PW SOC Code
15-1199
PW SOC Title
Data Warehousing Specialists
PW Skill Level
Level IV
PW Wage
119475.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-02-18
PW Expiration Date
2022-06-30
Wage Offer From
160000.00
Wage Offer To
0.00
Average Salary
160000.00
Wage Unit of Pay
Year
Worksite Address 1
110 110th Avenue
Worksite Address 2
Suite 610
Worksite City
Bellevue
Worksite City Slug
bellevue
Worksite State
WASHINGTON
Worksite Postal Code
98004
Job Title
Senior Data Engineer
Job Title Slug
senior-data-engineer
Minimum Education
Bachelor's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14
Accept Alternative Combination
Y
Accept Alternative Combination Education
Master's
Accept Alternative Combination Education Years
3
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
See H.14
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Employer will accept Bachelors degree in Computer Science, Information Technology, or closely related field, followed by 5 years of progressive, postbaccalaureate experience as a Software Engineer, Data Engineer, Data Analyst, or a related occupation includingbr 5 years of experience designing and implementing data structures and pipelines in data warehouses, managing data streaming, and performing log analysis and business analytics.br 5 years of experience in writing, analyzing, finetuning, and debugging SQL queries to work on business critical and customer facing datasets.br 3 years of experience utilizing Apache Kafka to process more than 2 Terabytes of realtime data as Streams in production.br 5 years of experience with Data Warehouse design, ETL Extraction, Transformation and Load, and architecting software designs for DW data warehouse platform.br 3 years of experience implementing data transformations in Python, R, and Apache Spark in production environments.br 3 years of experience using workflow management tools in production environments such as Apache Airflow.br 3 years of experience in building out visualizations, dashboards and reports using BI business intelligence tools, such as Tableau, and Looker.br 3 years of experience building data applications in columnar data warehouses like AWS Redshift, Snowflake, or similar databases.br br In the alternative, employer will accept a Masters degree in Computer Science, Information Technology, or closely related field, and 3 years of progressive, postbaccalaureate experience as a Software Engineer, Data Engineer, Data Analyst, or a related occupation includingbr 3 years of experience designing and implementing data structures and pipelines in data warehouses, managing data streaming, and performing log analysis and business analytics.br 3 years of experience in writing, analyzing, finetuning, and debugging SQL queries to work on business critical and customer facing datasets.br 3 years of experience utilizing Apache Kafka to process more than 2 Terabytes of realtime data as Streams in production.br 3 years of experience with Data Warehouse design, ETL Extraction, Transformation and Load, and architecting software designs for DW data warehouse platform.br 3 years of experience implementing data transformations in Python, R, and Apache Spark in production environments.br 3 years of experience using workflow management tools in production environments such as Apache Airflow.br 3 years of experience in building out visualizations, dashboards and reports using BI business intelligence tools, such as Tableau, and Looker.br 3 years of experience building data applications in columnar data warehouses like AWS Redshift, Snowflake, or similar databases.br br Travel required for staff meetings in San Francisco Bay area and Seattle area, for approximately 5 days per trip, twice a year. Telecommuting is permitted.br br Experience may be gained concurrently. Any suitable, equivalent combination of education, postbaccalaureate experience, or training is acceptable, as are foreign equivalent degrees.br br Prevailing wage issued for Bellevue, Washington 119,475year for primary requirements; 99,008year for alternative requirements. Prevailing wage issued for San Francisco, California 151,882 for primary requirements; 125,486 for alternative requirements. Offered wage of 160,000year is above prevailing wage.
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
2022-06-30
SWA Job Order End Date
2022-08-04
Sunday Edition Newspaper
Y
First Newspaper Name
The Seattle Times
First Advertisement Start Date
2022-07-10
Second Newspaper Ad Name
The Seattle Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-07-17
Employer Website From Date
2024-01-01 00:02:40
Employer Website To Date
2024-01-01 00:02:40
Professional Organization Ad From Date
2022-08-01
Professional Organization Advertisement To Date
2022-08-01
Job Search Website From Date
2022-06-30
Job Search Website To Date
2022-07-11
Employee Referral Program From Date
2024-01-01 00:02:40
Employee Referral Program To Date
2024-01-01 00:02:40
Local Ethnic Paper From Date
2022-07-15
Local Ethnic Paper To Date
2022-07-21
Radio/TV Ad From Date
2024-01-01 00:02:40
Radio/TV Ad To Date
2024-01-01 00:02:40
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
INFORMATION TECHNOLOGY
Foreign Worker Years of Education Completed
2006
Foreign Worker Institution of Education
ANNA UNIVERSITY
Foreign Worker Education Institution Address 1
SARDAR PATEL RD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CHENNAI
Foreign Worker Education Institution State/Province
TN
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
600025
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Lynn T Bonnello
Preparer Title
Senior Associate
Preparer Email
lbonnello@bal.com
Employer Information Declaration Name
Julianna Ortiz
Employer Information Declaration Title
Global Immigration Mobility Manager