Codingmart Technologies Senior Analyst Interview Questions and Answers

Q1. Questions from Core Java. Theory and conceptual questions were asked. OOP concept important.
Add your answer

Q1. Basic questions and some situation based questions
Add your answer

Q1. Introduce Yourself
Ans. 
I am a data analyst with a background in statistics and experience in analyzing large datasets to drive business decisions.
• Graduated with a degree in Statistics

• Proficient in data analysis tools such as Python, R, and SQL

• Experience in creating visualizations to communicate insights

• Strong problem-solving skills
Answered by AI
Add your answer
Q2. Skills you have
Add your answer

Q1. Past work and guesstimates
Add your answer

Q1. Scenario based technical questions
Add your answer

Q1. Technical questions by vp
Add your answer

Q1. Basic hr questions like where would see yourself in 5 years
Add your answer

Q1. Technical skills required. Some questions of programming languages are asked.
Add your answer
Q2. What are the SQL command groups?
Ans. 
SQL command groups are DDL, DML, DCL, and TCL.
• DDL (Data Definition Language) - used to define database schema and structure

• DML (Data Manipulation Language) - used to manipulate data stored in the database

• DCL (Data Control Language) - used to control access to data stored in the database

• TCL (Transaction Control Language) - used to manage transactions in the database

• Examples: CREATE, ALTER, DROP (DDL); SELECT, INSERT, UP...read more
Answered by AI
Add your answer
Q3. Explain Object Oriented Programming in Python?
Ans. 
Object Oriented Programming is a programming paradigm that uses objects to represent real-world entities.
• Python supports OOP concepts such as encapsulation, inheritance, and polymorphism.

• Classes are used to create objects, which have attributes and methods.

• Inheritance allows for the creation of subclasses that inherit properties and methods from a parent class.

• Polymorphism allows for the use of a single method or funct...read more
Answered by AI
Add your answer
Q4. VLookup, Hlookup, Pivot Table in Excel
Add your answer

You will be asked to share the screen and write the codes as asked.

Q1. How to get the average of marks in excel
Ans. 
To get the average of marks in Excel, use the AVERAGE function.
• Select the range of cells containing the marks

• Type =AVERAGE(

• Select the range of cells again

• Close the parentheses and press Enter

• The average of the marks will be displayed
Answered by AI
View 1 more answer
Q2. How to get the roll numbers of same subjects
Ans. 
To get roll numbers of same subjects, filter the data by subject and extract roll numbers.
• Filter the data by subject using a loop or filter function

• Extract roll numbers of filtered data using map or forEach function

• Store the roll numbers in an array of strings
Answered by AI
Add your answer
Q3. Puzzles: suppose you have 10 boxes and each boxes contain 100 tablets.
Add your answer
Q4. Puzzle: Measure a time of 45 minutes by burning 2 ropes each of which takes 30 min.
Add your answer

Q1. The HR will keep on telling you what the company is, what the company does, how much they make per year, where they are located, and all history and stuff.
Add your answer

A video file which you need to hear and transcribe or translate into a preferred language.

Q1. Interview with reporting/project manager.
Add your answer
Q2. Your personal details
Add your answer
Q3. Educational and professional qualifications
Add your answer
Q4. Your CTC related information.
Add your answer