B Tech Fresher jobs in Mumbai, Maharashtra

# JOB DESCRIPTION – IT INTERN

*Position:* IT Intern

*Department:* Information Technology

*Employment Type:* Internship

*Experience:* Fresher / 0–1 Year

*Qualification:* B.Sc. IT / BCA / B.Tech / BE / MCA / Diploma in IT, Computer Science, or related field

## Job Summary

We are looking for a motivated and technically inclined *IT Intern* to support our day-to-day IT operations, software development, database management, reporting, and internal systems. The candidate should have a good understanding of programming, web technologies, SQL, and Advanced Excel, with a willingness to learn and work on live business requirements.

## Key Responsibilities

* Assist in the *development, testing, debugging, and maintenance of internal applications and web-based systems*.

* Work with programming and web technologies including *Java, JavaScript, PHP, HTML, and CSS*.

* Write, execute, and troubleshoot *SQL queries* for data extraction, reporting, validation, and database management.

* Work with *Advanced Excel*, including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, IF formulas, conditional formatting, charts, data validation, and data analysis.

* Assist in *data cleaning, reconciliation, and preparation of MIS reports*.

* Support the development and maintenance of *internal dashboards and automated reports*.

* Identify opportunities to *automate repetitive manual processes* using Excel, SQL, scripts, or other suitable tools.

* Assist in maintaining and updating *company websites, internal portals, and business applications*.

* Perform *software testing and quality checks* before deployment of new features or system updates.

* Troubleshoot basic *software, system, network, printer, and user-level IT issues*.

* Provide basic technical support to employees for *system and application-related problems*.

* Assist with *database maintenance, data backup, access control, and data accuracy checks*.

* Coordinate with users to understand business requirements and translate them into *technical solutions or system improvements*.

* Maintain proper *technical documentation*, including system changes, database structures, processes, and user instructions.

* Assist in monitoring existing IT systems and reporting *bugs, errors, performance issues, or security concerns*.

* Follow company standards for *data security, confidentiality, access management, and IT best practices*.

* Research and evaluate new technologies, tools, and automation opportunities that can improve business efficiency.

* Support the IT team in ongoing *software implementation, system upgrades, and digital transformation projects*.

## Technical Skills Required

*Programming & Web Development*

* Basic understanding of *Java*

* *JavaScript*

* *PHP*

* *HTML5*

* *CSS3*

*Database & Data Management*

* Good knowledge of *SQL*

* Understanding of relational databases

* Ability to write basic to intermediate SQL queries

* Knowledge of *Microsoft SQL Server* will be an advantage

*Excel & Reporting*

* Proficiency in *Advanced Microsoft Excel*

* Pivot Tables and Pivot Charts

* XLOOKUP / VLOOKUP

* INDEX & MATCH

* IF / IFS / SUMIFS / COUNTIFS

* Data Validation and Conditional Formatting

* Data cleaning and reconciliation

* Basic dashboard and MIS preparation

## Additional Skills Preferred

* Basic understanding of *Git/GitHub or version control*

* Knowledge of *REST APIs and JSON*

* Basic knowledge of *Windows operating systems and networking*

* Familiarity with *Power BI* or other reporting/dashboard tools will be an advantage

* Basic understanding of *cybersecurity and data protection*

* Knowledge of software testing and debugging

* Exposure to *AI tools and workflow automation* will be an added advantage

## Key Competencies

* Strong analytical and problem-solving skills

* Logical approach towards troubleshooting

* Good attention to detail

* Ability to learn new technologies quickly

* Good communication and interpersonal skills

* Ability to understand business requirements

* Ability to work independently as well as within a team

* Good time management and task prioritization

* Willingness to take ownership of assigned tasks

## What the Intern Will Gain

The selected candidate will receive practical exposure to *software development, database management, SQL, Advanced Excel, business process automation, IT support, reporting, and real-world business applications*. The internship will provide an opportunity to work on live projects and understand how technology is used to improve day-to-day business operations.

Pay: ₹10,000.00 - ₹20,000.00 per month

Work Location: In person