RailYatri Senior Data Analyst Interview Questions and Answers

SQL, excel, tableau , looker studio

Q1. What is your notice period.
Add your answer

Q1. Difference between Drop and Truncate ?
Ans. 
Drop deletes the table structure and data, while truncate only deletes the data.
• Drop is a DDL (Data Definition Language) command, while truncate is a DML (Data Manipulation Language) command.

• Drop removes the table from the database, while truncate only removes the rows from the table.

• Drop is slower and requires more permissions than truncate.

• Example: DROP TABLE table_name; TRUNCATE TABLE table_name;
Answered by AI
Add your answer
Q2. To write SQL queries
Add your answer

Q1. Why you are switching to non-core?
Ans. 
I am switching to non-core because I want to explore new opportunities and challenges outside of my current field.
• Seeking new challenges and opportunities

• Exploring different industries and roles

• Developing new skills and gaining diverse experience
Answered by AI
Add your answer
Q2. What are your expected salary?
Ans. 
I am looking for a competitive salary that reflects my skills and experience in the data analysis field.
• Research the average salary for Data Analysts in your area to have a realistic expectation

• Consider your level of experience, education, and any specialized skills you bring to the table

• Be prepared to negotiate based on the company's budget and benefits package
Answered by AI
Add your answer

Q1. They asked based on your resume few excel questions also
Add your answer
Q2. They explained about their company
Add your answer

Q1. About company little bit about project
Add your answer

It was a set of 10 questions for which I had to query through two SQL tables. 5 questions were 1 marks and 2 were 10 marks each. Total test was of 25 marks of which 23 was the passing marks. The 5 1 mark questions would be so easy, so 5 marks is ensured, the other 20 marks with 2 questions is the real challenge.

Q1. Tell us about your experiences so far.
Add your answer
Q2. What are your expectations from the job w.r.t learning and financials?
Add your answer

Q1. It was like an introduction with all the heads or deputies of all departments where they would interact and give their opinions after listening to your experiences and things you see how you would contribu...read more
Add your answer
Q2. They would also be checking your communication, so be confident with what you speak, its ok to speak pidgin, but keep what you speak simple and understandable.
Add your answer
Q3. Don't speak about finances here. Even if its asked by anyone, skip it or keep ot abstract by playing words, but never speak figures, like- as per industry standards or considering my experience and current...read more
Add your answer