This job offer is not available in your country.

VBA Developer - Macros / SQL

USTKochi

28 days ago

Job description

Job Role : VBA Developer

Job Location : Kochi

Notice Period : Immediate to 30 days

Primary Skill : VBA, VBA Macros, SQL

Role Summary :

We are seeking a highly skilled Developer with expertise in VBA, SQL, and automation solutions to support the design, development, and maintenance of robust data-driven applications and processes. The ideal candidate will have a deep understanding of SQL Server, VBA macros, and data processing automation, with the ability to analyze and resolve complex issues while working closely with stakeholders and cross-functional teams.

Key Responsibilities :

Core Development :

Design, develop, and maintain automation tools using VBA (Visual Basic for Applications).
Create, optimize, and manage MS Access databases and SQL Server stored procedures.
Develop complex SQL queries and scripts for data transformation and reporting.
Code, debug, test, document, and communicate component development stages effectively.
Contribute to the creation of technical designs (HLD, LLD, SAD) and architecture of & Quality :
Create and review unit test cases and execution scenarios.
Collaborate with the testing team; review test plans and clarify requirements.
Perform root cause analysis (RCA) on defects and implement corrective actions.
Ensure code quality, minimal post-delivery defects, and adherence to coding & Communication :
Work closely with stakeholders to understand business needs and translate them into technical solutions.
Present design options, conduct product demos, and engage in technical discussions.
Drive and manage team deliverables and set performance goals (FAST & Configuration :
Develop and maintain documentation including design, test cases, and user manuals.
Define configuration management plans and ensure team & Knowledge Management :
Estimate effort and resources for project tasks.
Participate in release execution and monitoring.
Mentor junior developers and contribute to knowledge sharing and reusable documentation.

Required Skills & Experience :

Proven experience with VBA development and automation scripting.

Strong command of SQL Server, T-SQL, and Access database design.

Hands-on experience with data ingestion, cleaning, and report generation.

Strong problem-solving and analytical skills.

Ability to manage multiple tasks and work under pressure.

Excellent verbal and written communication and stakeholder management Qualifications :

Experience with Python or other automation tools.

Familiarity with ETL tools, data pipelines, or integration processes.

Domain knowledge in banking, finance, or related industries.

Certifications in relevant domains or technologies (e.g., Microsoft SQL, VBA).

Key Performance Indicators (KPIs) :

Code quality and adherence to engineering standards.

Timely completion of assigned tasks and project milestones.

Number of issues or defects Effectiveness in team collaboration and customer engagement.

Compliance with mandatory training and documentation standards.

Soft Skills :

Strong interpersonal and team management skills.

High business etiquette and Ability to break down complex technical problems logically.

Proactive attitude with a willingness to take ownership.

Technologies & Tools :

Languages : VBA, T-SQL, Python (optional)

Databases : SQL Server, MS Access

Tools : Microsoft Excel, SQL Server Management Studio (SSMS), ETL Tools

Methodologies : Agile (Scrum / Kanban), SDLC, RAD

Others : IDEs, Data Modeling, Configuration Management

(ref : hirist.tech)

Create a job alert for this search

Developer • Kochi