The following are six core and key programming traits for a SharePoint architect:
PowerShell – script automations as well as ad-hoc aspects based on SharePoint logical architecture elements.
JavaScript – script aspect in order to use XML and JavaScript to render dynamic content.
SQL Server – know SQL queries as well as database architecture needed for SharePoint based support.
Web Services – knowledge of web services both from a fundamental and core connection-based standpoint is an important trait for a SharePoint architect.
CSS – knowledge of CSS is an important trait in order to display customized content experiences.
Infrastructure – knowledge of infrastructure is important in order to know what from a technical architecture standpoint is needed.