TIKTOK INC.
Data Engineer, Data Platform
A-22216-00634
H-1B
2023
Certified
Salary
$116,043
Visa Type
H-1B
Job Title
Data Engineer, Data Platform
Employee's Citizenship
CHINA
Graduate School
COLUMBIA UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22216-00634
Case Status
Certified
Received Date
2022-08-09
Decision Date
2023-07-28
Refile
N
Original File Date
-
Previous State Work Force Agency (SWA) Case Number Stete
-
Schedule A or a Sheepherder Occupation
N
Company Info
14 fields
Employer Name
TIKTOK INC.
Employer Address_Line 1
5800 BRISTOL PKWY
Employer Address_Line 2
SUITE 100
Employer City
CULVER CITY
State
-
Employer State/ Province
CALIFORNIA
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
90230
Employer Phone No.
650-963-4356
Employer Phone Extent No.
-
Total Number of Employees
1300
Employer Year of Commenced
2015
NAICS Code
511210
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Omesh Seemangal
Employer Contact Address Line1
5800 Bristol Pkwy
Employer Contact Address Line2
Suite 100
Employer Contact City
Culver City
Employer Contact State/ Provice
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
90230
Employer Contact Phone
424-351-0990
Employer Contact Email
omesh.seemangal@bytedance.com
Attorney
11 fields
Agent/ Attorney Name
Eileen S ChunFruto
Agent/ Attorney Firm Name
Chun Fruto Law Corporation
Agent/ Attorney Phone
2136740599
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
1055 W. 7th Street
Agent/ Attorney Address Line 2
Suite 1780
Agent/ Attorney City
Los Angeles
Agent/ Attorney State/ Province
CALIFORNIA
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
90017
Agent/ Attorney Email
eileen@chunfrutolaw.com
Position Info
89 fields
Prevailing Wage Track Number
P10021313695233
Prevailing Wage SOC Code
15-1199
Prevailing Wage SOC Title
Business Intelligence Analysts
Prevailing Wage Skill Level
Level II
Prevailing Wage
116043
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-05-18
Prevailing Wage Expiration Date
2022-08-16
Wage Offer From
165000
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
250 Bryant Street
Worksite Address Line 2
-
Worksite City
Mountain View
Worksite State
CALIFORNIA
Worksite Postal Code
94041
Job Title
Data Engineer, Data Platform
Minimum Education
Master's
Other Degree/ Diploma
-
Major Field of Study
Computer Science, Computer Engineering, Statistics, Business Analytics, or related field
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
N
Required Expreience Months
-
Accept Alternate Field of Study
N
Accept Alternate Major
-
Alternate Combination of Education/ Experience
N
Required Alternate Level of Education
-
Other Alternate Level of Education
-
Acceptable Years of Experience
-
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
24
Accept Alternate Job Title
Data Engineer, Applications Engineer, Software Engineer, or related
Normal Requirements of Job Opportunity
Y
Required Foreign Language
N
Specific Skills
Box H. 10A 24 months of experience inbr Using big Data technologies including Hadoop, MR, Hive, Spark, Metastore, Presto, Flume, Kafka, ClickHouse, or Flinkbr Using programming languages including Java, C, Python, or Gobr ETL Extraction, Transformation Loading and architecting data systemsbr Working with schema design, data modeling and SQL queries
Combination Occupation
N
Offered to Applied Foreign Worker
Y
ForeignWorker Live on Premises
N
Live in Domestic Service Worker
N
Employment Contract
-
Professional Occupation
Y
College/ University Teacher
N
Competitive Process
-
Basic Recruitment Process
-
Teacher Select Date
-
Teacher Publish Journal Name
-
Additional Recruitment Information
-
Job Oder Start Date
2022-03-14
Job Oder End Date
2022-04-16
Sunday Edition Newspaper
Y
First Newspaper Name
The Mercury News
First Advertisement Start Date
2022-03-20
Second Newspaper Name
The Mercury News
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-03-27
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
-
Employer Website to Date
-
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-03-11
Job Search Website to Date
2022-04-01
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
-
Employee Referral Program to Date
-
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
2022-03-25
Local Ethnic Newspaper to Date
2022-03-25
Radio/TV Ad from Date
2022-03-30
Radio/TV Ad to Date
2022-03-30
Employer Received the Payment
N
Payment Details
-
Bargaining Representative Notified
N/A
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
US Worker Considered
-
Country of Citizenship
CHINA
Foreign Worker Birth Country
CHINA
Class of Admission
H-1B
Employee Info
24 fields
Foreign Worker Education
Master's
Foreign Worker Education Other
-
Foreign Worker Major
DATA SCIENCE
Year of Compelted Education
2017
Foreign Worker Istitution of Eduation
COLUMBIA UNIVERSITY
Foreign Worker Education Instution Address Line 1
1140 AMSTERDAM AVE
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
NEW YORK
Foreign Worker Educatution Institution State
NY
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code
10027
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N/A
Foreign Worker Alternate Education and Experience
N/A
Foreign Worker Alternate Occupation Experience
Y
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pay for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Eileen S ChunFruto
Preparer Title
Attorney at Law
Preparer Email
eileen@chunfrutolaw.com
Employer Information Declaration Name
Omesh Seemangal
Employer Declaration Title
HR Generalist