KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #3106
Applications open Internship

Associate Technical Support Consultant

Harriscomputer

  • Remote, India
  • Not disclosed
  • Internship
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Altera Digital Health is a fast‑growing health‑technology firm that builds end‑to‑end digital solutions for hospitals, clinics and large health‑care networks across India. Leveraging cloud platforms, AI‑driven analytics and secure data pipelines, Altera enables clinicians to access patient records, schedule appointments and monitor outcomes from any device. The company’s mission is to make high‑quality health‑care affordable and accessible through innovative software that complies with stringent regulatory standards such as HIPAA and the Indian Personal Data Protection Bill.

With offices in Pune and Vadodara and a distributed workforce, Altera has been recognised for its collaborative culture, rapid product cycles and a strong focus on employee learning.

The role of Associate Technical Support Consultant is designed for fresh engineering graduates who are eager to start their career in IT support within the health‑tech domain. As a first‑line support professional, you will be the voice of the company for enterprise customers, helping them resolve technical issues quickly and ensuring a smooth user experience with Altera’s flagship health‑care platform. You will work closely with development, database and infrastructure teams, gaining exposure to the full product lifecycle while sharpening your troubleshooting and communication skills.

Key Responsibilities

  • Respond to incoming tickets on ServiceNow or the internal ticketing tool, providing timely first‑level support.
  • Diagnose and resolve application errors, connectivity problems, and configuration issues on Windows workstations.
  • Analyse log files, reproduce bugs, and document steps taken to reach a resolution.
  • Escalate complex incidents to senior engineers, providing clear hand‑off notes.
  • Collaborate with database administrators to run basic SQL queries for data validation.
  • Assist in the creation and maintenance of knowledge‑base articles for recurring issues.
  • Monitor SLA adherence and generate daily/weekly support metrics.
  • Participate in on‑call rotation, covering evening, night and weekend shifts as required.
  • Attend product training sessions to stay updated on new releases and features.
  • Provide feedback to product teams on usability and recurring pain points.

Tech Stack: Windows 10/11, ServiceNow/ITSM, SQL (MySQL/SQL Server), basic Python or PowerShell scripting, networking fundamentals (TCP/IP, DNS, ports), ITIL concepts, and exposure to cloud‑based health‑care SaaS platforms.

Growth Path: Starting as an Associate Consultant, high performers can progress to Senior Technical Support Engineer, then to Support Team Lead, and eventually move into Product Management or Solutions Architecture roles, leveraging the deep domain knowledge acquired on the job.

Why Join Altera: You will be part of a mission‑driven organization that directly impacts patient care, receive structured training on enterprise health‑care software, and enjoy the flexibility of a work‑from‑home setup with a supportive team that values continuous learning and career advancement.

Eligibility & process

Who can apply

Bachelor's degree in Computer Science, Information Technology, Computer Engineering, Electronics or related technical discipline; minimum 60% aggregate (or CGPA 6.0/10); graduating batch 2026; no active backlogs at the time of joining; strong communication skills in English.

Skills & stack

Windows Os TCP IP DNS Ports SQL Database Concepts Application Troubleshooting

Selection process

  1. Round 1: Online aptitude test (logical reasoning, quantitative, English)
  2. Round 2: Technical interview (Windows fundamentals, networking, SQL, scenario‑based troubleshooting)
  3. Round 3: HR interview (fitment, communication, work‑from‑home readiness)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Windows Os, TCP, IP, DNS, Ports, SQL, Database Concepts, Application Troubleshooting) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Harriscomputer Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Harriscomputer as a Associate Technical Support Consultant?
Highlight Harriscomputer's market reputation, recent tech innovations, and how your skills in Windows Os directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Harriscomputer Not disclosed
Recruiter Resume Apply
Chat Chat with Kashii