I had a phone screen and then an on-site interview. The phone screen was pretty basic, with experience and behavioral related questions.

The on-site interview was a full day with three people interviewing. The first two were very technical and asked me questions about Informatica, SQL joins, optimization, and Perl scripts. It wasn't that hard, but not too easy either.

The last person was a manager and asked more about behavioral and coordination-related questions.

1. Write a script to remove duplicates from a file, identify outliers, replace them with a default value, and load the data into MySQL.

2. Which is the most cost-efficient transformation in Informatica, and what would you use instead to perform the same job more efficiently?

3. What is a "screw" in Teradata, how do you identify it, and how do you tune queries affected by it?