The technical round focused mainly on core Informatica concepts, including mapping design, transformation logic, parameterization, and performance tuning techniques. I was asked to explain different SCD types, implement lookup and joiner transformations in real-time scenarios, and troubleshoot mapping errors. SQL-related questions included writing complex queries, using window functions, joins, and handling duplicate records. They also tested my understanding of optimization techniques .