All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20072-29864
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-20072-29864
Case Status
Certified
Received Date
2020-04-07
Decision Date
2020-08-28
Refile
N
Original File Date
2020-01-01 19:54:09
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
FLAGSTAR BANK, FSB
Employer Name Slug
flagstar-bank-fsb
Employer Address 1
5151 CORPORATE DRIVE
Employer Address 2
Employer City
TROY
Employer City Slug
troy
Employer State
MICHIGAN
Employer State Slug
michigan
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
48098
Employer Phone
248 312 2000
Employer Number of Employees
2753
Employer Year Commenced Business
1987
NAICS Code
522120
FW Ownership Interest
N
Employer Contact Name
Kim A Bostwick
Employer Contact Address 1
5151 Corporate Drive
Employer Contact Address 2
Employer Contact City
Troy
Employer Contact State/Province
MICHIGAN
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
48098
Employer Contact Phone
248-312-5605
Employer Contact Email
kim.bostwick@flagstar.com
Agent Attorney Name
Rona M Lum
Agent Attorney Firm Name
Law Offices of Rona M. Lum
Agent Attorney Phone
2483401854
Agent Attorney Address 1
Law Offices of Roan M. Lum, P.C.
Agent Attorney Address 2
691 N. Squirrel Road, Ste. 185
Agent Attorney City
Auburn Hills
Agent Attorney State/Province
MICHIGAN
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
48326
Agent Attorney Email
rlum@corpimmigration.us
PW Track Number
P10019303116551
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level IV
PW Wage
111072.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-02-25
PW Expiration Date
2020-06-30
Wage Offer From
111072.00
Wage Offer To
0.00
Average Salary
111072.00
Wage Unit of Pay
Year
Worksite Address 1
5151 Corporate Drive
Worksite Address 2
Worksite City
Troy
Worksite City Slug
troy
Worksite State
MICHIGAN
Worksite Postal Code
48098
Job Title
Sr. Data Developer
Job Title Slug
sr-data-developer
Minimum Education
Bachelor's
Major Field of Study
Computer Science, Mathematics or Engineering Computer, Electrical or Electronics
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
84
Accept Alternative Job Title
any suitable IT position utilizing the stated skill sets in Section H. 14.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors Degree in Computer Science, Mathematics or Engineering Computer, Electrical, or Electronics or foreign educational equivalent and 7 years of development experience designing, developing, testing and implementing Extract, Transform and Load ETL solutions using enterprise ETL tools preferably IBM Datastage and Oracle PLSQL. Of the required 7 years, 2 years must include experience working with Business Intelligence tools IBM Cognos is preferred. Expertise in Relational Database Management System, Data Mart and Data Warehouse design is a plus.br br EXPLANATION OF BUSINESS NECESSITY FOR EXPERIENCE REQUIREMENTbr br Flagstar Bank, FSB the Bank is a whollyowned subsidiary of Flagstar Bancorp, Inc., a Michiganbased savings and loan holding company. Flagstar Bank is a federally chartered stock savings bank founded in 1987.br br We offer a wide range of financial products and services for individuals and businesses, from consumer loans and credit cards to cash management and merchant services. We bring the full resources of a commercial bank to our customers. We are also a national leader in home lending with loan centers across the country.br br Senior Data Developer with Flagstar Bank is a position that requires an individual with an advanced level of knowledge and development experience designing, developing, testing and implementing Extract, Transform and Load ETL solutions using enterprise ETL tools preferably IBM Datastage and Oracle PlSQL. The individual must have the ability to implement technology solutions in a cost effective manner and effectively provide data integration architecture leadership across the enterprise. The individual must possess sophistication in complex technologyrelated subject matter to effectively respond to inquiries from internal and external stakeholders, as required.br br It is necessary that the qualified individual possess, at a minimum, a Bachelors Degree in Computer Science, Mathematics or Engineering Computer, Electrical, or Electronics or foreign educational equivalent and a minimum of seven 7 years of development experience designing, developing, testing and implementing Extract, Transform and Load ETL solutions using enterprise ETL tools preferably IBM Datastage and Oracle PlSQL. Of the required 7 years, 2 years must include experience working with Business Intelligence tools IBM Cognos is preferred. Due to the highly technical nature of the duties, expertise in Relational Database Management System, Data Mart and Data Warehouse design is a plus.br br Through the required formal education and experience, an individual acquires the technical skills and ability to develop and ensure the proper implementation of effective technology solutions for various lines of business within the Bank. These skills are essential to effectively fulfill the technical duties and responsibilities of a Senior Data Developer with Flagstar Bank.
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
2019-11-07
SWA Job Order End Date
2019-12-10
Sunday Edition Newspaper
Y
First Newspaper Name
Detroit News and Free Press
First Advertisement Start Date
2019-11-03
Second Newspaper Ad Name
Detroit News and Free Press
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-11-10
Employer Website From Date
2019-11-06
Employer Website To Date
2019-12-06
Professional Organization Ad From Date
2020-01-01 19:54:09
Professional Organization Advertisement To Date
2020-01-01 19:54:09
Job Search Website From Date
2019-11-03
Job Search Website To Date
2019-12-03
Employee Referral Program From Date
2020-01-01 19:54:09
Employee Referral Program To Date
2020-01-01 19:54:09
Local Ethnic Paper From Date
2020-01-01 19:54:09
Local Ethnic Paper To Date
2020-01-01 19:54:09
Radio/TV Ad From Date
2020-01-01 19:54:09
Radio/TV Ad To Date
2020-01-01 19:54:09
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 ELECTRONICS ENGINEERING
Foreign Worker Years of Education Completed
2009
Foreign Worker Institution of Education
ANNA UNIVERSITY
Foreign Worker Education Institution Address 1
SARDAR PATEL ROAD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CHENNAI
Foreign Worker Education Institution State/Province
TAMILNADU
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
600025
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Rona M Lum
Preparer Title
Attorney
Preparer Email
rlum@corpimmigration.us
Employer Information Declaration Name
Kim Bostwick
Employer Information Declaration Title
HR Executive Administrative Assistant