Fiscal Year

2021

Case Number

A-21032-47742

Case Status

Certified

Received Date

2021-03-16

Decision Date

2021-08-03

Refile

N

Original File Date

2021-01-01 09:55:36

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ELEVATE CREDIT SERVICE, LLC

Employer Name Slug

elevate-credit-service-llc

Employer Address 1

4150 INTERNATIONAL PLAZA

Employer Address 2

SUITE 300

Employer City

FT. WORTH

Employer City Slug

ft-worth

Employer State

TEXAS

Employer State Slug

texas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

76109

Employer Phone

8179281629

Employer Number of Employees

535

Employer Year Commenced Business

2014

NAICS Code

522291

FW Ownership Interest

N

Employer Contact Name

Elizabeth Wilson

Employer Contact Address 1

4150 International Plaza

Employer Contact Address 2

Suite 300

Employer Contact City

Ft. Worth

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

76109

Employer Contact Phone

8179281629

Employer Contact Email

ewilson@elevate.com

Agent Attorney Name

Amanda S Bolhuis

Agent Attorney Firm Name

Global Immigration Associates PC

Agent Attorney Phone

3127226300

Agent Attorney Address 1

230 W. Monroe St

Agent Attorney Address 2

Suite 2800

Agent Attorney City

Chicago

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60606

Agent Attorney Email

gov@giafirm.com

PW Track Number

P10020160635920

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

158142.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-11-18

PW Expiration Date

2021-06-30

Wage Offer From

158142.00

Wage Offer To

0.00

Average Salary

158142.00

Wage Unit of Pay

Year

Worksite Address 1

5080 Spectrum Drive

Worksite Address 2

Suite 200E

Worksite City

Addison

Worksite City Slug

addison

Worksite State

TEXAS

Worksite Postal Code

75001

Job Title

Tech Lead, Business Intelligence and Data Warehouse

Job Title Slug

tech-lead-business-intelligence-and-data-warehouse

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Computer Information Systems or related field

Required Training

N

Required Experience

Y

Required Experience Months

84

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

84

Accept Alternative Job Title

Sr. QA Analyst BIDW, Associate, QA Analyst, Senior Test Lead andor similar

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must have a Bachelors degree in Computer Science, Computer Information Systems or related, plus 7 years of experience in job offered or related role. Must have 7 years of experience in each of the following IT experience in validating data on Enterprise Datawarehouse, BI reporting and ETL; Creating, mapping, and building workflows, and monitoring session jobs in Informatica and SSIS; Strategic understanding of operating platforms such as Windows, Unix, Linux to validate files and file data and session logs for any failure in the informatica workflow; Building ETL and BI report automation for Installment Loan and Line of Credit financial products; Analyze the SSIS packages to understand the data transformation using Visual Basic and .Net Framework; Demonstrated experience leading and mentoring junior level associates in BIDW, ETL, reporting development and testing. Must have 5 years of experience in each of the following Expert knowledge in Business Intelligence reporting tool including Power BI and SQL Server Reporting Services SSRS; automating the data flow by loading and scheduling jobs on enterprise scheduling job repository tools such as ControlM; Handle file transfers using FTPSFTP to internal and external environment. Must have 3 years of experience in each of the following Expert ability in writing complex SQL and stored procedures to perform data completeness, correctness and transformation for source to target using RDBMS tools such as Microsoft SQL server; using Team Foundation Server TFS for Defect Management, Planning, and execution tracking. Employer will accept three or fouryear bachelors degree.

Combination Occupation

N

Offered to Applicant Foreign Worker

Y

Foreign Worker Live on Premises

N

Foreign Worker Live in Domestic Service

N

Foreign Worker Live in Domestic Service Count

Professional Occupation

Y

Application for College/University Teacher

N

SWA Job Order Start Date

2020-12-02

SWA Job Order End Date

2021-01-04

Sunday Edition Newspaper

Y

First Newspaper Name

The Dallas Morning News

First Advertisement Start Date

2020-12-20

Second Newspaper Ad Name

The Dallas Morning News

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-12-27

Employer Website From Date

2021-01-01 09:55:36

Employer Website To Date

2021-01-01 09:55:36

Professional Organization Ad From Date

2020-12-23

Professional Organization Advertisement To Date

2021-01-06

Job Search Website From Date

2020-12-21

Job Search Website To Date

2020-12-30

Employee Referral Program From Date

2021-01-01 09:55:36

Employee Referral Program To Date

2021-01-01 09:55:36

Local Ethnic Paper From Date

2021-01-01

Local Ethnic Paper To Date

2021-01-01

Radio/TV Ad From Date

2021-01-01 09:55:36

Radio/TV Ad To Date

2021-01-01 09:55:36

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

INDIA

Foreign Worker Birth Country

INDIA

Class of Admission

H-1B

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

BACHELOR OF SCIENCE ALSO SEE SECTION K

Foreign Worker Years of Education Completed

2001

Foreign Worker Institution of Education

ST ALOYSIUS COLLEGE MANGALORE UNIVERSITY

Foreign Worker Education Institution Address 1

HAMPANKATTA

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

MANGALORE

Foreign Worker Education Institution State/Province

KARNATAKA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

575003

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Amanda S Bolhuis

Preparer Title

Managing Attorney

Preparer Email

gov@giafirm.com

Employer Information Declaration Name

Elizabeth Wilson

Employer Information Declaration Title

Team Lead, Talent Acquisition