SLALOM, LLC
Technology Consultant
A-22278-33899
H-1B
2023
Certified
Salary
$168,709
Visa Type
H-1B
Job Title
Technology Consultant
Employee's Citizenship
INDIA
Graduate School
ANNA UNIVERSITY CHENNAI
Case info
9 fields
Data Publish Year
2023
Case Number
A-22278-33899
Case Status
Certified
Received Date
2022-10-28
Decision Date
2023-09-20
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
SLALOM, LLC
Employer Address_Line 1
821 2ND AVENUE
Employer Address_Line 2
STE. 1900
Employer City
SEATTLE
State
-
Employer State/ Province
WASHINGTON
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
98104
Employer Phone No.
(206) 438-5700
Employer Phone Extent No.
-
Total Number of Employees
10720
Employer Year of Commenced
1993
NAICS Code
541611
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Wendy Symms
Employer Contact Address Line1
821 2nd Avenue
Employer Contact Address Line2
Ste. 1900
Employer Contact City
Seattle
Employer Contact State/ Provice
WASHINGTON
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
98104
Employer Contact Phone
(206) 268-6842
Employer Contact Email
wendy.symms@slalom.com
Attorney
11 fields
Agent/ Attorney Name
Yvonne A Toy
Agent/ Attorney Firm Name
Corporate Immigration Partners, LLC
Agent/ Attorney Phone
4157717500
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
465 California Street
Agent/ Attorney Address Line 2
Ste.700
Agent/ Attorney City
San Francisco
Agent/ Attorney State/ Province
CALIFORNIA
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
94104
Agent/ Attorney Email
slalom@cipllp.com
Position Info
89 fields
Prevailing Wage Track Number
P10022046904709
Prevailing Wage SOC Code
15-1252.00
Prevailing Wage SOC Title
Software Developers
Prevailing Wage Skill Level
Level IV
Prevailing Wage
168709
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-08-17
Prevailing Wage Expiration Date
2023-06-30
Wage Offer From
168709
Wage Offer To
173709
Wage Offer Unit of Pay
Year
Workstie Address Line 1
821 Second Avenue
Worksite Address Line 2
-
Worksite City
Seattle
Worksite State
WASHINGTON
Worksite Postal Code
98104
Job Title
Technology Consultant
Minimum Education
Master'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
84
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
84
Accept Alternate Job Title
technicaltechnology leadrelated occupation
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
Minimum Requirementsbr Masters degree in Computer Science, Computer Engineering, or related field and 7 years of experience in the job offered or in a technicaltechnology leadrelated occupation.br br Must be available to work on projects at various, unanticipated sites within commuting distance of Slalom, LLCs Seattle, WA office and throughout the United States. Some telecommuting is permitted.br br Special Requirementsbr Position requires at least 7 years of experience in each of the following skillsbr br 1 Involved in requirements gathering, analysis and perform impact analysis from scratch with PMs and partners.br 2 Develop customized ETL Extract, Transform and Load components using C#.Net for data acquisition from variety of heterogeneous source e.g. TFS, VSO, SQL, 1CS API, Excel and JSON.br 3 Created Azure Data Factory pipelines to move data from OnPremises to Azure SQL and from Azure SQL to Cosmos endpoints to make sure data sync between source and PowerBI reports and downstream applications.br 4 Extracted data from various source and staged in a staging database and performed various harmonization transformations with Organization, Requirement, Product etc. using extensive SQL complex queries. and load data into the SQL Data Warehouse and exposed the data SQL Azure and Azure and Analysis Service.br 5 Created SSIS packages using various SSIS tasks like execute SQL task, bulk insert task, data flow task, file system task, send mail task, active script task after processing data from external sources.br br Position also requires at least 1 year of experience in each of the following skillsbr 6 Partnering with leadership, engineers, program managers, and data scientists to understand data needs.br 7 Design and build solutions using technologies includes Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Data Bricks, , Azure Stream Analyticsbr 8 Create and manage Databricks notebook for ELTETL and scheduling the jobs in triggered or eventbased or tumbling windows automation.br 9 Build and manage CICD pipelines in Azure DevOps for all code releases and deployment UAT and Production environments.br 10 Design and implement Cosmos Script iSope, USQL to extract data from various files in a different format in Azure Data Lake Analytics and processed the data in SQL Warehouse.
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-05-13
Job Oder End Date
2022-06-14
Sunday Edition Newspaper
Y
First Newspaper Name
The Seattle Times
First Advertisement Start Date
2022-05-22
Second Newspaper Name
The Seattle Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-05-29
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
2022-05-20
Pro.Org. Ad to Date
2022-05-29
Job Search Website from Date
2022-05-11
Job Search Website to Date
2022-05-27
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
2022-05-27
Local Ethnic Newspaper to Date
2022-06-02
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
APPLIED COMPUTER SCIENCE
Year of Compelted Education
2010
Foreign Worker Istitution of Eduation
ANNA UNIVERSITY CHENNAI
Foreign Worker Education Instution Address Line 1
GUINDY
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
CHENNAI
Foreign Worker Educatution Institution State
TAMIL NADU
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Training Post Code
600025
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
Yvonne A Toy
Preparer Title
Partner
Preparer Email
slalom@cipllp.com
Employer Information Declaration Name
Wendy Symms
Employer Declaration Title
Immigration Specialist