Case Details

Case info Company Info HR Info Attorney Position Info Employee Info
Case info
  • Data Publish Year :2022
  • Case Number:A-20328-24297
  • Case Status:Certified-Expired
  • Received Date:2020-12-28
  • Decision Date:2021-10-12
  • Refile:N
  • Original File Date:
  • Previous State Work Force Agency (SWA) Case Number Stete:
  • Schedule A or a Sheepherder Occupation :N
Company Info
  • Employer Name:FISERV SOLUTIONS, LLC.
  • Employer Address_Line 1:255 FISERV DR
  • Employer Address_Line 2:
  • Employer City :BROOKFIELD
  • State:
  • Employer State/ Province:WISCONSIN
  • Employer Country:UNITED STATES OF AMERICA
  • Employer Postal Code:53045
  • Employer Phone No.:262-879-5564
  • Employer Phone Extent No.:
  • Total Number of Employees:44000
  • Employer Year of Commenced :
  • NAICS Code:518210
  • Foreign Worker Ownership & Interest:N
HR Info
  • Employer Contact Name:Elizabeth Gall
  • Employer Contact Address Line1:255 Fiserv Dr
  • Employer Contact Address Line2:
  • Employer Contact City:Brookfield
  • Employer Contact State/ Provice:WISCONSIN
  • Employer Contact Country :UNITED STATES OF AMERICA
  • Employer Contact Post Code:53045
  • Employer Contact Phone:262-879-5564
  • Employer Contact Email:globalmobility.corporatehr@fiserv.com
Attorney
  • Agent/ Attorney Name:Brenda J Oliver
  • Agent/ Attorney Firm Name:Fragomen, Del Rey, Bernsen Loewy, LLP
  • Agent/ Attorney Phone:2022235515
  • Agent/ Attorney Phone Ext.:
  • Agent/ Attorney Address Line 1:1101 15th Street NW
  • Agent/ Attorney Address Line 2:Suite 700
  • Agent/ Attorney City:Washington
  • Agent/ Attorney State/ Province:DISTRICT OF COLUMBIA
  • Agent/ Attorney Country:UNITED STATES OF AMERICA
  • Agent/ Attorney Postal Code:20005
  • Agent/ Attorney Email:RecruitTeamPham@fragomen.com
Position Info
  • Prevailing Wage Track Number:P10020060362981
  • Prevailing Wage SOC Code :15-1199
  • Prevailing Wage SOC Title :Database Architects
  • Prevailing Wage Skill Level:Level I
  • Prevailing Wage:51958
  • Prevailing Wage Unit of Pay:Year
  • Prevailing Wage Source:OES
  • Prevailing Wage Other Source:
  • Prevailing Wage Determination Date :2020-05-20
  • Prevailing Wage Expiration Date :2020-08-18
  • Wage Offer From:52100
  • Wage Offer To:105000
  • Wage Offer Unit of Pay:Year
  • Workstie Address Line 1:255 Fiserv Drive and various unanticipated locations
  • Worksite Address Line 2:throughout the U.S. fulltime telework permitted
  • Worksite City :Brookfield
  • Worksite State:WISCONSIN
  • Worksite Postal Code:53045
  • Job Title:Database Analyst, Staff
  • Minimum Education:Bachelor's
  • Other Degree/ Diploma:
  • Major Field of Study:Information Technology, Engineering, or related field
  • Required Training:N
  • Required Training Month:
  • Required Field of Training:
  • Required Experience :N
  • Required Expreience Months :
  • 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:24
  • Accept Alternate Job Title:Development experience in an MS SQL Database Production Support Enterprise Environment
  • Normal Requirements of Job Opportunity:Y
  • Required Foreign Language:N
  • Specific Skills:Bachelors degree or equivalent in Information Technology, Engineering, or Related Field 2 Years of Development Experience in an MS SQL Database Production Support Enterprise Environment. Prior experience must also include troubleshooting SQL code and design, including functions, tables, and constraints; utilizing subscriber, publisher, and distributor terminology with BiDi Replication to identify and fix replication out of sync records; utilizing Redgate tool to identify and fix replication out of sync records; utilizing RESEED identity range for tables without affecting existing table identity range in BiDi Replication servers. Utilizing extract, transform, and load ETL to troubleshoot and resolve file loading failures; TSQL; creating and debugging SSIS; creating SSRS reports per business demands; Redgate, Splunk, and Foglight; 24 x 7 production support environment; working with vendors, partners, and customer IT teams to resolve high visibility and high priority issues; controls and regulatory compliance within the payment systems industry; SQL server 2012; 2 years of complex stored procedures, including data flow, logic, and ability to optimize and bypass issues; and 2 years in Financial Services Industry.br br J.12. Mr. Hemant Bapusaheb Patil earned a Bachelor of Engineering in Computer Engineering from the University of Pune in Pune, India, which is equivalent to a Bachelor of Science Degree in Computer Engineering from an accredited U.S. college or university.
  • 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:2020-07-22
  • Job Oder End Date:2020-08-24
  • Sunday Edition Newspaper:Y
  • First Newspaper Name:Milwaukee Journal Sentinel
  • First Advertisement Start Date:2020-07-26
  • Second Newspaper Name:Milwaukee Journal Sentinel
  • Second Advertisement Type:Newspaper
  • Second Ad Start Date:2020-08-02
  • Job Fair From Date:
  • Job Fair to Date:
  • On Campus Recruiting from Date:
  • On Campus Recruiting to Date:
  • Employer Website from Date:
  • Employer Website to Date:
  • Pro. Org. Ad from Date:
  • Pro.Org. Ad to Date:
  • Job Search Website from Date:2020-07-27
  • Job Search Website to Date:2020-08-03
  • Private Employment Firm from Date:
  • Pricate Employment Firm to Date:
  • Employee Referral Program from Date:2020-07-10
  • Employee Referral Program to Date:2020-07-30
  • Campus Placement from Date:
  • Campus Placement to Date:
  • Local Ethnic Newspaper from Date:2020-07-29
  • Local Ethnic Newspaper to Date:2020-07-29
  • 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:Y
  • US Worker Considered:Y
  • Country of Citizenship:INDIA
  • Foreign Worker Birth Country:INDIA
  • Class of Admission :H-1B
Employee Info
  • Foreign Worker Education:Bachelor's
  • Foreign Worker Education Other:
  • Foreign Worker Major:COMPUTER ENGINEERING
  • Year of Compelted Education:2011
  • Foreign Worker Istitution of Eduation:UNIVERSITY OF PUNE
  • Foreign Worker Education Instution Address Line 1:GANESHKHIND ROAD
  • Foreign Worker Education Institution Address Line 2:GANESHKHIND
  • Foreign Worker Education Institution City:PUNE
  • Foreign Worker Educatution Institution State: MAHARASHTRA
  • Foreign Worker Education Institution Country :INDIA
  • Foreign Worker Education Training Post Code:411007
  • Foreign Worker Training Completion :N/A
  • Foreign Worker Required Experience :N/A
  • Foreign Worker Alternate Education and Experience :N/A
  • Foreign Worker Alternate Occupation Experience:Y
  • Foreign Worker Experience with Employer:N
  • Foreign Worker Employer Pay for Education:N
  • Foreign Worker Currently Employed:Y
  • Employer Completed Application :N
  • Preparer Name:Brenda J Oliver
  • Preparer Title:Of Counsel
  • Preparer Email :RecruitTeamPham@fragomen.com
  • Employer Information Declaration Name:Jannette Matula
  • Employer Declaration Title:Sr. Consultant, HR Operations, Global Mobility
Back to Top

Contact Us : contact@iadapt.ca

Office Address : Social Innovation Hub Unit #290, 3553 31 St NW Calgary, AB, Canada T2L 2K7 (Please contact us in advance for visiting)