AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
CCS Global Tech Interview Questions, Process, and Tips
Top CCS Global Tech Interview Questions and Answers
- Q1. Write q query to fetch the details of employees who are in the same departmentasked in Associate Software Engineer interview
- Q2. What is difference between delete and truncate command in SQL?asked in Associate Software Engineer interview
- Q3. What's the difference between where and having clauseasked in Associate Software Engineer interview
CCS Global Tech Interview Experiences
2 interviews found
I applied via Company Website and was interviewed in Feb 2023. There were 2 interview rounds.
(5 Questions)
- Q1. What is oops and what are its advantages
- Ans.
OOPs is a programming paradigm that uses objects to represent real-world entities and provides encapsulation, inheritance, and polymorphism.
Encapsulation: Hides the implementation details of an object from the outside world
Inheritance: Allows creating a new class from an existing class
Polymorphism: Allows objects of different classes to be treated as if they are of the same class
Advantages: Reusability, Modularity, Fle...
- Q2. Different types of joins
- Ans.
Different types of joins are Inner Join, Left Join, Right Join, and Full Outer Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables, including non-matching rows.
- Q3. Primary Key and unique key
- Q4. What's the difference between where and having clause
- Ans.
WHERE clause filters rows before grouping, HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition
HAVING clause is used to filter groups based on a condition
WHERE clause is used before GROUP BY clause
HAVING clause is used after GROUP BY clause
WHERE clause cannot contain aggregate functions
HAVING clause can contain aggregate functions
Example: SELECT department, AVG(salary) FR...
- Q5. Write q query to fetch the details of employees who are in the same department
- Ans.
Query to fetch details of employees in the same department
Use SELECT statement to fetch employee details
Use JOIN to join employee and department tables
Use WHERE clause to filter employees in the same department
Interview Preparation Tips
Skills evaluated in this interview
Top CCS Global Tech Associate Software Engineer Interview Questions and Answers
Associate Software Engineer Interview Questions asked at other Companies
Selected
I applied via Approached by Company and was interviewed before Aug 2022. There were 3 interview rounds.
(2 Questions)
- Q1. What are your skills?
- Q2. What is your background?
(3 Questions)
- Q1. What is difference between delete and truncate command in SQL?
- Ans.
Delete command removes rows one by one while truncate command removes all rows at once.
Delete is a DML command while truncate is a DDL command.
Delete can be rolled back while truncate cannot be rolled back.
Delete command fires triggers for each row deleted, while truncate does not.
Delete command is slower as it maintains logs for each row deleted, while truncate is faster as it does not maintain logs.
Delete command can...
- Q2. How to join two table with inner join?
- Ans.
To join two tables with inner join, use the JOIN keyword along with the ON clause to specify the join condition.
Use the JOIN keyword to combine rows from two tables based on a related column between them
Specify the join condition using the ON keyword followed by the columns to join on
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q3. How to delete duplicate records in a table?
- Ans.
Use SQL query with GROUP BY and HAVING clause to delete duplicate records in a table.
Identify the columns that define a duplicate record
Write a SQL query to select the duplicate records using GROUP BY and HAVING clause
Delete the duplicate records using DELETE statement with the identified criteria
Interview Preparation Tips
Skills evaluated in this interview
Top CCS Global Tech Associate Software Engineer Interview Questions and Answers
Associate Software Engineer Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
Selected
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Sale price on on day
- Q2. Start working
Interview Preparation Tips
Key points to remember:
Prioritize networking:
Utilize your network to connect with people in the industry, attend industry events, and leverage platforms like LinkedIn to build relationships with potential hiring managers.
Tailor your resume:
Include relevant sales keywords throughout your resume to catch the attention of recruiters and ensure your experience aligns with the job description.
Practice your sales pitch:
Prepare compelling stories from your past experiences to demonstrate your ability to close deals, overcome objections, and build rapport during interviews.
Follow up consistently:
After submitting applications, send personalized follow-up emails to maintain engagement with potential employers.
Research companies:
Actively monitor companies you're interested in by following their social media and news to stay informed about potential openings.
Highlight transferable skills:
Even if you lack direct sales experience, emphasize skills like communication, persuasion, relationship building, and problem-solving that translate well to a sales role.
Ask insightful questions:
During interviews, demonstrate your knowledge of the company and role by asking thoughtful questions that show your genuine interest.
Be enthusiastic and confident:
Convey a positive attitude and express your passion for sales to make a strong impression on potential employers.
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
(6 Questions)
- Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
- Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
- Ans.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
- Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
- Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
- Ans.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
- Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
- Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Interview Preparation Tips
Functional Testing Senior Consultant Interview Questions & Answers
Deloitte
Anonymous
posted on 4 Feb 2025
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Current CTC, Expected CTC, Notice Period, Skill set
- Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
(10 Questions)
- Q1. Introduction, Current role and responsibilities
- Q2. List out the achievements in current project, Tools used
- Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
- Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
- Q5. Explain Software Testing Life Cycle, Defect Life Cycle
- Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
- Q7. What kind of links and labels can be tagged to a bug in jira?
- Q8. Have you done shell scripting? What does grep, href commands do in unix?
- Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
- Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...
Interview Preparation Tips
I applied via referral in Deloitte USI but to save their referral bonus (I guess), they rejected my profile on the portal and called me through Naukri.com. When I asked them the reason, they said its for a different profile them. however it was for the same one.
Also on their career site, it was not mentioned that role is of fixed term hire (for 2 years), but HR disclosed it later, during the conversation. (another discrepancy)
During my initial conversation, HR clearly said there won't be any night shifts and I would have to work from client's location in Gurgaon office. Although it is 2 year contractual role.
But during my technical interview, the person clearly said to me that I would have to relocate to Bangalore for working from client's secured ODC in office. Also there would be rotational/ night shifts (without any extra pay). Basically they were looking for someone who would devote his 24X7 time to the company for a minimal salary and does not demand for work life balance or weekends off
Neither the HR nor the interviewer opened their web camera during the video call. But HR kept asking me to keep my camera open, even during the waiting time
P2P Accounts Payable Executive Interview Questions & Answers
Accenture
Anonymous
posted on 6 Jan 2025
Selected
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(5 Questions)
- Q1. How many variance in sap?
- Q2. We cac explain the all accounts receivable and accounts payable
- Q3. What is the cost element and cost center?
- Q4. How many we have currencies in sap?
- Q5. How many types of projects
Interview Preparation Tips
- mba fresher
* Identify Your Strengths & Weaknesses:
* Strengths: What are you good at? What do you enjoy doing? What are your unique skills and talents?
* Weaknesses: What areas do you need to improve? What are your biggest challenges?
* Define Your Career Goals:
* Short-term: What kind of job are you looking for? What industry are you interested in? What salary range are you targeting?
* Long-term: What is your ideal career path? What are your long-term professional aspirations?
2. Enhance Your Job Search Strategy
* Build a Strong Online Presence:
* LinkedIn: Create a professional and engaging LinkedIn profile.
* Portfolio/Website: If applicable, showcase your work through a portfolio or personal website.
* Network, Network, Network:
* Attend industry events: Conferences, meetups, and workshops.
* Informational interviews: Connect with people working in your field of interest.
* Leverage your existing network: Let your friends, family, and former colleagues know you're job searching.
* Tailor Your Resume & Cover Letter:
* Customize: Tailor your resume and cover letter to each specific job application.
* Keywords: Use keywords from the job description to increase your chances of getting noticed by Applicant Tracking Systems (ATS).
* Quantify your achievements: Use numbers and data to demonstrate your accomplishments.
* Master the Job Interview:
* Practice: Prepare for common interview questions (behavioral, technical, etc.).
* Research: Learn about the company and the role you're interviewing for.
* Ask insightful questions: Demonstrate your interest and engagement.
3. Continuous Improvement
* Skill Development:
* Online courses: Platforms like Coursera, Udemy, and edX offer a wide range of courses.
* Certifications: Obtain relevant industry certifications to enhance your credentials.
* Volunteer work: Gain valuable experience and build your network.
* Stay Updated:
* Industry news: Keep up-to-date with the latest trends and developments in your field.
* Job market trends: Monitor job boards and industry publications to understand the current job market.
Key Advice:
* Be patient and persistent: The job search process can be challenging, but don't give up.
* Stay positive and maintain a growth mindset: Focus on your strengths and opportunities for improvement.
* Take care of yourself: Prioritize your physical and mental well-being during your job search.
Remember: The job market is constantly evolving. Be adaptable, proactive, and resourceful in your job search efforts. Good luck!
I applied via Company Website and was interviewed in Nov 2024. There were 13 interview rounds.
(2 Questions)
- Q1. What is the Entity-Relationship (ER) model?
- Q2. What are the advantages of using threads compared to processes?
Google primarily focuses on pure data structures and algorithms-based questions during coding interviews. Other computer science core topics are typically not covered in Google's interviews. Therefore, it is essential to be proficient in data structures and algorithms to succeed in the Google coding interview.
An aptitude test is a tool used to evaluate a person's skills, abilities, and potential for success in a specific role or activity.
Group discussion is a process of exchanging ideas and opinions among individuals on a specific topic. It is a structured form of communication in which participants have the opportunity to express their views while also listening to others' perspectives on the same subject.
(2 Questions)
- Q1. What are your strengths and weaknesses?
- Q2. What reasons can you provide for why we should consider hiring you?
An assignment is a task or piece of work that you are given to complete, particularly as part of your job or studies. The assignment for the course includes written assignments and practical tests, similar to tasks, work, jobs, or charges.
A case study is a detailed description and assessment of a specific situation in the real world, created for the purpose of deriving generalized insights and understanding. It can focus on an individual, a group of people, an organization, or an event, among other subjects.
(2 Questions)
- Q1. What do you consider your greatest accomplishment?
- Q2. What factors motivate you in your professional life?
(2 Questions)
- Q1. What does your ideal work environment look like?
- Q2. How would you impact employee retention?
(2 Questions)
- Q1. What are real-time operating systems?
- Q2. Are the applicants first asked several questions regarding data structures and algorithms?
(2 Questions)
- Q1. What topics are typically discussed during the final round of interviews, particularly regarding salary expectations, working hours, and other job requirements?
- Q2. Are you comfortable working night shifts, considering that many roles at Genpact support international clients?
(2 Questions)
- Q1. A process associate is crucial in ensuring the smooth operation of various business processes across different industries
- Q2. What are the operational tasks necessary to maintain efficiency and quality?
(2 Questions)
- Q1. How can you prepare examples demonstrating your leadership, conflict resolution, and prioritization skills to excel in a managerial round interview?
- Q2. How do you demonstrate adaptability, leadership, and a commitment to fostering a positive work environment?
Interview Preparation Tips
(2 Questions)
- Q1. Azure cloud platform tech
- Q2. Informatica tech stack ques
(2 Questions)
- Q1. Adf tech stack que
- Q2. Scd type 2 implementation
- Ans.
SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.
Identify the columns that need to be tracked for changes
Add effective start and end dates to track the validity of each record
Insert new records for changes and update end dates for previous records
Maintain a surrogate key to uniquely identify each version of the record
(2 Questions)
- Q1. Dw related que ans
- Q2. Solution design related que
(2 Questions)
- Q1. Aspiration from my end
- Q2. How soon can join
- Ans.
I can join the team within 2 weeks.
I can start within 2 weeks of receiving the offer.
I need to give notice to my current employer.
I may need to relocate, which could affect my start date.
Interview Preparation Tips
Then after putting my lot of time and efforts when finally it comes to release the offer, then they stop picking up the calls and stop responding and the final excuses which I got from them for not releasing the offer is that their software will not allow them to release any offer which is more that 2 days of joining.
Such a pathetic company who even don't know that atleast if you are not releasing the offer, it's your duty to atleast tell the person that either they are not able to provide the compensation as discussed or they are looking parallelly for someone who can settle in less compensation.
Due to all this I have wasted almost my 3-4 weeks of time expecting that I will receive the offer, and didn't focus on other organisations which was ready to provide slightly lower than this.
Hence it's a total scam which is going here suggesting not to get trapped otherwise you will not only waste your time but also other good opportunities as well.
It's a total boycott for me, expecting the same from your end as well, so that they will understand that playing with someone's job is not a joke.
Skills evaluated in this interview
(6 Questions)
- Q1. What are some of the Design Patterns you have worked with?
- Q2. What is your approach for a issue you came to know happened in Production.
- Q3. If given a chance to lead a team will you take it up as a challenge of not how would you tackle it?
- Q4. Are you able to work under pressure. How do you manage?
- Q5. What do you understand by SOLID principle? Why do you think it is important.
- Q6. Please solve the coding question provided ( a moderately difficult coding question provided). Help understand your approach and why you chose same. Explain edge caes if possible.
Interview Preparation Tips
Be able to demonstrate through practical approach.
Keep your theoretical approach flexible and more inclined with positive response than bluffing.
Keep confidence at core of and have a good communication practice.
Adhere to Interview rules for example be available with 1 working editor for coding or technical rounds. Be professional in your appearance and always refrain from asking feedback in the interview itself.
Infrastructure Management Consultant Interview Questions & Answers
Infosys
Anonymous
posted on 2 Feb 2025
Selected
(2 Questions)
- Q1. What are your salary expectations?
- Q2. What has been your experience in each of the companies you have worked for?
(4 Questions)
- Q1. Can you tell me about yourself?
- Q2. Could you briefly describe the companies you have worked for?
- Q3. What technologies have you worked with, and what was your role in each?
- Q4. What are some use case studies related to the technologies you have worked with?
Interview Preparation Tips
CCS Global Tech Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Associate Interview Questions
- Design Engineer Interview Questions
- Business Analyst Interview Questions
- Senior Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Java Developer Interview Questions
- Test Engineer Interview Questions
- Show more
CCS Global Tech Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
CCS Global Tech Reviews and Ratings
based on 11 reviews
Rating in categories
|
Data Engineer
5
salaries
|  ₹4.5 L/yr - ₹10.2 L/yr |
|
Associate Software Engineer
4
salaries
| ₹4.5 L/yr - ₹9 L/yr |
|
Assistant Manager
4
salaries
| ₹5 L/yr - ₹15.5 L/yr |
|
Business Development Executive
4
salaries
| ₹3 L/yr - ₹4.8 L/yr |
|
Research Analyst
3
salaries
| ₹4.5 L/yr - ₹6 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- CCS Global Tech Interview Questions
