Infonative Solutions Analyst Interview Questions and Answers

SQL -- LeetCode style questions Medium lvl

Q1. Past experiences
Add your answer
Q2. How one can help with eshopbox
Ans. 
One can help with eshopbox by analyzing data to improve customer experience and optimize sales.
• Conduct data analysis to identify trends and patterns in customer behavior

• Use data to personalize marketing strategies and recommend products to customers

• Optimize website layout and user experience based on data insights

• Implement data-driven pricing strategies to maximize sales and profits
Answered by AI
Add your answer

Q1. I will explain about interview
Add your answer
Q2. Please give interview
Add your answer
Q3. No response, disconnected
Add your answer

SQL, excel, tableau , looker studio

Q1. What is your notice period.
Add your answer

1 hour duration. Normal aptitude test

Q1. What is testing?
Ans. 
Testing is the process of evaluating a system or application to identify defects or errors.
• Testing involves executing a system or application to find bugs or issues.

• It ensures that the software meets the specified requirements and functions correctly.

• Types of testing include unit testing, integration testing, system testing, and acceptance testing.

• Examples of testing tools include Selenium, JUnit, and TestNG.
Answered by AI
Add your answer
Q2. Linux based questions
Add your answer

Q1. Everything you have in the resume
Add your answer
Q2. Test case scenarios
Add your answer

Q1. Medium level SQL question
Add your answer
Q2. Case study on Bigbasket/Instagram
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

Q1. Write an email to a client
Ans. 
Email template for client communication
• Start with a friendly greeting

• Provide a brief introduction or reminder of the purpose of the email

• Include any necessary information or updates

• End with a call to action or next steps

• Sign off with a professional closing
Answered by AI
Add your answer

Process Enhancement and Customer Success task