SELECT Id, Name, Email FROM Contact WHERE
ID IN (SELECT Employee_ID__c FROM Employee_Skills__c WHERE Skill_ID__r.Name LIKE 'Apex')
OR
ID IN (SELECT Employee_ID__c FROM Employee_Training__c WHERE Training_ID__r.Name LIKE 'Salesforce')