Neolytix Senior Associate Interview Questions and Answers

Simple test with basic questions and reasoning.

Q1. Mostly based on resume and sql questions along with some easy questions related to project .
Add your answer
Q2. Snowflake , Python SQL joins ? Tbl A ->1,1,1,null Tbl B ->1,null,1,1 What will be the output for each join and write those outputs.
Add your answer

Q1. Techno Managerial round mostly focused on sql , and database design .
Add your answer
Q2. You would be given a scenario for which you would be asked to design a database and based on that design you will be asked few questions.
Add your answer
Q3. Snowflake time travel ?
Add your answer

Q1. Basic hr questions were asked .
Add your answer

Very basic aptitude questions in a live mettle like platform

Q1. Questions on regression and patient data.
Add your answer

Q1. General check for cultural fit
Add your answer

Q1. Scd type 1, 2,3,4
Add your answer
Q2. Joins, left,right,full,cross
Add your answer

Q1. General topics like previous projects and managerial questions
Add your answer
Q2. Managerial questions to know you
Add your answer

Q1. Salary discussion
Add your answer
Q2. Culture about Axtria and policies
Ans. 
Axtria promotes a collaborative and inclusive culture with a focus on innovation and growth.
• Axtria values diversity and inclusion in the workplace

• The company encourages innovation and creativity

• There are policies in place to support employee growth and development

• Axtria promotes a collaborative work environment
Answered by AI
Add your answer

Q1. Related to MDM and IICs And ETL and SQL
Add your answer

Q1. About IC design
Add your answer
Q2. Resume based questions
Add your answer

The Aptitude round was of mediocre level, get well prepared for it and it is a qualifying round

Q1. Project Related Questions
Add your answer
Q2. Data Warehouse and modeling related questions, along with schema selection in various scenarios
Add your answer

Q1. About Myself, Why Axtria, Pharma related questions
Add your answer
Q2. Real life scenarios
Add your answer

Logical, statistics, Aptitude, Data science and analytics

Q1. Difference between Delete and Truncate in SQL
Ans. 
Delete removes specific rows from a table, while Truncate removes all rows from a table.
• Delete is a DML command, while Truncate is a DDL command.

• Delete can be rolled back, while Truncate cannot be rolled back.

• Delete maintains the table structure and indexes, while Truncate resets the table structure and indexes.

• Delete triggers delete triggers and delete constraints, while Truncate does not trigger any triggers or const...read more
Answered by AI
Add your answer
Q2. Assumptions of regression
Ans. 
Assumptions of regression
• Linearity: The relationship between the independent and dependent variables is linear.

• Independence: The residuals are independent of each other.

• Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.

• Normality: The residuals are normally distributed.

• No multicollinearity: The independent variables are not highly correlated with each other.
Answered by AI
Add your answer

General aptitude test on an online platform with camera and mic monitoring.

Q1. One on one round with manager and senior manager. Basic questions about day to day responsibilities and tech stack.
Add your answer