Fiscal Year

2021

Case Number

A-20336-27233

Case Status

Certified

Received Date

2021-01-29

Decision Date

2021-06-24

Refile

N

Original File Date

2021-01-01 09:42:20

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ASSOCIATION OF AMERICAN MEDICAL COLLEGES

Employer Name Slug

association-of-american-medical-colleges

Employer Address 1

655 K ST NW

Employer Address 2

Employer City

WASHINGTON

Employer City Slug

washington

Employer State

DISTRICT OF COLUMBIA

Employer State Slug

district-of-columbia

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

20001

Employer Phone

202-828-0400

Employer Number of Employees

694

Employer Year Commenced Business

1876

NAICS Code

813920

FW Ownership Interest

N

Employer Contact Name

Kaitlyn C Mahoney

Employer Contact Address 1

655 K St NW

Employer Contact Address 2

Employer Contact City

Washington,

Employer Contact State/Province

DISTRICT OF COLUMBIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

20001

Employer Contact Phone

202-862-6275

Employer Contact Email

kmahoney@aamc.org

Agent Attorney Name

Monique A van Stiphout

Agent Attorney Firm Name

Maggio Kattar

Agent Attorney Phone

(202) 483-0053

Agent Attorney Address 1

1800 Massachusetts Ave, NW

Agent Attorney Address 2

Suite 300

Agent Attorney City

Washington

Agent Attorney State/Province

DISTRICT OF COLUMBIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

20036

Agent Attorney Email

jdaperm@maggio-kattar.com

PW Track Number

P10020105485465

PW SOC Code

15-1199

PW SOC Title

Database Architects

PW Skill Level

Level IV

PW Wage

134722.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-07-28

PW Expiration Date

2021-06-30

Wage Offer From

175000.00

Wage Offer To

0.00

Average Salary

175000.00

Wage Unit of Pay

Year

Worksite Address 1

655 K Street, NW

Worksite Address 2

Suite 100

Worksite City

Washington

Worksite City Slug

washington

Worksite State

DISTRICT OF COLUMBIA

Worksite Postal Code

20001

Job Title

Enterprise Data Architect

Job Title Slug

enterprise-data-architect

Minimum Education

Bachelor's

Major Field of Study

See H.14.

Required Training

N

Required Experience

N

Required Experience Months

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

96

Accept Alternative Job Title

See H.14.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Bachelors degree or foreign equivalent in Information Technology, Computer Science, Electrical Engineering, or a closely related field followed by eight years of progressively responsible experience with enterprise data architecture.br br The position also requires experience with each of the followingbr 3 years of experience applying TOGAF methodology to Data domains.br 8 years of experience in end to end SDLC Application development processes.br 8 years of Data management and database development technologies and processes.br 8 years of experience in Data integration patterns and technologies.br 5 years of experience in industry standard ETL tools, such as Informatica.br 5 years of experience in building an Enterprise Data Lake, Data Ingestion patterns and Data Discovery.br 5 years of experience in standard modeling tool like Erwin to design and build data models.br 8 years of experience in relational database like Oracle andor Aurora.br 5 years of experience in a reporting tool like Business Objects or Tableau.br br Any amount of experience with each of the followingbr o Patterns with data domains, including structured, unstructured, transactional and analytical solutions.br o UML and objectoriented principles and design Canonical data models.br o AWS services, including S3, EC2, Glue, Lake formation, Aurora, Redshift, andor Athena.br o Enterprise service bus and enterprise messaging patterns.br o NOSQL databases, including MongoDB andor DynamoDB.br TOGAF Certification Required.

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-08-25

SWA Job Order End Date

2020-09-27

Sunday Edition Newspaper

Y

First Newspaper Name

The Washington Post

First Advertisement Start Date

2020-09-13

Second Newspaper Ad Name

The Washington Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-09-20

Employer Website From Date

2021-01-01 09:42:20

Employer Website To Date

2021-01-01 09:42:20

Professional Organization Ad From Date

2021-01-01 09:42:20

Professional Organization Advertisement To Date

2021-01-01 09:42:20

Job Search Website From Date

2021-01-01 09:42:20

Job Search Website To Date

2021-01-01 09:42:20

Employee Referral Program From Date

2020-09-02

Employee Referral Program To Date

2020-10-01

Local Ethnic Paper From Date

2020-09-18

Local Ethnic Paper To Date

2020-09-18

Radio/TV Ad From Date

2020-09-17

Radio/TV Ad To Date

2020-09-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

Bachelor's

Foreign Worker Information: Major

ELECTRICAL AND ELECTRONIC ENGINEERING

Foreign Worker Years of Education Completed

1997

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY, KUKATPALLY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Monique A van Stiphout

Preparer Title

Attorney

Preparer Email

jdaperm@maggio-kattar.com

Employer Information Declaration Name

Kaitlyn C Mahoney

Employer Information Declaration Title

Recruiter