Agent/ Attorney Firm Name:Gibney, Anthony Flaherty LLP
Agent/ Attorney Phone:2127059848
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:665 Fifth Avenue
Agent/ Attorney Address Line 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:moconnor@gibney.com
Position Info
Prevailing Wage Track Number:P10020231774875
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Database Architects
Prevailing Wage Skill Level:Level III
Prevailing Wage:81786
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-03-15
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:110000
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:One Citizens Bank Way
Worksite Address Line 2:May telecommute up to one 1 day per week.
Worksite City :Johnston
Worksite State:RHODE ISLAND
Worksite Postal Code:2919
Job Title:Data Solutions Archiect
Minimum Education:Master's
Other Degree/ Diploma:
Major Field of Study:Information Technology, Computer Science, Engineering, or a 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:Y
Required Alternate Level of Education :Bachelor's
Other Alternate Level of Education:
Acceptable Years of Experience:5
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:36
Accept Alternate Job Title:Position offered, as an IT Project Leader, Systems Analyst, Software Developer or related role
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:EducationExperience Requirementsbr Must have a Masters degree in Information Technology, Computer Science, Engineering or related field and 3 years of experience in the position offered, as an IT Project Leader, Systems Analyst, Software Developer or related role. Alternatively, company will accept a Bachelors degree in the same fields followed by 5 years of progressive experience as described.br br Special Skillsbr Full term of required experience must include utilizing HP ALM Quality Center to gather and analyze business and functional requirements, and to develop technical solutions that meet business needs; utilizing Aqua Data Studio to create complex SQL queries based on source data mapping, and to identify data anomalies in risk data warehouse built on databases including DB2, OracleExadata, SQL server, InmemoryColumnar DB Technologies and Cloud Technologies including AWS CloudRedshift; utilizing ETL tools including DataStage, metadata management, scripting, SQL Tuning, Big Data Technologies including Hadoop and Spark and programming languages including SQL, PLSQL, Python and ABAP to extract, transform and load data into the IBM Banking Data Warehouse BDW; collaborating with technical and business teams on remediation and testing solutions from an end user perspective, and monitoring and reporting on feedback from end users; utilizing the following software, tools and technologies to support business practices ksh, Perl, Version Control SVNgit, TableauData visualization and Visio; and developing and deploying end user reports using Tableau.br br May telecommute up to one 1 day per week.
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:2021-03-23
Job Oder End Date:2021-05-06
Sunday Edition Newspaper:Y
First Newspaper Name:The Providence Journal
First Advertisement Start Date:2021-04-04
Second Newspaper Name:The Providence Journal
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-04-11
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-03-25
Employer Website to Date:2021-04-08
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-04-08
Job Search Website to Date:2021-04-21
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-03-25
Employee Referral Program to Date:2021-04-08
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:
Local Ethnic Newspaper to Date:
Radio/TV Ad from Date:
Radio/TV Ad to Date:
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:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:INFORMATION TECHNOLOGY
Year of Compelted Education:2006
Foreign Worker Istitution of Eduation:CENTRAL QUEENSLAND UNIVERSITY
Foreign Worker Education Instution Address Line 1:554700 YAAMBA ROAD
Foreign Worker Education Institution Address Line 2:
