GCCs, consulting and the Big 4
Cerner India Technology Consultant Interview: Rounds, Questions and Preparation
For Technology Consultant roles at companies like Cerner India
What the job involves
Technology Consultants in GCCs and Big 4 firms work at the intersection of business and technology, helping clients implement, optimise and support enterprise systems such as ERP, CRM and healthcare IT platforms. Day to day, they gather requirements, configure software, test solutions, train users and troubleshoot issues, often coordinating between client teams and internal developers. The role demands strong communication, analytical thinking and a willingness to learn domain-specific processes.
Role and Technical Knowledge
- 1
What is the difference between a functional consultant and a technical consultant in a GCC?
Explain that functional consultants focus on business processes and requirements, while technical consultants handle configuration, coding and integration. Mention how both collaborate in projects.
- 2
How would you explain the software development life cycle (SDLC) to a non-technical client?
Use simple analogies like building a house, covering phases from requirement gathering to maintenance. Highlight the importance of feedback loops.
- 3
What are the key steps you would follow to gather requirements for a new healthcare IT module?
Outline stakeholder interviews, process observation, document analysis and creating user stories. Emphasise validating requirements with clinicians and IT staff.
- 4
Write a SQL query to find the second highest salary from an Employee table.
Use a subquery with MAX or LIMIT/OFFSET depending on the database. Explain the logic and mention handling duplicates.
Practical Scenarios
- 5
A client reports that their patient scheduling system is running slowly during peak hours. How would you troubleshoot?
Start by checking server load, database queries and network latency. Suggest temporary workarounds and long-term fixes like indexing or load balancing.
- 6
You are asked to migrate data from an old ERP to a new one. What are the key risks and how would you mitigate them?
Discuss data mapping, validation, backup, testing in a sandbox and rollback plans. Mention involving business users for verification.
- 7
During user acceptance testing, a key stakeholder refuses to sign off because a report does not match their expectations. What do you do?
Listen to their concerns, clarify the requirement, and work with developers to adjust. Document the change and re-test before seeking sign-off.
- 8
How would you handle a situation where you are assigned to a project using a technology you have never worked with?
Show willingness to learn quickly through documentation, online courses and mentoring. Mention breaking down tasks and asking for help when needed.
Behavioural and HR
- 9
Why do you want to join a GCC like ours rather than a product company or a startup?
Focus on exposure to global clients, structured training, and the chance to work on enterprise-scale projects. Show awareness of the GCC model.
- 10
Describe a time when you had to work in a team to meet a tight deadline. What was your role?
Use the STAR method. Highlight communication, task prioritisation and how you supported teammates to deliver on time.
- 11
How do you handle feedback that you disagree with?
Show openness by listening first, asking clarifying questions, and implementing if reasonable. Mention escalating respectfully if needed.
- 12
Are you willing to relocate or work in different shifts to support global clients?
Be honest but positive. If flexible, state your willingness and mention any constraints. Emphasise adaptability.
Consulting and Business Acumen
- 13
How would you estimate the number of hospital beds required in a city of 10 million people?
Use a structured approach: assume occupancy rates, average length of stay, and population health statistics. Show your assumptions clearly.
- 14
A client wants to reduce the time taken for patient check-in by 50%. What technology solutions would you propose?
Suggest self-service kiosks, mobile apps, pre-registration and integration with EHR. Discuss feasibility, cost and user adoption.
- 15
What are the key differences between a GCC and a traditional IT services company from a consultant's perspective?
Highlight that GCCs are captive centres focused on one organisation's products and processes, offering deeper domain expertise and long-term projects.
- 16
How would you measure the success of a technology implementation project?
Mention metrics like user adoption rate, process efficiency gains, ROI, defect density and client satisfaction. Align with business goals.
Ready to try it for real?
Take a timed test or talk through a mock interview for this role, then see your scores.
This is practice material for Technology Consultant roles, written with AI. It is not a list of questions Cerner India or any other company has asked.