AKB Glass System Data Engineer Interview Questions and Answers

Sql, nodejs JavaScript

Q1. Joins in sql, differences between join
Add your answer
Q2. Sql query functions used in sql
Add your answer

Q1. Explain about some of visualization tools
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. Does the company follows the legal or constitution right if the critical situation?
Ans. 
Yes, the company follows legal and constitutional rights in critical situations.
• The company has policies and procedures in place to ensure compliance with legal and constitutional rights.

• In critical situations, the company may consult legal counsel to ensure actions are in accordance with the law.

• Employees are trained on legal and ethical standards to handle critical situations appropriately.
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

Q1. Why do u choose this job
Add your answer

Q1. Advance excel vlookup hlookup sumproduct
Add your answer
Q2. Pivot table and all the question about excel
Add your answer