Fiscal Year

2022

Case Number

A-20324-23282

Case Status

Certified-Expired

Received Date

2020-12-18

Decision Date

2021-10-21

Refile

N

Original File Date

2022-01-01 10:18:18

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

LINCOLN NATIONAL CORPORATION

Employer Name Slug

lincoln-national-corporation

Employer Address 1

150 RADNORCHESTER ROAD

Employer Address 2

Employer City

RADNOR

Employer City Slug

radnor

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

19087

Employer Phone

484-583-1400

Employer Number of Employees

9312

Employer Year Commenced Business

1905

NAICS Code

523930

FW Ownership Interest

N

Employer Contact Name

Dominick C Capozzola

Employer Contact Address 1

Lincoln National Corporation

Employer Contact Address 2

150 Radnor Chester Road

Employer Contact City

Radnor

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

19087

Employer Contact Phone

484-583-3795

Employer Contact Email

Dominick.Capozzola@lfg.com

Agent Attorney Name

Elise A Fialkowski

Agent Attorney Firm Name

Klasko Immigration Law Partners, LLP

Agent Attorney Phone

2158258647

Agent Attorney Address 1

1601 Market Street

Agent Attorney Address 2

Suite 2600

Agent Attorney City

Philadelphia

Agent Attorney State/Province

PENNSYLVANIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

19103

Agent Attorney Email

efialkowski@klaskolaw.com

PW Track Number

P10020127548648

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

67766.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-09-17

PW Expiration Date

2021-06-30

Wage Offer From

113776.00

Wage Offer To

140000.00

Average Salary

126888.00

Wage Unit of Pay

Year

Worksite Address 1

1301 S. Harrison Street

Worksite Address 2

Worksite City

Fort Wayne

Worksite City Slug

fort-wayne

Worksite State

INDIANA

Worksite Postal Code

46802

Job Title

Senior Analyst, Application Development

Job Title Slug

senior-analyst-application-development

Minimum Education

High School

Major Field of Study

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

84

Accept Alternative Job Title

Any occupation that provides required experience

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree or foreign equivalent in Computer Engineering or a closely related field and 5 years of experience using Informatica, Power Center 10, and SSIS to develop workflows to ETL data into operational data stores and data warehouses. In lieu of a Bachelors degree, employer will accept an additional 2 years of experience supporting ETL development. Experience must include 5 years developing and maintaining dimensional Star and Snowflake and Relational data models using Erwin and Oracle Data Modeler; utilizing Oracle, Informatica, Software Development Life Cycle SDLC legacy integration, batch data processing, and distributed scheduling and automation to integrate and extract data from various data sources; designing, developing, and delivering datacentric IT solutions, including relational databases, data warehouses, ELTETL processes, and reporting applications; performing data profiling for data quality, ETL and database performance tuning and optimization, and technical problem solving; and utilizing SQL and PLSQLs to write complex queries for data analytics and developing stored procedures, functions, and packages to retrieve data for reporting; 4 years utilizing SQL Server to integrate and extract data from various data sources; 3 years utilizing Big Data technologies, including Hadoop framework, Hive, Pig, Sqoop, Spark, and Impala to support corporate IT strategy migrating host data from onpremise to offpremise; designing and implementing Master Data Management schemas, rules, and processes within an Insurance company or comparable Financial Institution; utilizing Autosys or ControlM to design complex batch scheduling solutions addressing various types of dependencies; and providing technical solutions using Python, Perl, and Unix Scripting to augment and compliment ETL andor Batch Automation technologies. Work from home available up to 50 of the time.

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-07-13

SWA Job Order End Date

2020-08-17

Sunday Edition Newspaper

Y

First Newspaper Name

The Journal Gazette

First Advertisement Start Date

2020-07-19

Second Newspaper Ad Name

The Journal Gazette

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-07-26

Employer Website From Date

2020-07-13

Employer Website To Date

2020-08-17

Professional Organization Ad From Date

2022-01-01 10:18:18

Professional Organization Advertisement To Date

2022-01-01 10:18:18

Job Search Website From Date

2020-07-13

Job Search Website To Date

2020-07-28

Employee Referral Program From Date

2022-01-01 10:18:18

Employee Referral Program To Date

2022-01-01 10:18:18

Local Ethnic Paper From Date

2020-07-22

Local Ethnic Paper To Date

2020-07-22

Radio/TV Ad From Date

2022-01-01 10:18:18

Radio/TV Ad To Date

2022-01-01 10:18:18

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

High School

Foreign Worker Information: Major

GENERAL EDUCATION

Foreign Worker Years of Education Completed

2002

Foreign Worker Institution of Education

NRUPATUNGA DEGREE PG COLLEGE

Foreign Worker Education Institution Address 1

34373 374, LINGAMPALLI, KACHIGUDA

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500027

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Elise A Fialkowski

Preparer Title

Attorney

Preparer Email

efialkowski@klaskolaw.com

Employer Information Declaration Name

Dominick Capozzola

Employer Information Declaration Title

Vice President and Senior Counsel