Infra.Market Interview Questions, Process, and Tips

Distributor retail counter network, etc

Solving SQL problem on vehicle fuel theft finding

Q1. Designing end to end ETL and ELT for OLTP to OLAP
Ans. 
Designing ETL/ELT process to move data from OLTP to OLAP for analysis and reporting purposes.
• Identify data sources in OLTP database

• Extract data using ETL tools like Informatica or Talend

• Transform data to fit OLAP schema using SQL queries or data manipulation tools

• Load transformed data into OLAP database like Redshift or Snowflake

• Schedule regular updates to keep OLAP database current
Answered by AI
Add your answer

Q1. System design for rate limiter
Ans. 
Rate limiter system design involves setting limits on the number of requests a user can make within a certain time frame.
• Implement a token bucket algorithm to track and limit the number of requests per user.

• Use a distributed system to handle high traffic and prevent single points of failure.

• Consider using caching mechanisms to store and retrieve request limits efficiently.

• Monitor and adjust rate limits based on traffic...read more
Answered by AI
Add your answer

Q1. Asked about last company and position
Add your answer

Q1. Work of market in location
Ans. 
The work of the market in a location involves understanding the local consumer behavior, competition, and economic factors.
• Conduct market research to understand consumer preferences and buying habits

• Analyze competition to identify strengths and weaknesses

• Consider economic factors such as income levels and spending patterns

• Develop marketing strategies tailored to the specific location

• Monitor market trends and adjust str
Answered by AI
Add your answer
Q2. Work of experience
Add your answer

Q1. Past experience
Add your answer
Q2. Market knowledge
Add your answer