All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22306-50650
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22306-50650
Case Status
Certified-Expired
Received Date
2022-11-15
Decision Date
2023-12-22
Refile
N
Original File Date
2024-01-01 00:27:21
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
CAPGEMINI AMERICA, INC.
Employer Name Slug
capgemini-america-inc
Employer Address 1
333 W. WACKER DRIVE
Employer Address 2
SUITE 300
Employer City
CHICAGO
Employer City Slug
chicago
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60606
Employer Phone
312-395-5000
Employer Number of Employees
19000
Employer Year Commenced Business
1984
NAICS Code
541512
FW Ownership Interest
N
Employer Contact Name
Jean Taylor
Employer Contact Address 1
333 W. Wacker Drive
Employer Contact Address 2
Suite 300
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60606
Employer Contact Phone
312-395-5000
Employer Contact Email
iasimmigration.nar@capgemini.com
Agent Attorney Name
Hugo P Rojas
Agent Attorney Firm Name
Berry Appleman Leiden LLP
Agent Attorney Phone
4699407765
Agent Attorney Address 1
1 S Wacker Drive
Agent Attorney Address 2
Ste 550
Agent Attorney City
Chicago
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60606
Agent Attorney Email
hurojas@bal.com
PW Track Number
P10021119271653
PW SOC Code
15-1199
PW SOC Title
Data Warehousing Specialists
PW Skill Level
Level III
PW Wage
95472.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-01-19
PW Expiration Date
2022-06-30
Wage Offer From
95472.00
Wage Offer To
101959.00
Average Salary
98715.50
Wage Unit of Pay
Year
Worksite Address 1
333 West Wacker Drive, Suite 300
Worksite Address 2
and various unanticipated sites throughout the U.S.
Worksite City
Chicago
Worksite City Slug
chicago
Worksite State
ILLINOIS
Worksite Postal Code
60606
Job Title
Senior Consultant (Business Intelligence 030)
Job Title Slug
senior-consultant-business-intelligence-030
Minimum Education
Bachelor's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
48
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
48
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, Engineering, Business or related field and four years of work experience in job offered or four years of work experience in a related occupation. Experience must include one year of experience with each of the followingbr br 1. SQL Database Administration;br 2. TSQL, SQL Server Integration Services SSIS, Analysis Services SSAS and Reporting Services SSRS;br 3. Database administration activities Log shipping, Replication, Mirroring, Service Broker, Table partitioning;br 4. Create DB schemas, ETL package and Analysis Service cubes;br 5. Data warehouse design and physical data modeling;br 6. Cloud based big data technologies on modern platforms including Microsoft Azure;br 7. Scripting programming languages including .NET C, Python and Powershell; andbr 8. Reporting using PowerBI, Excel Power Pivots, and Excel VBA.br br Any suitable combination of education, training, or experience is acceptable. Must be available to work on projects at various, unanticipated sites throughout the United States.
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-20
SWA Job Order End Date
2022-07-25
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago Tribune
First Advertisement Start Date
2022-06-26
Second Newspaper Ad Name
Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-07-03
Employer Website From Date
2022-06-16
Employer Website To Date
2022-07-26
Professional Organization Ad From Date
2024-01-01 00:27:21
Professional Organization Advertisement To Date
2024-01-01 00:27:21
Job Search Website From Date
2022-06-16
Job Search Website To Date
2022-07-05
Employee Referral Program From Date
2024-01-01 00:27:21
Employee Referral Program To Date
2024-01-01 00:27:21
Local Ethnic Paper From Date
2022-06-29
Local Ethnic Paper To Date
2022-06-29
Radio/TV Ad From Date
2024-01-01 00:27:21
Radio/TV Ad To Date
2024-01-01 00:27:21
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
Y
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Bachelor's
Foreign Worker Information: Major
APPLIED COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2009
Foreign Worker Institution of Education
ANDHRA UNIVERSITY
Foreign Worker Education Institution Address 1
WALTAIR JUNCTION, ANDHRA UNIVERSITY SOUTH CAMPUS, ANDHRA UNIVERSITY
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
VISAKHAPATNAM
Foreign Worker Education Institution State/Province
AP
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
530003
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Hugo Rojas
Preparer Title
Sr. Associate Immigration Attorney
Preparer Email
hurojas@bal.com
Employer Information Declaration Name
Jared Knotts
Employer Information Declaration Title
Immigration Manager