Prevailing Wage SOC Title :Software Developers, Applications
Prevailing Wage Skill Level:
Prevailing Wage:134399
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:Employer Conducted
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-03-19
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:134399
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:6303 Owensmouth Ave
Worksite Address Line 2:
Worksite City :Woodland Hills
Worksite State:CALIFORNIA
Worksite Postal Code:91367
Job Title:Application Subject Matter Expert IV
Minimum Education:Bachelor'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 :60
Accept Alternate Field of Study:N
Accept Alternate Major:
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:60
Accept Alternate Job Title:See H.14
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Position requires a Bachelors degree, or foreign equivalent, in Computer Science, Electronics Engineering, Electrical Engineering, or a closely related field of study, plus 5 years of experience in the job offered, or as an Application Subject Matter Expert II, Programmer Analyst, Sr. Programmer Analyst, or similar position. Specific experience must include working in the Property and Casualty insurance; working with Policy and Claims management lifecycles; working with Informatica and other ETL tools; working with SQL; working with analytical reporting requirements and tool such as Power BI, Tableau, and Business Objects; working with Snowflake, Oracle, and DB2; working with relational data bases, data warehouse concepts, star schemas, and architecture best practices; developing architectural roadmap for data reconciliation, automation, and data quality; working with and conducting the Software Development Life Cycle SDLC; optimizing complex ETL code in consideration to Cloud platforms; working with all levels of the IT and business units including business subject matter experts to drive analysis and data provisioning requirements; and facilitating discussions with complex technical content. Must be willing to occasionally travel within the U.S. Option to work remotely is available. NOTE This PERM position is a future position. Mr. Bondugula is currently working for the same employer in a similar Application Subject Matter Expert III position remotely from his home location in Newark, DE, and may continue working remotely for the PERM position as permitted by this PERM position.
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:2021-01-14
Job Oder End Date:2021-02-15
Sunday Edition Newspaper:Y
First Newspaper Name:Los Angeles Times
First Advertisement Start Date:2021-02-07
Second Newspaper Name:Los Angeles Times
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-02-14
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-01-13
Employer Website to Date:2021-04-02
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-02-08
Job Search Website to Date:2021-02-12
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:2021-03-19
Local Ethnic Newspaper to Date:2021-03-25
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
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:ELECTRICAL ENGINEERING
Year of Compelted Education:2006
Foreign Worker Istitution of Eduation:NEW MEXICO STATE UNIVERSITY
Foreign Worker Education Instution Address Line 1:1780 E UNIVERSITY AVE
Foreign Worker Education Institution Address Line 2: