salesforce

You are working for a fictitious company called "XYZ Corp." This company has implemented an Accounts and Contacts management system for their customers. These Accounts and contacts are coming from Oracle ERP via integration in Salesforce Production. The company wants to keep their Accounts and Contacts neat and clean in Salesforce, especially emails addresses. The company wants to implement following changes:

If accounts and contacts are coming from Integration and if emails contain ‘. invalid’ at end of email address, then system should remove ‘.invalid‘ from Account and Contact emails and store in salesforce.
If Accounts and Contacts are created from Salesforce UI, then the system should not allow them to enter email address with ‘. invalid’ post fix.
Mask all the account and contact emails postfix with ‘. invalid’ post sandbox refresh.
Please make Email field required on Contacts for internal sales reps.
If email address is blank for existing contacts, populate email fields with contact owner’s email address. This should be a one-time task performed on all the contacts.