Job Description:
Key Responsibilities

• Develop and maintain Excel-based applications using VBA to automate data processing and reporting tasks.
• Perform data cleaning, transformation, and ETL processes to ensure high-quality datasets for analysis.
• Create and maintain macros for automated reporting and data manipulation in Excel.
• Troubleshoot existing VBA subroutines and macros, identifying functional and non-functional errors, and implementing fixes.
• Extend and enhance existing VBA subs and macros without breaking existing functionality.
• Interact with databases using ADODB, OLEDB, DAO, ODBC, Excel Connection for data retrieval and manipulation.
• Write and optimize complex queries in PL/SQL and T-SQL, including stored procedures, to enhance data processing efficiency.
• Design and implement Data Flow Diagrams (DFD) and Entity-Relationship Diagrams (ERD) for database design and documentation.
• Collaborate with cross-functional teams to understand data requirements and deliver analytical solutions.
• Work with data-centric applications and contribute to data warehousing projects.
• Analyze and troubleshoot performance issues within database processes and Excel macros, implementing optimization techniques such as indexing and query refinement.
• Provide insights through data analysis, supporting business decisions with actionable recommendations.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field having 6-9 years of experience
• Proven experience in VBA and Excel programming with a strong understanding of data manipulation.
• Proficiency in data processing, cleaning,



and ETL processes.
• Strong experience with ADODB connectivity, recordsets, and database programming.
• In-depth knowledge of PL/SQL and T-SQL; ability to write optimized stored procedures.
• Experience in creating Data Flow Diagrams (DFD) and Entity-Relationship Diagrams (ERD).
• Familiarity with data-centric applications and data warehouse concepts.
• Excellent problem-solving skills, with strong analytical and critical reasoning abilities.
• Demonstrated ability to optimize database performance through effective indexing and query design.
Position - VBA Developer having strong database and PL/SQL
Key Responsibilities

• Develop and maintain Excel-based applications using VBA to automate data processing and reporting tasks.
• Perform data cleaning, transformation, and ETL processes to ensure high-quality datasets for analysis.
• Create and maintain macros for automated reporting and data manipulation in Excel.
• Troubleshoot existing VBA subroutines and macros, identifying functional and non-functional errors, and implementing fixes.
• Extend and enhance existing VBA subs and macros without breaking existing functionality.
• Interact with databases using ADODB, OLEDB, DAO, ODBC, Excel Connection for data retrieval and manipulation.




• Write and optimize complex queries in PL/SQL and T-SQL, including stored procedures, to enhance data processing efficiency.
• Design and implement Data Flow Diagrams (DFD) and Entity-Relationship Diagrams (ERD) for database design and documentation.
• Collaborate with cross-functional teams to understand data requirements and deliver analytical solutions.
• Work with data-centric applications and contribute to data warehousing projects.
• Analyze and troubleshoot performance issues within database processes and Excel macros, implementing optimization techniques such as indexing and query refinement.
• Provide insights through data analysis, supporting business decisions with actionable recommendations.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field having 6-9 years of experience
• Proven experience in VBA and Excel programming with a robust understanding of data manipulation.
• Proficiency in data processing, cleaning, and ETL processes.
• Strong experience with ADODB connectivity, recordsets, and database programming.
• In-depth knowledge of PL/SQL and T-SQL; ability to write optimized stored procedures.
• Experience in creating Data Flow Diagrams (DFD) and Entity-Relationship Diagrams (ERD).
• Familiarity with data-centric applications and data warehouse concepts.
• Excellent problem-solving skills, with strong analytical and critical reasoning abilities.
• Demonstrated ability to optimize database performance through effective indexing and query design.

📌 Hiring for leading companies /VBA Developer (India)
🏢 Acura Solution
📍 India