All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23018-88832
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23018-88832
Case Status
Certified-Expired
Received Date
2023-01-18
Decision Date
2024-02-23
Refile
N
Original File Date
2024-01-01 00:47:05
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
NEXTIVA INC
Employer Name Slug
nextiva-inc
Employer Address 1
9451 EAST VIA DE VENTURA
Employer Address 2
Employer City
SCOTTSDALE
Employer City Slug
scottsdale
Employer State
ARIZONA
Employer State Slug
arizona
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
85256
Employer Phone
4804261522
Employer Number of Employees
912
Employer Year Commenced Business
2010
NAICS Code
51731
FW Ownership Interest
N
Employer Contact Name
Lisa Fitch
Employer Contact Address 1
9451 East Via de Ventura
Employer Contact Address 2
Employer Contact City
Scottsdale
Employer Contact State/Province
ARIZONA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
85256
Employer Contact Phone
602-753-3826
Employer Contact Email
lisa.fitch@nextiva.com
Agent Attorney Name
Jared C Leung
Agent Attorney Firm Name
JCL Immigration Attorneys, PLLC
Agent Attorney Phone
602-675-9486
Agent Attorney Address 1
3200 N. Hayden Road
Agent Attorney Address 2
Suite 320
Agent Attorney City
Scottsdale
Agent Attorney State/Province
ARIZONA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
85251
Agent Attorney Email
jleung@jclimmigration.com
PW Track Number
P10022180322028
PW SOC Code
15-1243.00
PW SOC Title
Database Architects
PW Skill Level
Level II
PW Wage
87464.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2023-01-09
PW Expiration Date
2023-06-30
Wage Offer From
160000.00
Wage Offer To
160000.00
Average Salary
160000.00
Wage Unit of Pay
Year
Worksite Address 1
9451 E Via de Ventura
Worksite Address 2
Worksite City
Scottsdale
Worksite City Slug
scottsdale
Worksite State
ARIZONA
Worksite Postal Code
85256
Job Title
Senior Engineer-Data Warehouse Architect
Job Title Slug
senior-engineer-data-warehouse-architect
Minimum Education
Master's
Major Field of Study
Computer Science, or closely related. Employer will accept foreign equivalent as same.
Required Training
N
Required Experience
Y
Required Experience Months
24
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
24
Accept Alternative Job Title
in job ofrd, BIReporting Eng III, Sr Software Eng, Sr ConsultantCRM, Asst Systems Eng, or cls rel.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Education Requirementsbr Masters Degree in Computer Science, or closely related. Employer will accept foreign equivalent as same.br br Experience Requirementsbr 2 years of experience in job offered, BIReporting Engineer III, Senior Software Engineer, Senior ConsultantCRM, Assistant Systems Engineer, or closely related.br br Special skills requirementsbr 1. Experience working with Data warehousing tools and technologies like Oracle, Teradata, Snowflake, Informatica, Pentaho, Fivetran, Obiee, dbt, MicroStrategy, Power BI, and Tableaubr 2. Experience working with writing complex SQL, PLSQL, and Python Scriptsbr 3. Experience designing and implementing solutionsstatearchitecture for DW data sourcesbr 4. Experience with lead logical data model design, data engineering of schemas, and liaison between DW EngineersBusiness Systems Analysts and BI Analystsbr 5. Experience working directly on complex data integration projects as well as with the related design and development solutionsbr 6. Experience with BI development for business reportingbr 7. Experience architecting, designing, and Implementing Datawarehouse solutions which include Data design, Data quality, metadata management, Data Governance, Master Data Management, and Archiving.br 8. Experience architecting and designing data integration pipelines and providing analytical solutions from various sources like RDBS, Files, REST APIs
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-10-13
SWA Job Order End Date
2022-11-15
Sunday Edition Newspaper
Y
First Newspaper Name
The Arizona Republic
First Advertisement Start Date
2022-10-23
Second Newspaper Ad Name
The Arizona Republic
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-10-30
Employer Website From Date
2022-10-19
Employer Website To Date
2022-11-03
Professional Organization Ad From Date
2024-01-01 00:47:05
Professional Organization Advertisement To Date
2024-01-01 00:47:05
Job Search Website From Date
2022-10-13
Job Search Website To Date
2022-10-28
Employee Referral Program From Date
2024-01-01 00:47:05
Employee Referral Program To Date
2024-01-01 00:47:05
Local Ethnic Paper From Date
2022-11-01
Local Ethnic Paper To Date
2022-11-01
Radio/TV Ad From Date
2024-01-01 00:47:05
Radio/TV Ad To Date
2024-01-01 00:47:05
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
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2003
Foreign Worker Institution of Education
VISVESWARAIAH TECHNOLOGICAL UNIVERSITY, BELGAUM
Foreign Worker Education Institution Address 1
JNANA SANGAMA, VTU MAIN RD,
Foreign Worker Education Institution Address 2
VISVESVARAYA TECHNOLOGICAL UNIVERSITY, MACHHE
Foreign Worker Education Institution City
BELAGAVI
Foreign Worker Education Institution State/Province
KARNATAKA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
590018
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jared C Leung
Preparer Title
Attorney
Preparer Email
jleung@jclimmigration.com
Employer Information Declaration Name
Joshua I Lesavoy
Employer Information Declaration Title
CIO