MEDLINE INDUSTRIES
Talend ETL Developer III
A-22208-95964
H-1B
2023
Certified
Salary
$125,445
Visa Type
H-1B
Job Title
Talend ETL Developer III
Employee's Citizenship
INDIA
Graduate School
BANGALORE UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22208-95964
Case Status
Certified
Received Date
2022-07-27
Decision Date
2023-04-14
Refile
N
Original File Date
-
Previous State Work Force Agency (SWA) Case Number Stete
-
Schedule A or a Sheepherder Occupation
N
Company Info
14 fields
Employer Name
MEDLINE INDUSTRIES
Employer Address_Line 1
THREE LAKES DRIVE
Employer Address_Line 2
-
Employer City
NORTHFIELD
State
-
Employer State/ Province
ILLINOIS
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60093
Employer Phone No.
847-643-4309
Employer Phone Extent No.
-
Total Number of Employees
17200
Employer Year of Commenced
1966
NAICS Code
33911
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Jeremy L Parkin
Employer Contact Address Line1
Three Lakes Dr.
Employer Contact Address Line2
-
Employer Contact City
Northfield
Employer Contact State/ Provice
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
60093
Employer Contact Phone
847-643-4875
Employer Contact Email
immigration@medline.com
Attorney
11 fields
Agent/ Attorney Name
Danielle Gotcher
Agent/ Attorney Firm Name
Global Immigration Partners, Inc
Agent/ Attorney Phone
818-914-6482
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
30300 Agoura Road
Agent/ Attorney Address Line 2
Ste B100
Agent/ Attorney City
Agoura Hills
Agent/ Attorney State/ Province
CALIFORNIA
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
91301
Agent/ Attorney Email
perm@gip-us.com
Position Info
89 fields
Prevailing Wage Track Number
P10021252575329
Prevailing Wage SOC Code
15-1132
Prevailing Wage SOC Title
Software Developers, Applications
Prevailing Wage Skill Level
Level IV
Prevailing Wage
125445
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2022-03-14
Prevailing Wage Expiration Date
2022-06-30
Wage Offer From
125445
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
One Medline Place
Worksite Address Line 2
-
Worksite City
Mundelein
Worksite State
ILLINOIS
Worksite Postal Code
60060
Job Title
Talend ETL Developer III
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
Y
Accept Alternate Major
See H. 14
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
Y
Required Foreign Language
N
Specific Skills
Bachelors degree or higher in Computer Science, Information Technology, Computer Information Systems, Computer or Software Engineering, Electrical or Electronics Engineering, or any related IT or Engineering field of study, plus at least five 5 years of postdegree, progressively responsible experience in any related positions involving ETL tools.br br Qualified applicants must also have demonstrable proficiency, knowledge, skill, and experience with the followingbr br 1. Talend data integration development all basic Talend components Jobs, Joblets, Connections, Inputs, Outputs, Contexts, tMap, tSort, tDie, and tWarn.br 2. Demonstrated ability with various mapping scenarios database to database, file to database, database to file, rest services and web services etc. FTP usage.br 3. Demonstrated ability combining data from multiple sources into a single target destination system.br 4. Creating complex data transformations and validations incorporating business logic.br 5. Demonstrated ability incorporating robust logging into Talend job development.br 6. Oracle SQL and MSSQL statements corresponding Talend Components.br 7. Migration of Talend jobs across various environments DEVTSTPRDbr 8. Generating deploying jobs in Talend Administration Center.br 9. ParameterizationParallelization and performance optimization.br br No travel; no telecommuting.
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
2022-04-28
Job Oder End Date
2022-06-01
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago SunTimes
First Advertisement Start Date
2022-05-08
Second Newspaper Name
Chicago SunTimes
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-05-15
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
2022-04-26
Job Search Website to Date
2022-05-10
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
2022-04-26
Employee Referral Program to Date
2022-05-10
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
2022-05-12
Local Ethnic Newspaper to Date
2022-05-12
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
24 fields
Foreign Worker Education
Master's
Foreign Worker Education Other
-
Foreign Worker Major
COMPUTER APPLICATIONS US EQUIV MS IN COMPUTER INFORMATION SYSTEMS
Year of Compelted Education
2005
Foreign Worker Istitution of Eduation
BANGALORE UNIVERSITY
Foreign Worker Education Instution Address Line 1
MYSORE RD, JNANA BHARATHI
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
BENGALURU
Foreign Worker Educatution Institution State
KARNATAKA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Training Post Code
560056
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N
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
Danielle Gotcher
Preparer Title
Attorney
Preparer Email
perm@gip-us.com
Employer Information Declaration Name
Jeremy L Parkin
Employer Declaration Title
Global Mobility Specialist