Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Kochi, India Compensation: INR 20000 - 25000 per month
JOB DESCRIPTION
IT Assistant
We are hiring an IT Assistant to keep our systems running smoothly, test software before it reaches users, and support our CRM platform. You will be the first point of contact for day-to-day IT issues and a hands-on tester for internal and business applications. Job title IT Assistant Department Information Technology Reports to IT Manager Location Kozhikode, Kerala Employment type Full-time Experience 1 year in IT support and/or software testing
Key responsibilities IT support and administration
Provide first-level support for hardware, software, network and printer issues, by phone, email and in person.
Set up, configure and maintain laptops, desktops, peripherals and user accounts for new joiners and leavers.
Log, track and resolve tickets in the helpdesk system, escalating complex issues to senior IT staff.
Maintain the IT asset inventory and software licence records.
Support routine backups, antivirus updates, patching and basic network troubleshooting.
Software testing and quality assurance
Review requirements and write clear test cases, test scenarios and test data.
Perform manual functional, regression, integration, smoke and user acceptance testing (UAT).
Log defects with steps to reproduce, screenshots and severity, and track them through to closure.
Retest fixes and verify releases before they go live.
Prepare test summary reports and share findings with developers and business users.
CRM support
Assist with day-to-day CRM administration: user setup, roles, permissions, fields and picklists.
Test CRM configuration changes, workflows, integrations and data imports before release.
Support data quality through clean-ups, de-duplication and imports/exports.
Help users with CRM queries and create simple reports and dashboards.
Documentation
Write and update user guides, SOPs and knowledge-base articles for common IT and CRM issues.
Required qualifications and skills
Bachelor’s degree or diploma in Computer Science, IT or a related field.
Minimum 1 year of experience in IT support, software testing, or both.
Hands-on testing experience is mandatory: writing test cases, executing manual tests and reporting defects.
Good understanding of the software testing life cycle (STLC) and defect life cycle.
Experience with a bug-tracking or test-management tool such as Jira, Zoho Projects, TestRail or Azure DevOps.
Working knowledge of Windows and macOS, Microsoft 365 or Google Workspace, and basic networking (LAN, Wi-Fi, DNS, DHCP).
Comfortable troubleshooting hardware, software and access issues.
Basic SQL to query and validate data.
Strong attention to detail and clear written documentation.
Good to have
Experience using or administering a CRM such as Zoho CRM, Salesforce, HubSpot, Microsoft Dynamics 365 or LeadSquared.
Understanding of CRM concepts: leads, contacts, accounts, deals, pipelines, workflows and automation rules.
Experience testing CRM customisations, integrations or data migrations.
Exposure to API testing with Postman.
Basic knowledge of test automation (for example Selenium or Playwright).
Certifications such as ISTQB Foundation, CompTIA A+ or a CRM admin certification.
Soft skills
Clear, patient communication with non-technical users.
Analytical, methodical approach to problem-solving.
Able to manage several tickets and test cycles at once and meet deadlines.
Team player who is also comfortable working independently.
Eager to learn new tools and technologies.
What we offer
CTC of ₹25,000 per month.
Hands-on exposure to IT operations, QA and CRM platforms.
Training and certification support.
[Health insurance, paid leave and other benefits].
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?