AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Ramco Systems Program Analyst Interview Questions, Process, and Tips for Experienced
Ramco Systems Program Analyst Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
6 Questions
- Q1. Tell what you know abt react
- Ans.
React is a JavaScript library for building user interfaces.
React allows for building reusable UI components.
It uses a virtual DOM for efficient rendering.
React can be used with other libraries and frameworks.
It follows a unidirectional data flow pattern.
React Native allows for building mobile apps using React.
JSX is used to write HTML-like syntax in JavaScript.
- Q2. How useref used?
- Ans.
useref is used to access the DOM nodes or state values of child components in a parent component.
useref is a hook in React that returns a mutable ref object
It can be used to access the DOM nodes of child components in a parent component
It can also be used to access state values of child components in a parent component
Example: const childRef = useRef(); childRef.current.doSomething();
- Q3. What is redux nd redux saga
- Ans.
Redux is a state management library for JavaScript apps. Redux Saga is a middleware for Redux that handles side effects.
Redux is used to manage the state of an application in a predictable way
Redux Saga is a middleware that allows for handling side effects such as asynchronous API calls
Redux Saga uses generator functions to make asynchronous code easier to read and test
Redux Saga can be used to handle complex workflows
- Q4. And real-time scenario based qns like how will you render nested objects as table
- Q5. Finally what is your hobby
- Q6. Then do you have any qns to us.
- Ans.
Yes, I have a few questions regarding the role and responsibilities of a Program Analyst.
Can you provide more information about the specific projects I will be working on?
What is the team structure like and who will I be reporting to?
What are the key performance indicators for this role?
How does the company measure success for this position?
What opportunities are there for growth and development within the company?
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I appeared for an interview before Mar 2021.
(3 Questions)
Round duration - 60 minutes
Round difficulty - Easy
This was a technical round with questions on DBMS.
- Q1. What is data integrity?
- Ans.
Data integrity refers to the accuracy, consistency, and reliability of data throughout its lifecycle.
Data integrity ensures that data is accurate and consistent in storage and transmission.
It involves maintaining the quality and reliability of data over time.
Methods for ensuring data integrity include checksums, encryption, and error detection codes.
Examples of data integrity violations include data corruption, unautho
- Q2. What is a trigger in the context of a database management system?
- Ans.
A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.
Triggers are used to enforce business rules, maintain data integrity, and automate repetitive tasks.
They can be triggered by INSERT, UPDATE, or DELETE operations on a table.
Examples of triggers include auditing changes to a table, updating related tables when a record is modified, or enforcing referential
- Q3. What is the difference between clustered and non-clustered indexes in a database management system?
- Ans.
Clustered indexes physically order the data in the table, while non-clustered indexes do not.
Clustered indexes determine the physical order of data in the table, while non-clustered indexes do not.
A table can have only one clustered index, but multiple non-clustered indexes.
Clustered indexes are faster for retrieval of data, especially range queries, compared to non-clustered indexes.
Non-clustered indexes are stored se...
(3 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical interview round with questions on DBMS.
- Q1. What is the difference between UNION and UNION ALL in SQL?
- Ans.
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
UNION merges the result sets of two or more SELECT statements and removes duplicates.
UNION ALL merges the result sets of two or more SELECT statements without removing duplicates.
UNION is slower than UNION ALL as it involves removing duplicates.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column...
- Q2. What are the functions of a cursor in PL/SQL?
- Ans.
A cursor in PL/SQL is used to retrieve and process multiple rows of data one at a time.
Allows iteration over a result set
Retrieves data row by row
Can be used to update or delete rows in a table
Must be declared, opened, fetched, and closed
- Q3. Write a SQL query to fetch the nth highest salary from a table.
- Ans.
SQL query to fetch the nth highest salary from a table
Use the ORDER BY clause to sort salaries in descending order
Use the LIMIT clause to fetch the nth highest salary
Round duration - 30 minutes
Round difficulty - Easy
This was a managerial round with typical behavioral problems.
Interview Preparation Tips
Tip 1 : Since this was a SQL post, I would suggest you to get the basics intact and try practicing few queries.
Tip 2 : Must do Previously asked Interview as well as Online Test Questions.
Tip 3 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
mahesh mahe
I appeared for an interview in Jan 2021.
Interview Questionnaire
1 Question
- Q1. One Program with c#
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Salary discussion and notice period
- Q2. Core java, collections and coding
Interview Preparation Tips
Experience: About project and previous company experience , daily activity
Interview Preparation Tips
Experience: Approx. 30.questions in 50 min
Tips: Try solving each que in less than a minute ,don't waste time on difficult questions, complete easier once first
Duration: 50 minutes
Total Questions: 30
College Name: Pimpri chinchwad college of engineering
Sahil Chhabra
Interview Questionnaire
1 Question
- Q1. For me there was just one interview combined of guesstimates and Puzzles
Interview Preparation Tips
Experience: Consisted of 5 sections - English, Quant, Logical Reasonong, Statistics, Probability/Analytical questions. 10 questions per section. Medium level difficulty. It was followed by an subjective test by 1 question. The question was describe the most challenging experience while working in a Team.10 mins for this question
Tips: Practise Quant and logical reasoning. Stay focussed and confident.
Duration: 60 minutes
Total Questions: 50
Round: Group Discussion
Experience: First 1 min everyone has to speak then the group has to conclude in last 5 mins.
Tips: Reading newspaper is a must.
Duration: 20 minutes
Round: Interview
Experience: 1. Estimate the length of your hairs.2. What will you infer from the data of your collage (if provided) consisting of name contact details rank and sitting/not sitting for placements.3. Divide a disk/circle into 8 equal parts.4. 100 coins to be put into infinite boxes. How to place so that by just taking the EXACT number of boxes I can have money of any denomination under 100.5. 10% discount followed by 15% discount and then vice-versa. Which is better for shopekeeper?
Tips: Ans to last 33. three cuts4. 1 2 4 8 16 32 375. same for both
General Tips: Read about the company and work profile before hand. It helps a lot to frame the answer of Why Axtria?
Skill Tips: Practise and stay confident
Skills: Quantitative, communication skills
College Name: IIT Kharagpur
Motivation: Analytical job. Tremendous growth opportunities.
P B Viswa Vardhan
Interview Questionnaire
14 Questions
- Q1. He gave me a puzzle to solve
- Q2. What is your GRE score ?
- Ans.
I apologize, but I do not have a GRE score as it is not applicable to my role as a Business Analyst.
As a Business Analyst, my skills and experience are evaluated through my work history, education, and certifications.
GRE scores are typically required for admission to graduate programs, but not for a Business Analyst position.
My focus is on utilizing my analytical and problem-solving skills to support business decisions
- Q3. What is your CAT score ?
- Ans.
CAT score is not applicable for a Business Analyst role.
CAT score is a standardized test for admission to management programs.
It is not relevant for a Business Analyst role.
Business Analysts require skills in data analysis, problem-solving, and communication.
Other relevant qualifications for a Business Analyst role include a degree in business, economics, or a related field, and experience in data analysis or project m
- Q4. Why do you want to join our firm?
- Ans.
I am impressed with the company's reputation and growth potential.
Your company has a strong reputation in the industry.
I am excited about the opportunity to work with a talented team.
I believe your company's growth potential aligns with my career goals.
Your company's values and mission resonate with me.
I am impressed with the innovative projects your company is working on.
- Q5. Who is the CEO of our company ?
- Ans.
I'm sorry, I don't have access to that information.
No data available
I don't have access to that information
- Q6. You have written some PORs in you CV, But I feel this is not at all a POR!!! ?
- Q7. What are your plans for the future?
- Ans.
My plans for the future include continuous learning, career growth, and contributing to the success of the company.
Continuously improve my skills and knowledge through training and development programs
Take on challenging projects and responsibilities to advance my career
Collaborate with colleagues to achieve company goals and objectives
- Q8. How do people remember you by ? define it in one word
- Ans.
Reliable
Consistent in meeting deadlines and delivering quality work
Trustworthy and dependable
Known for being organized and detail-oriented
- Q9. What are your 2 strengths ?
- Ans.
My strengths are attention to detail and problem-solving skills.
Attention to detail helps me identify potential issues and ensure accuracy in my work.
Problem-solving skills enable me to analyze complex situations and find effective solutions.
For example, in my previous role, I was able to identify a flaw in the company's inventory management system and proposed a solution that saved the company thousands of dollars.
I a...
- Q10. What is your weakness?
- Ans.
My weakness is public speaking.
I tend to get nervous when speaking in front of large groups.
I am actively working on improving my public speaking skills through practice and training.
I have found that preparing thoroughly and practicing beforehand helps me feel more confident.
I also try to focus on the message I am trying to convey rather than my own nerves.
- Q11. What people dont like in you ?
- Q12. Where do you see yourself 5 years down the line ?
- Ans.
In 5 years, I see myself as a senior business analyst leading a team and contributing to the growth of the company.
Leading a team of business analysts
Contributing to the growth of the company through data-driven insights and recommendations
Continuing to develop my skills and knowledge in the field of business analysis
Building strong relationships with stakeholders and clients
Exploring opportunities for process improvem
- Q13. What is your JEE Rank, 10th and Inter Math score ?
- Ans.
I do not have the JEE rank, but my 10th and Inter Math scores are above average.
I do not have my JEE rank available at the moment.
However, my 10th and Inter Math scores are above average.
I can provide more details on my academic achievements and relevant experience.
For example, I have completed a course in data analysis and have experience in using SQL for data querying.
- Q14. He too asked me a puzzle on probability
Interview Preparation Tips
Experience: The test was organized by cocubes.com .After writing many tests in cocubes.com , I felt a little better and easier.
Tips: Answers the questions you know. Don't forget to tick all the left overs before submitting the test if there are no negative markings :P .Write the exam in your normal pace. Don't panic or get tensed. Just be your self
Duration: 50 minutes
Total Questions: 50
Round: Group Discussion
Experience: We were 15 in the group. This wasn't like normal GDs. We were given a minute each to speak. I was the last member to speak. Almost all the points were covered. I did add new points and new dimensions to the discussion.
Tips: You will find many tips on the Internet.The most important thing I felt was " Create interest in people to listen to what you are speaking, And Speak the right things". Maintain Eye contact. Smile often. Always add points to the make the discussion constructive.
Round: Interview
Experience: I was a bit stressed out when he pointed out that I didn't do the works which actually I did them. But I always kept my cool. Answered him wisely.
Tips: Be Honest. take your time. Never admit the things which he will try to confuse you. Better answer him the right way than answering him quickly. Be a thoughtful person
Round: Interview
Experience: I was honest through out the interview.
Tips: Always be Honest. Keep your confidence levels high.Do your Homework. Prepare before hand for the most important HR questions. Don't fumble upon in front of the interviewer. Rehearse the answers which you have written down in front of a mirror or Best Friend. I prefer Friends to mirror as mirrors don't give you feedback :P .
General Tips: Be Honest.Just Recollect your past events.
Skill Tips: "Be yourself and " Sell the buyer what he is looking for ""
Skills: Quick learning, Confidence, Logical reasoning
College Name: IIT Kharagpur
Motivation: Good learning environment and Data Analysis is an emerging field.
Funny Moments: As soon as I entered the room HR was busy doing some phone calls and stuff, After a minute I asked him whether He was tensed :P :D
Interview Preparation Tips
Experience: It was not a group discussion to be exact. It was more like an extempore. We were given 2-3 minutes before starting, to think about the topic and then the coordinator would call out a name and that person had to speak for about 2 minutes or so, after which the coordinator would call another name.
Tips: Take a paper with you to write down the points.
Always make short points and elaborate on your own. Don't write down the whole paragraph. It wastes a lot of time.
Don't deviate from the topic. Just make sure whatever you speak, in favor or against, should make sense.
Do not use any fake accent.
Duration: 10 minutes
College Name: IIT ROORKEE
Interview Questionnaire
4 Questions
- Q1. A plane is 200Km away from its destination and starts to descend. What would be the angle at which the plane descends? (Guesstimates)
- Ans.
The angle at which the plane descends cannot be accurately determined without additional information.
The angle of descent depends on the rate of descent and the distance remaining to the destination.
The weight of the plane, wind speed and direction, and other factors can also affect the angle of descent.
Without knowing the rate of descent or the remaining distance, it is impossible to accurately estimate the angle of d
- Q2. General Questions from resume
- Q3. Why am I opting for a job instead for MS/MBA?
- Ans.
I believe gaining practical experience in a job will complement my theoretical knowledge from MS/MBA.
Practical experience is crucial for a business analyst role
A job will provide opportunities to apply theoretical knowledge in real-world scenarios
A job will also help me develop soft skills such as communication and teamwork
MS/MBA can be pursued later for further career growth
A job can provide financial stability while
- Q4. Which area would I love to work after I join Axtria?
Interview Preparation Tips
Experience: My Final Year Thesis was on Data Analytics which was a big plus. I was asked general questions on the aim of my project and how can I sell it to the concerned persons. It was a short interview of about 15-20 mins.
I told the interviewer that 5-10 degree would be the angle at which the plane will be descending but he forced that it is too less. Having seen a lot of air crash investigations, I was sure about it and confidently proved that 5-10 degrees is good enough by assuming the altitude at which the plane flies.
Tips: Practice Guessestimates. Be confident on what you say. You should be thorough with every point written on your resume.
Round: HR Interview
Experience: It wasn't hard to convince him about going for Job instead of MS/MBA. No such difficulty in answering the questions put forth by the interviewer.
Skills: Confidence, Knowledge of Analytics
College Name: IIT GUWHATI
I appeared for an interview before Mar 2016.
Interview Questionnaire
6 Questions
- Q1. Tell me about yourself. Resume based questions. Be well prepared with your resume. Guesstimate and puzzles.
- Q2. Guesstimate: Estimate the quantity of detergent used in india in 1 year.
- Ans.
Approximately 2 million metric tons of detergent is used in India annually.
Consider the population of India and the average usage of detergent per person.
Factor in the usage of detergent in industries and commercial establishments.
Take into account the different types of detergents used for various purposes.
Refer to market research reports for more accurate data.
Assume a growth rate in detergent usage based on populati...
- Q3. Puzzle: Given a dice with only 2 possible outcomes 1 & 3 and with probabilities 1/3 and 2/3 respectively. What will you do so that the dice can be used for tossing(in tossing, we expect unbiased outcomes).
- Q4. Any questions?
- Ans.
Yes, I have a few questions regarding the role and responsibilities of a Business Analyst.
Can you tell me more about the company's current business processes?
What are the key performance indicators (KPIs) that the company tracks?
How does the company measure the success of a project?
What tools and software does the company use for data analysis?
Can you provide an example of a successful project that the Business Analyst
- Q5. The interviewer asked general questions about me and varanasi city. Since i am from non-circuit branch, he asked why i am not choosing to go for core jobs. Then Basic programming questions in python and f...
- Q6. Do you have any questions?
Interview Preparation Tips
Experience: Employer was cool and has made it very comfortable. It was more of a friendly conversation.
Tips: Which ever analytics interview it is, you should have thorough practice in guesstimates, case studies and puzzles whether or not you have done any project in analytics.
Round: Technical + HR Interview
Tips: Staying confident is important. You can make best use of 'Do you have any questions?' It can give good impression on you if you can ask good questions about the profile/working/competitors etc. If you are shortlisted go through the company website to know about the company. That will help you a lot in asking these type of questions.
Skills: Problem Solving Abilties, Programming, Communication And Confidence
College Name: IIT BHU
Ramco Systems Interview FAQs
Tell us how to improve this page.
Ramco Systems Interviews By Designations
- Ramco Systems Programmer Analyst Interview Questions
- Ramco Systems Software Developer Interview Questions
- Ramco Systems Project Trainee Interview Questions
- Ramco Systems Software Engineer Interview Questions
- Ramco Systems Programmer Interview Questions
- Ramco Systems Associate Business Analyst Interview Questions
- Ramco Systems System Analyst Interview Questions
- Ramco Systems Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Programmer Analyst Interview Questions
- Programmer Analyst Trainee Interview Questions
- Programmer Interview Questions
- Trainee Programmer Interview Questions
- Technical Program Manager Interview Questions
- Senior Program Manager Interview Questions
- Program Analyst Trainee Interview Questions
- Senior Programmer Analyst Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Ramco Systems Program Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Programmer Analyst
939
salaries
|  ₹2.4 L/yr - ₹8.8 L/yr |
|
System Analyst
361
salaries
| ₹4 L/yr - ₹12 L/yr |
|
Business Analyst
231
salaries
| ₹3.6 L/yr - ₹12 L/yr |
|
Programmer
205
salaries
| ₹1.5 L/yr - ₹6.5 L/yr |
|
Senior Business Analyst
157
salaries
| ₹6 L/yr - ₹19 L/yr |
KPIT Technologies
Thomson Reuters
Oracle Cerner
NextComm Corporation
- Home >
- Interviews >
- Ramco Systems Interview Questions >
- Ramco Systems Program Analyst Interview Questions for Experienced
