DELOITTE CONSULTING LLP

Consulting, Senior Consultant

A-22208-95981 H-1B 2023 Certified
Salary

$70,616

Visa Type

H-1B

Job Title

Consulting, Senior Consultant

Employee's Citizenship

INDIA

Graduate School

UNIVERSITY OF NORTH CAROLINA AT CHARLOTTE

Case info

9 fields
Data Publish Year 2023
Case Number A-22208-95981
Case Status Certified
Received Date 2022-09-02
Decision Date 2023-07-17
Refile N
Original File Date -
Previous State Work Force Agency (SWA) Case Number Stete -
Schedule A or a Sheepherder Occupation N

Company Info

14 fields
Employer Name DELOITTE CONSULTING LLP
Employer Address_Line 1 1700 MARKET STREET
Employer Address_Line 2 -
Employer City PHILADELPHIA
State -
Employer State/ Province PENNSYLVANIA
Employer Country UNITED STATES OF AMERICA
Employer Postal Code 19103
Employer Phone No. 214-840-1464
Employer Phone Extent No. -
Total Number of Employees 30600
Employer Year of Commenced 1996
NAICS Code 541611
Foreign Worker Ownership & Interest N

HR Info

9 fields
Employer Contact Name Sarah B Dieckbernd
Employer Contact Address Line1 191 Peachtree Street NE
Employer Contact Address Line2 Suite 2000
Employer Contact City Atlanta
Employer Contact State/ Provice GEORGIA
Employer Contact Country UNITED STATES OF AMERICA
Employer Contact Post Code 30303
Employer Contact Phone 404-631-2000
Employer Contact Email permservices@deloitte.com

Attorney

11 fields
Agent/ Attorney Name Sifat Ahmed
Agent/ Attorney Firm Name Berry Appleman Leiden LLP
Agent/ Attorney Phone (469) 290-9245
Agent/ Attorney Phone Ext. -
Agent/ Attorney Address Line 1 2400 N Glenville Drive
Agent/ Attorney Address Line 2 Building A
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

89 fields
Prevailing Wage Track Number P10021223516044
Prevailing Wage SOC Code 15-1121
Prevailing Wage SOC Title Computer Systems Analysts
Prevailing Wage Skill Level Level I
Prevailing Wage 70616
Prevailing Wage Unit of Pay Year
Prevailing Wage Source OES
Prevailing Wage Other Source -
Prevailing Wage Determination Date 2022-02-07
Prevailing Wage Expiration Date 2022-06-30
Wage Offer From 135900
Wage Offer To 142695
Wage Offer Unit of Pay Year
Workstie Address Line 1 30 Rockefeller Plaza
Worksite Address Line 2 Various unanticipated Deloitte office locations and client sites nationally
Worksite City New York
Worksite State NEW YORK
Worksite Postal Code 10112
Job Title Consulting, Senior Consultant
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 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 See H.14
Normal Requirements of Job Opportunity Y
Required Foreign Language N
Specific Skills Bachelors degree or foreign equivalent in Business Administration, any STEM field, or a related field and two 2 years of related work experience in the job offered or in a related occupation. Must also have two 2 years of related work experience involving each of the followingbr br Utilizing big data technologies including Hadoop and Hive to generate insights leveraging cloudbased, webbased, or onpremise;br Performing data management, including master data, metadata, data architecture, data governance, data quality, and data modeling utilizing Oracle SQL Developer Data Modeler;br Providing industry insight and analytical support using data mining, pattern matching, data visualization, and predictive modeling tools including SAS Advanced Analytics, and consolidating the implications to present recommendations to senior management and executives;br Designing and implementing reporting and visualization for unstructured and structured data sets, utilizing Tableau and Microsoft MS Power BI;br Working across all phases of the Agile and Waterfall lifecycle for the design, development, testing and implementation of Master Data Management MDM, Data Governance, Data Analytics and Data Integration solutions;br Working with Collibra tool to create custom build objects in order to maintain the Data Governance process, policies and standards;br Performing data analysis, including inspecting, cleansing, transforming and modeling for enabling data mining and resolving data mapping and data modeling issues using Python programming;br Developing, testing, and automating ETL Extract, Transform, Load procedures using Teradata to perform data warehousing and data integration functions.
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 2022-04-14
Job Oder End Date 2022-05-19
Sunday Edition Newspaper Y
First Newspaper Name The New York Times
First Advertisement Start Date 2022-04-17
Second Newspaper Name The New York Times
Second Advertisement Type Newspaper
Second Ad Start Date 2022-04-24
Job Fair From Date -
Job Fair to Date -
On Campus Recruiting from Date -
On Campus Recruiting to Date -
Employer Website from Date 2022-04-14
Employer Website to Date 2022-06-18
Pro. Org. Ad from Date -
Pro.Org. Ad to Date -
Job Search Website from Date 2022-04-18
Job Search Website to Date 2022-05-02
Private Employment Firm from Date -
Pricate Employment Firm to Date -
Employee Referral Program from Date 2022-04-14
Employee Referral Program to Date 2022-05-05
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

24 fields
Foreign Worker Education Master's
Foreign Worker Education Other -
Foreign Worker Major INFORMATION TECHNOLOGY
Year of Compelted Education 2017
Foreign Worker Istitution of Eduation UNIVERSITY OF NORTH CAROLINA AT CHARLOTTE
Foreign Worker Education Instution Address Line 1 9201 UNIVERSITY CITY BLVD.
Foreign Worker Education Institution Address Line 2 -
Foreign Worker Education Institution City CHARLOTTE
Foreign Worker Educatution Institution State NC
Foreign Worker Education Institution Country UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code 28223
Foreign Worker Training Completion N/A
Foreign Worker Required Experience N
Foreign Worker Alternate Education and Experience N/A
Foreign Worker Alternate Occupation Experience Y
Foreign Worker Experience with Employer N
Foreign Worker Employer Pay for Education N
Foreign Worker Currently Employed Y
Employer Completed Application N
Preparer Name Sifat Ahmed
Preparer Title Associate Immigration Attorney
Preparer Email DCPERM@bal.com
Employer Information Declaration Name Sarah Dieckbernd
Employer Declaration Title Lead Immigration Specialist