The main focus is SQL and Hadoop and a very few questions related to Informatica, but there are some brain storming questions but you will answer that questions if you have programming background,

Very Much Smooth. The interview round consists of 3 three phases Technical Assessment: The second round is often a technical assessment. This can take the form of a coding challenge or a take-home project that the candidate completes on their own time. The company evaluates the candidate's technical abilities, problem-solving skills, and understanding of key concepts related to data engineering. Technical Interview: The third round is typically a technical interview, where the candidate meets with members of the engineering team to discuss technical topics related to data engineering. This can include questions about database design, ETL pipelines, data warehousing, and cloud infrastructure. Final Interview: The final round is typically a meeting with senior leaders or executives at the company. This is an opportunity for the candidate to ask questions about the company's vision and strategy and to learn more about potential growth opportunities within the organization.