All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21117-79057
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-21117-79057
Case Status
Certified
Received Date
2021-04-30
Decision Date
2021-08-25
Refile
N
Original File Date
2021-01-01 10:04:54
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
BARCLAYS SERVICES LLC
Employer Name Slug
barclays-services-llc
Employer Address 1
745 SEVENTH AVENUE
Employer Address 2
Employer City
NEW YORK
Employer City Slug
new-york
Employer State
NEW YORK
Employer State Slug
new-york
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
10019
Employer Phone
2124124000
Employer Number of Employees
2200
Employer Year Commenced Business
2011
NAICS Code
523110
FW Ownership Interest
N
Employer Contact Name
Corinne Heyes
Employer Contact Address 1
745 Seventh Avenue
Employer Contact Address 2
Employer Contact City
New York
Employer Contact State/Province
NEW YORK
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
10019
Employer Contact Phone
2124124000
Employer Contact Email
Agent Attorney Name
Houman Afshar
Agent Attorney Firm Name
Gibney, Anthony, and Flaherty, LLP
Agent Attorney Phone
212-705-9853
Agent Attorney Address 1
665 Fifth Avenue
Agent Attorney Address 2
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10022
Agent Attorney Email
PW Track Number
P10020164650449
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level IV
PW Wage
143936.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-10-07
PW Expiration Date
2021-06-30
Wage Offer From
162000.00
Wage Offer To
0.00
Average Salary
162000.00
Wage Unit of Pay
Year
Worksite Address 1
300400 Jefferson Park
Worksite Address 2
Worksite City
Whippany
Worksite City Slug
whippany
Worksite State
NEW JERSEY
Worksite Postal Code
7981
Job Title
Database/ETL Tech Lead
Job Title Slug
databaseetl-tech-lead
Minimum Education
Bachelor's
Major Field of Study
COMPUTER SCIENCE, ENGINEERING OR CLOSELY RELATED FIELD
Required Training
N
Required Experience
N
Required Experience Months
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
60
Accept Alternative Job Title
POSITION OFFERED OR AS A PROGRAMMER, SOFTWARE DEVELOPERENGINEER OR CLOSELY RELATED POSITION
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
EDUCATIONbr BACHELORS DEGREE OR FOREIGN EQUIVALENT IN COMPUTER SCIENCE, ENGINEERING OR CLOSELY RELATED FIELD AND 5 YEARS OF PROGRESSIVE, POSTBACHELORS EXPERIENCE IN THE POSITION OFFERED OR AS A PROGRAMMER, SOFTWARE DEVELOPERENGINEER OR CLOSELY RELATED POSITION.br br SPECIAL REQUIREMENTS EXPERIENCE MUST INCLUDE DESIGN OF DATABASE, UTILIZING ORACLE PLSQL TO AUTOMATE DATABASE ADMINISTRATION TASKS AND ILM PROCEDURES AND PACKAGES; UTILIZING ORACLE ENTERPRISE MANAGER FOR MONITORING AND ADMINISTERING ORACLE DATABASES; UTILIZING UNIX AND SHELL SCRIPTING TO CREATE FILES OR SCRIPTS THAT SUPPORT ETL DEVELOPMENT; UTILIZING ORACLE TOOLS AND OPATCH UTILITY TO UPGRADE AND PATCH DATABASES; UTILIZING DATA PUMP AND RMAN TO PERFORM DATABASE BACKUPS AND DATA RECOVERY FROM DAMAGED, FAILED, CORRUPTED, OR INACCESSIBLE DATABASES; UTILIZING ETL TOOLS, INCLUDING DATASTAGE TO TROUBLESHOOT DATA WAREHOUSING APPLICATIONS FOR BUSINESS INTEGRATION SOLUTIONS; UTILIZING CUSTOM SCRIPTS, DBCA, AND RAC WITH ASM ADMINISTRATION TO INSTALL, CONFIGURE AND MANAGE ALL DATABASE, CLUSTERING AND STORAGE MANAGEMENT TASKS; UTILIZING TOAD TO REVIEW LOGICAL AND PHYSICAL DATA MODELS; UTILIZING DATABASE TOOLS SUCH AS TOAD, ORACLE, ENTERPRISE MANAGER, SQL DEVELOPER AND SQL LOADER TO DEFINE, ANALYZE AND DESIGN APPLICATIONS TO ACHIEVE ETL FUNCTIONALITIES; UTILIZING PROGRAMMING LANGUAGES SUCH AS PERL, KORNBASH SHELL, C, C, HTML, AND VB SCRIPT TO WRITEMODIFY CODES; UTILIZING SCHEDULING AND DEPLOYMENT TOOLS SUCH AS CONTROLM DB IMPLEMENT, JENKINS ENTERPRISE BUILD MONITORING TO SCHEDULE AND DEPLOY APPLICATIONS; AND UTILIZING VERSION CONTROL TOOLS SUCH AS WINCVS TO PERFORM CODE BUILDS, DEPLOYMENTS AND RESOLVE CONFLICTS DURING DEVELOPMENT PROCESS.
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
2020-11-04
SWA Job Order End Date
2020-12-07
Sunday Edition Newspaper
Y
First Newspaper Name
The StarLedger
First Advertisement Start Date
2020-11-08
Second Newspaper Ad Name
The StarLedger
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-11-15
Employer Website From Date
2020-11-04
Employer Website To Date
2020-12-21
Professional Organization Ad From Date
2021-01-01 10:04:54
Professional Organization Advertisement To Date
2021-01-01 10:04:54
Job Search Website From Date
2020-11-08
Job Search Website To Date
2020-11-16
Employee Referral Program From Date
2020-11-05
Employee Referral Program To Date
2020-11-19
Local Ethnic Paper From Date
2021-01-01 10:04:54
Local Ethnic Paper To Date
2021-01-01 10:04:54
Radio/TV Ad From Date
2021-01-01 10:04:54
Radio/TV Ad To Date
2021-01-01 10:04:54
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
COMPUTER ENGINEERING
Foreign Worker Years of Education Completed
2004
Foreign Worker Institution of Education
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Foreign Worker Education Institution Address 1
KUKATPALLY
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
HYDERABAD
Foreign Worker Education Institution State/Province
TELANGANA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
500085
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Houman Afshar
Preparer Title
Partner
Preparer Email
Employer Information Declaration Name
KK Gupta
Employer Information Declaration Title
Managing Director