1)how do u flatten json nested structure in spark, 2)delete columns based on some conditions in spark, 3)sqoop export with incremental loading 4)datetime related querstions in python 5)problem and need to solve in java 6)lot of scenario based questions related to RDBMS vs Hadoop choice
Technical: Some questions on Spark, SQL, Python, AWS Behavioral: 1 thing u will miss from your previous organisations
How do you manage to build an scalable data pipeline :)
Mostly focusing on my experience and my solution
Can you tell me about yourself?
Tech Round (Python Coding for API Integration): Write Python code to fetch data from an API endpoint and process it. How would you handle pagination when fetching data from an API? System Design (Data Warehouse - DWH): Design a Data Warehouse (DWH) architecture for a large-scale dataset. What are the key components you would include in a DWH design and why? How would you ensure data quality and integrity in a DWH? SQL Question (5-part question): Write complex SQL queries for data manipulation or retrieval. Hiring Manager Interview (Experience-focused): Can you describe your experience with [specific technology or project]? How did you handle challenges in your previous roles? How do you prioritize tasks and manage time when working on complex projects? Director of Analytics (Behavioral Interview): Tell me about a time you worked under pressure and how you managed the situation. How do you handle conflict in a team? Can you describe a situation where you had to make a tough decision at work?
Pyspark python sql about the project ques
Tell me about your experience, where you started and brought you until this stage of your career.
In my opinion, the pivotal question influencing the hiring decision was the one assessing my knowledge of PostgreSQL databases.
Behaviour questions are shared before the interview, if the interviewer is not interested in listening, it doesn’t matter how well it was presented !
Viewing 2111 - 2120 interview questions