:

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 robust 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 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.

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