Info Edge Data Analytics Interview Questions and Answers

Q1. Apache Spark and it's working
Add your answer
Q2. Past Experience
Add your answer

Q1. Git version control question
Add your answer
Q2. Python med DSA question
Add your answer

Python DSA Leetcode style questions, prepare.

Majorly the interviews revolve around the following skills :
1. Advanced SQL
2. PYTHON (DSA)

Majorly the interviews revolve around the following skills :
1. Advanced SQL
2. python (DSA)

Q1. Which techniques you would have used on a system you have worked in the past to be able to optimise it further. (Deep knowledge of the databases is required)
Ans. 
I would have used indexing, query optimization, and data partitioning to optimize the system.
• Implement indexing on frequently queried columns to improve search performance.

• Optimize queries by using proper joins, filters, and aggregations.

• Partition large tables to distribute data across multiple storage devices for faster access.

• Use materialized views to precompute and store aggregated data for quicker retrieval.
Answered by AI
Add your answer
Q2. Situational questions on the ETL tools used and advantages and disadvantages of both
Add your answer

Q1. Describe a complex situation you were in at workplace and how did you handle it?
Ans. 
Handled a complex data migration project by breaking it down into smaller tasks and collaborating with team members.
• Identified key stakeholders and their requirements

• Developed a detailed project plan with timelines and milestones

• Assigned specific tasks to team members based on their strengths and expertise

• Regularly communicated progress updates and addressed any issues promptly
Answered by AI
Add your answer

Q1. Medium level DSA
Add your answer
Q2. 2 Medium SQL questions
Add your answer

Q1. Spark programming & Big Data concepts
Add your answer

Q1. Data Pipeline design
Add your answer

Q1. DE concepts, Previous Experience
Add your answer
Q2. Cultural and Team fitment
Add your answer

Q1. Explain data architecture of your project
Add your answer
Q2. Explain data lake
Add your answer

Q1. Introduce yourself
Ans. 
I am a data engineer with 5 years of experience in designing and implementing data pipelines for analytics.
• Experienced in ETL processes and data modeling

• Proficient in programming languages like Python and SQL

• Familiar with big data technologies such as Hadoop and Spark
Answered by AI
Add your answer
Q2. Talk about previous project
Ans. 
Developed a real-time data processing system for analyzing customer behavior
• Used Apache Kafka for real-time data streaming

• Implemented data pipelines using Apache Spark for processing large volumes of data

• Designed and optimized data models for efficient querying

• Integrated machine learning models for predictive analytics
Answered by AI
Add your answer

Q1. Work experince , resume walk thorugh
Add your answer
Q2. Location preferences,salary etc.
Add your answer

Q1. SQL,python coding round
Add your answer
Q2. Data warehousing concepts
Add your answer

Q1. SQL - Given 2 tables with some nullls and asked to output the count of rows we get for all types of joins
Add your answer
Q2. Types of joins and explain cross join
Ans. 
Types of joins in SQL include inner, outer, left, right, and cross join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Cross join: Returns the Cartesian produ
Answered by AI
Add your answer

Q1. Projects and impact
Add your answer