Visual Basic Developer

Tata Consultancy Services; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services in Pune, Maharashtra, is seeking a skilled VBA developer to build, enhance, and maintain multi-user Excel, Access, and SQL Server applications. You will design user forms, automate data workflows, and ensure solutions align with SDLC and internal standards.

The role involves training users, documenting code, providing ongoing support, and engaging with clients and senior management to identify automation opportunities.

Qualifications

• Minimum 4 years’ experience as a VBA developer with Office applications.
• Experience developing UI/User Form based applications using VBA.
• Proficient in MS Excel and MS Access VBA/macros.
• Strong SQL Server knowledge and database concepts.

Responsibilities

• Develop, enhance, and maintain VBA apps in Excel, Access, and SQL Server.
• Create custom user forms, scripts, libraries, and functions for Office.
• Transform data from multiple sources using VBA while ensuring accuracy.
• Document code and procedures to support knowledge sharing.
• Provide ongoing support and maintenance for existing solutions.
• Train end users on newly developed and existing applications.
• Ensure applications comply with company policies and standards.
• Understand and follow SDLC throughout development lifecycle.
• Engage with clients and end users to gather requirements and automation opportunities.

Skills

VBA

SQL

MS Excel

MS Access

SDLC knowledge

Client interaction

Tools

MS SQL Server

MS Access

MS Excel

UI Form Development

Stored Procedures

Job description

• Develop, enhance, and maintain multi-user VBA applications in Excel, MS Access, and SQL Server.
• Develop custom user forms, scripts, libraries and functions for Microsoft Office applications.
• Use VBA to transform data from multiple sources while ensuring accuracy and consistency.
• Document VBA code and procedures to support knowledge sharing and future reference.
• Provide ongoing support and maintenance for existing solutions.
• Train end users on newly developed and existing applications.
• Ensure applications comply with company policies and standards.
• Understand and follow SDLC – Software development life Cycle
• Proficient in SQL and RDBMS concepts
• Manage various databases in MS Access, MS SQL Server
• Engage with clients, end users, and senior management to gather requirements and identify automation opportunities.

Good-to-have:

• Minimum 4 years’ experience as a VBA (Visual Basic for application) developer
• Experience of developing UI / User Form based application with the help of VBA
• Proficient in MS Excel & MS Access VBA (Visual Basic application) /macro programming
• Proficient in SQL Server (RDBMS concept, SQL script, stored procedure, functions, trigger, UDFs etc)