I got selected for both the technical rounds where the interviewer asked me about sorting algorithms, Normalization in database, few OS questions like diff b/w process and thread, about kernel, scheduling algorithms and Oops concepts (about abstract class, inheritance, encapsulation)
Olap vs oltp.. Start snowflake.. Different type of dimension table.. View vs mv.. Proc vs fucn
Data flow
1. In depth knowledge in Index 2. What are all dB check needs to do for informatica partition 3.dynamic lookup scenario 4. Getting data from Different time zone how to load single table 5.explain plan how to see 6.SQL query taking time to run what else db check needs to do...
Basic questions like : LookUp, SCD, Database
related to the previous work experience domain related questions ETL design
nothing they have asked
Very basic SQL queries
Little insight of your current project
Unix Questions on Transformations in Informatica SQL Queries
Viewing 111 - 120 interview questions