Fresenius Kabi India Technology Consultant Interview: Rounds, Questions and Preparation

What the job involves

Technology Consultants in GCCs, consulting firms, and Big 4 outfits help clients improve business processes and technology systems, often bridging business needs with IT solutions. Day to day, they gather requirements, analyse workflows, support testing and deployment, and prepare documentation and presentations for stakeholders. Freshers typically start on support, testing, or implementation tracks and grow into advisory roles.

Role and Technical Knowledge

1. 1

   What is the difference between a functional consultant and a technical consultant in a GCC or consulting setup?

   Explain that functional consultants focus on business processes and requirements, while technical consultants handle configuration, code, integration, and system support. Mention that many freshers start in a hybrid role.

2. 2

   Walk me through the phases of the SDLC and where a technology consultant adds the most value.

   Cover requirements, design, development, testing, deployment, and maintenance. Highlight that consultants add value in requirements, testing, and change management by translating business needs for technical teams.

3. 3

   How would you write a basic SQL query to find duplicate records in a customer table?

   Use GROUP BY and HAVING COUNT(*) > 1 on the key column. Explain that this is a common data quality check before migration or reporting.

4. 4

   What do you understand by ERP and CRM, and give one example of each used in healthcare or manufacturing?

   Define ERP as integrated back-office systems and CRM as customer-facing systems. For healthcare or manufacturing, mention SAP or Oracle for ERP and Salesforce or Dynamics for CRM, without claiming specific company usage.

Practical Scenarios

1. 5

   A client says their report is showing wrong numbers. How would you investigate and resolve this?

   Start by understanding the report logic, source data, and filters. Check recent changes, validate with SQL queries, and document findings before proposing a fix. Emphasise communication with the client throughout.

2. 6

   You are asked to gather requirements for a new inventory tracking module. What steps would you take?

   List steps like stakeholder interviews, process observation, drafting user stories or BRD, reviewing with business, and getting sign-off. Mention prioritisation using MoSCoW or similar.

3. 7

   During UAT, a critical defect is found one day before go-live. What do you do?

   Assess severity and impact, inform stakeholders immediately, and propose options like a workaround, a patch, or a delayed go-live. Show that you balance speed with quality and client trust.

4. 8

   How would you explain a technical issue to a non-technical client stakeholder?

   Use plain language, avoid jargon, focus on business impact, and offer clear next steps. Give a short example of translating a database error into a data delay that affects reporting.

Behavioural and Situational

1. 9

   Tell me about a time you worked in a team to solve a problem. What was your role?

   Use the STAR method. Focus on your specific contribution, how you communicated, and the measurable outcome. Keep it concise and relevant to consulting teamwork.

2. 10

   Describe a situation where you had to learn something new quickly. How did you approach it?

   Show curiosity and structure. Mention how you broke down the topic, used available resources, and applied the learning to a project or assignment.

3. 11

   How would you handle a disagreement with a senior team member about the best solution?

   Emphasise listening first, asking questions to understand their view, and presenting your reasoning with data. Show respect for hierarchy while being willing to voice concerns constructively.

4. 12

   Give an example of when you had to manage multiple deadlines. How did you prioritise?

   Explain your prioritisation framework, such as urgency versus importance, and how you communicated trade-offs. Mention tools like to-do lists or calendars if helpful.

HR and Fit

1. 13

   Why do you want to work as a technology consultant in a GCC or consulting environment?

   Connect your interest in business and technology, problem solving, and client interaction. Mention exposure to diverse projects and structured learning, without naming specific companies as your only reason.

2. 14

   Are you comfortable with travel, shifting work hours, or working from client locations?

   Be honest but positive. If you are flexible, say so and give an example of adapting to a schedule. If not, explain how you manage commitments and communicate clearly.

3. 15

   Where do you see yourself in three years in this role?

   Show a realistic growth path, such as deepening domain knowledge, leading small workstreams, or gaining certifications. Avoid saying you want to leave consulting immediately.

4. 16

   What do you know about the consulting industry and the sectors it serves, such as healthcare or manufacturing?

   Mention that consultants help clients improve efficiency, compliance, and technology adoption. For healthcare or manufacturing, note trends like digital transformation, data analytics, and regulatory compliance, without claiming specific company projects.