Agent/ Attorney Firm Name:Fragomen, Del Rey, Bernsen Loewy, LLP
Agent/ Attorney Phone:9492610209
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:18401 Von Karman Ave., Ste. 255
Agent/ Attorney Address Line 2:
Agent/ Attorney City:Irvine
Agent/ Attorney State/ Province:CALIFORNIA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:92612
Agent/ Attorney Email:tchang@fragomen.com
Position Info
Prevailing Wage Track Number:P10020323916773
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Database Architects
Prevailing Wage Skill Level:Level II
Prevailing Wage:74090
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-05-12
Prevailing Wage Expiration Date :2021-08-10
Wage Offer From:74090
Wage Offer To:114000
Wage Offer Unit of Pay:Year
Workstie Address Line 1:1020 First Avenue
Worksite Address Line 2:
Worksite City :King of Prussia
Worksite State:PENNSYLVANIA
Worksite Postal Code:19406
Job Title:Senior Analyst Global HR Reporting
Minimum Education:Master's
Other Degree/ Diploma:
Major Field of Study:Computer Science
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :Y
Required Expreience Months :24
Accept Alternate Field of Study:Y
Accept Alternate Major:Computer Applications, Information Technology, Information Systems, or related field
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:24
Accept Alternate Job Title:Offered position or related position.
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Must possess expertiseknowledge sufficient to adequately perform the duties of the job being offered. Expertiseknowledge may be gained through employment experience or education. Such expertiseknowledge cannot be quantified by time. Required expertiseknowledge includesbr br Using Oracle, MS SQL Server, SQL, PLSQL, and SQL Developer to retrieve employeecustomer data, including financial, learning, compensation, payroll, skills, and education to send to other frontendjavabased applications.br Monitoring data and maintaining information in tables and datasets in compliance with GDPR and local data privacy and regulatory laws;br Creating queries using SQL and WSQL to extract data from tablesdata sets to manage data quality as well as to maintain historical data for enterprise analytics and for advanced analytics.br Experience in database languages and ETL tools Informatica to transform data by cleaning incompletebad data, applying formulas according to business needs, extracting data from tablesworkday, and merging data from multiple data sources to create meaningful insights.br Agile project management experience, including working knowledge in agile sprint delivery, to participate in initial business caseuse case discussion, collectrefine requirements, create design documents, develop queries, and move changes to production for users.br Using Microsoft Office, including Advanced Excel, to create pivot tables, merge the data from multiple sheet using VLOOKP formulas for quick analysis.br br The years of experience listed in H.6 and H.10 do not apply to the required skills listed in this section.br Employer will accept any suitable combination of education, training, or experience.
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-06-04
Job Oder End Date:2021-07-14
Sunday Edition Newspaper:Y
First Newspaper Name:The Philadelphia Inquirer
First Advertisement Start Date:2021-06-20
Second Newspaper Name:The Philadelphia Inquirer
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-06-27
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:
Employer Website to Date:
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-06-20
Job Search Website to Date:2021-06-28
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-06-04
Employee Referral Program to Date:2021-07-01
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-07-04
Local Ethnic Newspaper to Date:2021-07-04
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:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:INFORMATION TECHNOLOGY
Year of Compelted Education:2010
Foreign Worker Istitution of Eduation:ACHARYA NAGARJUNA UNIVERSITY
Foreign Worker Education Instution Address Line 1:NH16, NAGARJUNA NAGAR
Foreign Worker Education Institution Address Line 2:
