Prevailing Wage SOC Title :Data Warehousing Specialists
Prevailing Wage Skill Level:Level I
Prevailing Wage:37419
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-06-04
Prevailing Wage Expiration Date :2021-09-02
Wage Offer From:77760
Wage Offer To:139421
Wage Offer Unit of Pay:Year
Workstie Address Line 1:3900 North Mingo Road
Worksite Address Line 2:
Worksite City :Tulsa
Worksite State:OKLAHOMA
Worksite Postal Code:74116
Job Title:Senior Data Modeler
Minimum Education:Bachelor'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:CIS, Information Technology Management, or related field
Alternate Combination of Education/ Experience:N
Required Alternate Level of Education :
Other Alternate Level of Education:
Acceptable Years of Experience:
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:24
Accept Alternate Job Title:in data modeling
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Demonstrated experience in Industry best practice data dimensional modeling techniques using Star Schema, Snowflake Schema and Fact Constellations; Relational database normalization techniques using 1NF, 2NF 3NF and denormalization techniques; RDBMS including Teradata, Oracle, and SQL Server; Tuning and optimization of complex SQL queries using Teradata Explain and Run stats; SQL and UNIX shell scripting.
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-21
Job Oder End Date:2021-07-21
Sunday Edition Newspaper:Y
First Newspaper Name:Tulsa World
First Advertisement Start Date:2021-08-08
Second Newspaper Name:Tulsa World
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-08-15
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-07-07
Job Search Website to Date:2021-07-16
Private Employment Firm from Date:2021-06-18
Pricate Employment Firm to Date:2021-07-18
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:2021-06-22
Campus Placement to Date:2021-07-08
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:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:ELECTRICAL AND ELECTRONIC ENGINEERING
Year of Compelted Education:2011
Foreign Worker Istitution of Eduation:JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
