Agent/ Attorney Address Line 1:2400 N Glenville Drive, Building A
Agent/ Attorney Address Line 2:Suite 100
Agent/ Attorney City:Richardson
Agent/ Attorney State/ Province:TEXAS
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:75082
Agent/ Attorney Email:DCPERM@BAL.com
Position Info
Prevailing Wage Track Number:P10020293881962
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Data Warehousing Specialist
Prevailing Wage Skill Level:Level II
Prevailing Wage:110926
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-04-30
Prevailing Wage Expiration Date :2021-07-29
Wage Offer From:151100
Wage Offer To:158655
Wage Offer Unit of Pay:Year
Workstie Address Line 1:225 West Santa Clara St.
Worksite Address Line 2:Various unanticipated Deloitte office locations and client sites nationally
Worksite City :San Jose
Worksite State:CALIFORNIA
Worksite Postal Code:95113
Job Title:*SENIOR CONSULTANT, STRATEGY AND ANALYTICS, ANALYTICS AND COGNITIVE
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:See H.14
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:See H.14
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :Other
Other Alternate Level of Education:3 years of University study towards a Bachelor's degree
Acceptable Years of Experience:3
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:24
Accept Alternate Job Title:Any related occupation. See H.14
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:REQUIRES A BACHELORS DEGREE OR FOREIGN EQUIVALENT IN BUSINESS ADMINISTRATION, OR A RELATED FIELD AND TWO 2 YEARS OF RELATED WORK EXPERIENCE IN THE JOB OFFERED OR IN A RELATED OCCUPATION. IN THE ALTERNATIVE, THE EMPLOYER WILL ACCEPT THREE YEARS OF UNIVERSITY STUDY AND 3 YEARS OF RELATED WORK EXPERIENCE. MUST ALSO HAVE TWO 2 YEARS OF RELATED WORK EXPERIENCE INVOLVING EACH OF THE FOLLOWINGbr br DRIVING IMPLEMENTATION OF ENTERPRISE LEVEL DATA WAREHOUSE DW INCLUDING DATABASE DESIGN, DEVELOPMENT OF LOGICAL AND PHYSICAL MODELS,br UTILIZING ERWIN, ERSTUDIO DATA ARCHITECT, SAP POWER DESIGNER AND TOAD DATA MODELER;br PERFORMING DATA MANAGEMENT, SUCH AS MASTER DATA, METADATA, DATA ARCHITECTURE, DATA GOVERNANCE, DATA QUALITY, AND DATA MODELING, UTILIZINGbr INFORMATICA, TALEND, ERWIN, AND ERSTUDIO DATA ARCHITECT;br UTILIZING STRUCTURED QUERY LANGUAGE SQL, AMAZON WEB SERVICES AWS, PYTHON, TABLEAU, AND DOMO TO PERFORM DATA ANALYSIS, REPORTING, DATAbr WAREHOUSING AND ANALYTICS, BUSINESS INTELLIGENCE BI, AND VISUALIZATION FOR UNSTRUCTURED AND STRUCTURED DATA SETS IN BIG DATA TECHNOLOGIES;br SUPPORTING ACCURACY OF DATA TRANSFORMATIONS AND DATA VERIFICATION BY PERFORMING AUTOMATED DATA QUALITY AND DATA INTEGRITY TESTS ANDbr VALIDATION, DISASTER RECOVERY, BACKUP, AUTOMATED SCHEMA MIGRATIONS, CONTINUOUS DEPLOYMENT UTILIZING AWS CODEDEPLOY;br COLLABORATING WITH DATA SCIENTISTS, DATA ARCHITECTS, BUSINESS PARTNERS, AND OTHER IT COUNTERPARTS TO IMPLEMENT EXTRACT, TRANSFORM, LOADbr ETL PROCESS TO IDENTIFY, CAPTURE, COLLECT, FORMAT, AND EXTRACT DATA FROM DIFFERENT EXTERNAL AND INTERNAL SOURCES, AND DESIGN DW, UTILIZINGbr INFORMATICA, TALEND, PYTHON, SQL, APACHE SPARK, AND KAFKA;br WORKING ACROSS ALL PHASES OF THE AGILE AND WATERFALL LIFECYCLE TO DESIGN, DEVELOP, TEST, AND IMPLEMENT PRODUCTION SUPPORT ANDbr PERFORMANCE TUNING OF ENTERPRISE DW, DATA MARTS, BI REPORTING ENVIRONMENTS, DATA ANALYTICS AND DATA INTEGRATION SOLUTIONS FORbr ENTERPRISELEVEL CLIENTS IN THE ECOMMERCE INDUSTRY;br DEVELOPING BIDW SOLUTIONS FOR ENTERPRISEWIDE REPORTING AND BUILDING CUSTOMIZED APPLICATIONS, UTILIZING MICROSTRATEGY, IBM COGNOS,br TABLEAU, MICROSOFT MS SQL SERVER REPORTING SERVICES SSRS IN A BIG DATA ENVIRONMENT;br PROVIDING INDUSTRY INSIGHTS AND ANALYTICAL SUPPORT USING HIVE, KAFKA, AND AWS; AND BUILDING AND DRIVING PROGRAM PLANS AND TIMELINES, LEADING PLATFORM ARCHITECTURE, AND DRIVING THE TECHNICAL DIRECTION OF THE BIG DATA PLATFORM PROJECTS FOR CLIENTS.br br 80 TRAVEL REQUIRED NATIONALLY.br TELECOMMUTING PERMITTED.
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-07-29
Job Oder End Date:2021-09-02
Sunday Edition Newspaper:Y
First Newspaper Name:The Mercury News
First Advertisement Start Date:2021-08-01
Second Newspaper Name:The Mercury News
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-08-08
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-07-26
Employer Website to Date:2021-10-05
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-08-09
Job Search Website to Date:2021-08-23
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-07-26
Employee Referral Program to Date:2021-08-16
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-4
Employee Info
Foreign Worker Education:Other
Foreign Worker Education Other:3 YEARS OF ACADEMIC STUDIES TOWARD A BACHELOR DEGREE
Foreign Worker Major:BUSINESS ADMINISTRATION
Year of Compelted Education:2006
Foreign Worker Istitution of Eduation:PT. RAVISHANKAR SHUKLA UNIVERSITY, RAIPUR
Foreign Worker Education Instution Address Line 1:GREAT EASTERN RD
Foreign Worker Education Institution Address Line 2:
