VBA Developer
1 Nos.
92821
Full Time
6.0 Year(s) To 9.0 Year(s)
Not Disclosed by Recruiter
IT Software - Client Server
IT-Software/Software Services
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 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.
Key Skills :
Company Profile
we strive to exceed your expectations by providing client centric recruitment model and focus on networking,
Apply Now
- Interested candidates are requested to apply for this job.
- Recruiters will evaluate your candidature and will get in touch with you.