SunTec Business Solutions Technical Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Technical Analyst in Indian IT services supports the design, configuration, and troubleshooting of software solutions for banking, financial services, and insurance clients. Day to day, you gather requirements, write SQL queries, test application workflows, document issues, and coordinate with developers and client teams. At fast-growing product or services firms like SunTec Business Solutions, you often work on pricing, billing, or revenue management platforms used by banks and telecom operators.

Role and Technical Knowledge

1. 1

   What is the difference between a technical analyst and a software developer in an IT services company?

   A strong answer explains that a developer writes code, while a technical analyst bridges business and technology by gathering requirements, writing SQL, testing, and supporting live systems. Mention that you still need basic coding knowledge to debug and communicate with developers.

2. 2

   Explain the software development life cycle (SDLC) and where a technical analyst fits in.

   Cover phases like requirement gathering, design, development, testing, deployment, and maintenance. Highlight that a technical analyst is heavily involved in requirements, testing, and post-production support.

3. 3

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

   Use GROUP BY and HAVING COUNT(*) > 1 on the customer ID or email column. Explain that you would also check for NULLs and use DISTINCT or ROW_NUMBER() for deeper analysis.

4. 4

   What do you understand about billing or pricing systems used in banking and telecom?

   Mention that these systems calculate charges based on usage, tariffs, and contracts. Talk about concepts like rate plans, discounts, invoicing cycles, and reconciliation. Show willingness to learn domain-specific tools.

Practical Scenarios

1. 5

   A client reports that invoices are showing incorrect tax amounts. How would you investigate?

   Start by checking the tax configuration in the system, then run SQL queries on the invoice and tax tables. Compare with expected values, check recent changes, and document findings before escalating to development if needed.

2. 6

   You need to test a new feature that calculates late payment fees. What is your test approach?

   Cover positive and negative test cases, boundary values like zero days or one day late, and different customer types. Mention writing test cases, executing them, and logging defects with clear steps to reproduce.

3. 7

   How would you handle a situation where you do not know the answer to a client's technical question during a call?

   Acknowledge the question, commit to finding the answer within a specific time, and follow up. Show that you take notes, consult senior team members or documentation, and never guess in front of a client.

4. 8

   You are asked to write a requirement document for a small change in a billing module. What sections would you include?

   Include purpose, current behaviour, proposed change, business rules, impacted systems, test scenarios, and approval sign-off. Emphasise clarity so developers and testers can act without ambiguity.

Behavioural and HR Questions

1. 9

   Why do you want to work as a technical analyst in the IT services sector, especially with financial software clients?

   Connect your interest in problem-solving and technology with the stability and learning opportunities in BFSI domain projects. Mention that you enjoy client interaction and want to build domain expertise.

2. 10

   Tell me about a time you worked in a team to solve a problem during your college project.

   Use the STAR method: situation, task, action, result. Focus on your specific contribution, how you handled disagreements, and what you learned about collaboration.

3. 11

   Are you comfortable working in rotational shifts or supporting clients in different time zones?

   Be honest but positive. If you are flexible, say so and explain that you understand global clients may need support outside normal hours. If not, mention your constraints clearly and professionally.

4. 12

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

   Show a growth path from technical analyst to senior analyst or domain specialist. Mention deepening SQL, domain, and client management skills, and taking on more responsibility for end-to-end delivery.

Domain and Tools Awareness

1. 13

   What is the difference between a functional specification and a technical specification?

   A functional specification describes what the system should do from a business perspective. A technical specification describes how it will be implemented, including data structures, APIs, and logic. A technical analyst often helps create or review both.

2. 14

   How would you use Excel to analyse a large set of transaction data for errors?

   Mention using filters, pivot tables, VLOOKUP or XLOOKUP, and conditional formatting to spot mismatches. Explain that you would also validate totals and cross-check with SQL query results for accuracy.

3. 15

   What are the common causes of application performance issues in a client-server environment?

   Cover slow database queries, network latency, insufficient server memory, and inefficient code. Mention that a technical analyst would check logs, run basic SQL diagnostics, and coordinate with infrastructure or development teams.

4. 16

   Explain how you would use a ticketing tool like Jira or ServiceNow in your daily work.

   Describe logging incidents, updating status, adding comments and attachments, and linking to requirements or defects. Show that you understand prioritisation based on severity and client impact.