One technical and HR interview. Two guys intervied me at a time, it took around one hour for both SQL and SSIS. Asked to write many sample queries and almost covered all the scenarios coming under SQL developer role. And as my expected role is for Production support, the interviewer asked some about experience in documentation, Production support activities and troubleshooting, steps involved in doing enhancements etc.