Role requirement: We are looking for a highly skilled VBA Developer with 3-6 years of strong expertise in Advanced Excel automation, VBA scripting, Selenium-based web automation, and code analysis
Responsibility: The candidate will be responsible for developing, analyzing, debugging, and enhancing complex Excel-based automation solutions, including reverse engineering existing macro-driven applications and identifying opportunities for optimization and stability improvements.
Technical Requirements:
Must Have Skills
-
Strong expertise in Advanced Microsoft Excel - Complex formulas, Power Query, Data transformation and reporting automation
-
Strong experience in VBA Development on Microsoft Products - Excel, Word, PPT, Outlook
-
Modular programming
-
Event-driven programming
-
File handling
-
Error handling
-
Performance optimization
-
Strong capability in Code Analysis & Reverse Engineering
-
Strong Debugging & Root Cause Analysis (RCA) skills
-
Experience in Web Scraping using VBA
-
Hands-on experience with Selenium-based VBA Automation - Browser automation, Web element identification, Dynamic waits / synchronization, Handling pop-ups and dynamic web content
Good to Have Skills:
-
Experience with external VBA libraries and plugins
-
Understanding of browser and driver configuration
-
Knowledge of API integrations through VBA
-
Exposure to process automation / RPA concepts
-
Experience in performance tuning of large macro-based solutions
Total Experience Expected: 02-04 years