Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:MOHAWK INDUSTRIES, INC.
Employer Address_Line 1:160 SOUTH INDUSTRIAL BLVD
Employer Address_Line 2:
Employer City :CALHOUN
State:
Employer State/ Province:GEORGIA
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:30701
Employer Phone No.:2143094355
Employer Phone Extent No.:
Total Number of Employees:14096
Employer Year of Commenced :
NAICS Code:314110
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Sophia Doss
Employer Contact Address Line1:160 SOUTH INDUSTRIAL BLVD
Employer Contact Address Line2:
Employer Contact City:CALHOUN
Employer Contact State/ Provice:GEORGIA
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:30701
Employer Contact Phone:2143094355
Employer Contact Email:sophia_doss@mohawkind.com
Attorney
Agent/ Attorney Name:Rebecca R Massiatte
Agent/ Attorney Firm Name:JMA Firm, PLLC
Agent/ Attorney Phone:2143895703
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:12655 N. Central Expressway
Agent/ Attorney Address Line 2:Suite 275
Agent/ Attorney City:Dallas
Agent/ Attorney State/ Province:TEXAS
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:75243
Agent/ Attorney Email:rebecca@jmafirm.com
Position Info
Prevailing Wage Track Number:P10021105226941
Prevailing Wage SOC Code :15-1132
Prevailing Wage SOC Title :Software Developers, Applications
Prevailing Wage Skill Level:Level IV
Prevailing Wage:112944
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-09-20
Prevailing Wage Expiration Date :2022-06-30
Wage Offer From:144000
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:160 South Industrial Blvd.
Worksite Address Line 2:
Worksite City :Calhoun
Worksite State:GEORGIA
Worksite Postal Code:30701
Job Title:Senior Business Intelligence Specialist
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 :N
Required Expreience Months :
Accept Alternate Field of Study:N
Accept Alternate Major:
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:108
Accept Alternate Job Title:See H.14.
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:REQUIREMENTS AS STATED ON FORM ETA 9141 REQUIRES BACHELOR OF SCIENCE DEGREE IN COMPUTER ENGINEERING, COMPUTER SCIENCE, BUSINESS ADMINISTRATION, ENGINEERING, INFORMATION TECHNOLOGY OR A RELATED DISCIPLINE WITH AN INFORMATION TECHNOLOGY FOCUS, PLUS 9 YEARS OF EXPERIENCE MANAGING SYSTEMS DEVELOPING IN NEW COMPUTING ARCHITECTURE AND ENVIRONMENTS; 9 YEARS OF EXPERIENCE WITH BI BUSINESS INTELLIGENCE DEVELOPMENT AND ARCHITECTURE DESIGN; 7 YEARS OF EXPERIENCE WORKING WITH EACH BI BUSINESS INTELLIGENCE SYSTEM SAP BOBJ, SAP HANA, ANALYSIS FOR OFFICE, MICROSOFT SSAS, TABLEAU, SAP ERP, SAP ABAP, SDA, SLT, SAP BODS; 5 YEARS OF EXPERIENCE DEVELOPING ENTERPRISE BI BUSINESS INTELLIGENCE SOLUTION ON MULTIPLE EDW ENTERPRISE DATA WAREHOUSE PLATFORMS SQLSERVER, HANA; 7 YEARS OF EXPERIENCE WITH INTEGRATION OF SAP BOBJ AND SAP HANA; 5 YEARS OF EXPERIENCE USING SAP DATA SERVICES EXTRACTORS; 5 YEARS OF EXPERIENCE IMPLEMENTING EACH OF THE FOLLOWING SDI, SAP BOBJ, TABLEAU, POWER BI, AND SAP ANALYTICS CLOUD ON HANA; 7 YEARS OF EXPERIENCE WITH UNDERSTANDING AND APPLICATION OF DATA STRUCTURES AND DATA FORMATS WHICH INCLUDE STRUCTURED, UNSTRUCTURED, SEMISTRUCTURED, JSON, XML, AND EDI; 7 YEARS OF EXTENSIVE EXPERIENCE WITH EACH OF THE FOLLOWING HANA MODELING USING GRAPHICAL VIEWS, SQL SCRIPTED VIEWS, STORED PROCEDURES, AND TABLE FUNCTIONS; 7 YEARS OF EXPERIENCE WITH EDW ENTERPRISE DATA WAREHOUSE DEVELOPMENT LIFE CYCLE FROM BUSINESS REQUIREMENT GATHERING TO DEVELOP END TO END SOLUTIONS; 9 YEARS OF EXPERIENCE IN EACH SELFSERVICE BI AND AGILE BI DEVELOPMENT; AND 9 YEARS OF EXPERIENCE WITH CUSTOMER SERVICE SKILLS. REQUIRES LESS THAN 5 DOMESTIC TRAVEL. EXPERIENCE MAY BE GAINED CONCURRENTLY.br br As listed in Section I.e.23. of this form, the employer has not received payments of any kind from the foreign worker or from any third party, including employers attorney fees. Employer has not received any incentive, inducement to file, or any reimbursement for the cost incurred in preparing or filing of this application.br br BUSINESS NECESSITY Cont. from H.11... 5 yrs of exp using SAP Data Services Extractors bc Mohawks system has several data sources various data extractors are used to connect to them to extract data in batch real time scenarios. New data flow in from different sources as requirements change. There are multiple tiers of systems where data flows one after the other post manipulation. 5 yrs of exp implementing EACH of the following SDI; SAP BOBJ; Tableau; Power BI; SAP Analytics Cloud on HANA bc in addition to the integration tools mentioned above, Mohawk uses SDI to extractreplicate data from different sources. Most of the manufacturing plants data is replicated to the EDW using SDI. This is highly critical information as managers rely on this data on the shop floor to keep track of various processes. 7 yrs of exp with understanding application of data structures data formats which include structured, unstructured, semistructured, JSON, XML, EDI bc there is a need to support maintain interfaces that pull data from various source systems with disparate data structures formats that are very critical for the daily reporting functional operations of the company. 7 yrs of extensive experience with EACH of the following HANA modeling using Graphical views; SQL scripted views; Stored Procedures; Table functions because different modeling techniques methods are required to achieve a variety of requirements. Appropriate modelling techniques need to be used to tackle complex scenarios, in many cases multiple modeling techniques mentioned above need be used to create objects that suffice the requirements. HANA experience in using graphical SQL scripted views is needed to create Cubes dimension models. Strong SQL knowledge is required to create complex performant table functions. Cont. in Section K. Job 1. Number 9
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-05-12
Job Oder End Date:2021-06-13
Sunday Edition Newspaper:Y
First Newspaper Name:Rome News Tribune
First Advertisement Start Date:2021-05-23
Second Newspaper Name:Rome News Tribune
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-05-30
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-05-10
Employer Website to Date:2021-06-14
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:
Job Search Website to Date:
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-05-26
Local Ethnic Newspaper to Date:2021-05-26
Radio/TV Ad from Date:2021-05-22
Radio/TV Ad to Date:2021-05-22
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:COMPUTER ENGINEERING
Year of Compelted Education:2009
Foreign Worker Istitution of Eduation:SASTRA UNIVERSITY
Foreign Worker Education Instution Address Line 1:TRICHYTANJORE ROAD, THIRUMALAISAMUDRAM
Foreign Worker Education Institution Address Line 2:
