Dalmia Bharat Group Data Analyst Manager Interview Questions and Answers

Q1. What is LSTM and how is different with RNN
Add your answer
Q2. Tell me the NLP technique you used in past and explain
Add your answer

Q1. Tell me about Yourself.
Add your answer
Q2. Explain your Final Year Project
Add your answer

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. Basic questions tell about your self
Add your answer
Q2. Salary expectation and what skills do you have
Add your answer