All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23009-84249
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23009-84249
Case Status
Certified-Expired
Received Date
2023-03-14
Decision Date
2024-03-29
Refile
N
Original File Date
2024-01-01 01:04:41
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
DELOITTE CONSULTING LLP
Employer Name Slug
deloitte-consulting-llp
Employer Address 1
1700 MARKET STREET
Employer Address 2
Employer City
PHILADELPHIA
Employer City Slug
philadelphia
Employer State
PENNSYLVANIA
Employer State Slug
pennsylvania
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
19103
Employer Phone
214-840-1464
Employer Number of Employees
30600
Employer Year Commenced Business
1996
NAICS Code
541611
FW Ownership Interest
N
Employer Contact Name
Sarah B Dieckbernd
Employer Contact Address 1
191 Peachtree Street NE
Employer Contact Address 2
Suite 2000
Employer Contact City
Atlanta
Employer Contact State/Province
GEORGIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
30303
Employer Contact Phone
404-631-2000
Employer Contact Email
permservices@deloitte.com
Agent Attorney Name
Jessica Gandhi
Agent Attorney Firm Name
Berry Appleman Leiden LLP
Agent Attorney Phone
4696543200
Agent Attorney Address 1
2400 N Glenville Drive, Building A
Agent Attorney Address 2
Suite 100
Agent Attorney City
Richardson
Agent Attorney State/Province
TEXAS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
75082
Agent Attorney Email
DCPERM@BAL.COM
PW Track Number
P10022078992996
PW SOC Code
15-1243.00
PW SOC Title
Database Architects
PW Skill Level
Level I
PW Wage
123178.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-09-23
PW Expiration Date
2023-06-30
Wage Offer From
150000.00
Wage Offer To
157500.00
Average Salary
153750.00
Wage Unit of Pay
Year
Worksite Address 1
225 West Santa Clara Street
Worksite Address 2
and various unanticipated Deloitte office locations and client sites nationally.
Worksite City
San Jose
Worksite City Slug
san-jose
Worksite State
CALIFORNIA
Worksite Postal Code
95113
Job Title
Consulting, Senior Consultant
Job Title Slug
consulting-senior-consultant
Minimum Education
Bachelor's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
24
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14
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
See H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors degree or foreign equivalent in Business Administration, any STEM field, or a related field. Must have 2 years of related work experience in the job offered or in a related occupation. Position requires 2 years of related work experience in each of the followingbr br Utilizing Statistical Analysis to generate insights leveraging cloudbased, webbased, and onpremise;br Designing and implementing reporting and visualization for unstructured and structured data sets, utilizing Tableau;br Delivering Data Warehousing and Analytics solutions utilizing Apache Hive and Spark;br Performing data analysis, including inspecting, cleansing, transforming and modeling for enabling data mining and resolving data mapping and data modeling issues using data pipelines;br Developing Business Intelligence Data Warehouse BIDW solutions for enterprisewide reporting and building customized applications using Python;br Providing insights into businesses using statistical tools and data modeling of relational databases, including Presto and MySQL;br Building reports and data models in Jupyter Notebooks based on performance measurement metrics, allowing for business and technical users to provide insights into the organizations data;br Developing, testing, and automating ETL Extract, Transform, Load procedures using Microsoft MS Visual Studio Code VS Code to perform data warehousing and data integration functions.
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-11-29
SWA Job Order End Date
2023-01-03
Sunday Edition Newspaper
Y
First Newspaper Name
The Mercury News
First Advertisement Start Date
2022-11-27
Second Newspaper Ad Name
The Mercury News
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-12-04
Employer Website From Date
2022-11-22
Employer Website To Date
2023-02-03
Professional Organization Ad From Date
2024-01-01 01:04:41
Professional Organization Advertisement To Date
2024-01-01 01:04:41
Job Search Website From Date
2022-11-28
Job Search Website To Date
2022-12-12
Employee Referral Program From Date
2022-11-22
Employee Referral Program To Date
2022-12-13
Local Ethnic Paper From Date
2024-01-01 01:04:41
Local Ethnic Paper To Date
2024-01-01 01:04:41
Radio/TV Ad From Date
2024-01-01 01:04:41
Radio/TV Ad To Date
2024-01-01 01:04:41
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
LITHUANIA
Foreign Worker Birth Country
LITHUANIA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
BUSINESS ADMINISTRATION
Foreign Worker Years of Education Completed
2019
Foreign Worker Institution of Education
ARIZONA STATE UNIVERSITY
Foreign Worker Education Institution Address 1
1151 S. FOREST AVENUE
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
TEMPE
Foreign Worker Education Institution State/Province
AZ
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
85287
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jessica Gandhi
Preparer Title
Associate Immigration Attorney
Preparer Email
DCPERM@BAL.COM
Employer Information Declaration Name
Sarah Dieckbernd
Employer Information Declaration Title
Lead Immigration Specialist