drjobs VBA Developer Having strong database and PLSQL

VBA Developer Having strong database and PLSQL

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Dangs (India) - India

Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Key Responsibilities
Develop and maintain Excelbased applications using VBA to automate data processing and reporting tasks.
Perform data cleaning transformation and ETL processes to ensure highquality datasets for analysis.
Create and maintain macros for automated reporting and data manipulation in Excel.
Troubleshoot existing VBA subroutines and macros identifying functional and nonfunctional 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 TSQL including stored procedures to enhance data processing efficiency.
Design and implement Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD) for database design and documentation.
Collaborate with crossfunctional teams to understand data requirements and deliver analytical solutions.
Work with datacentric 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 69 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.
Indepth knowledge of PL/SQL and TSQL; ability to write optimized stored procedures.
Experience in creating Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD).
Familiarity with datacentric applications and data warehouse concepts.
Excellent problemsolving 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 Excelbased applications using VBA to automate data processing and reporting tasks.
Perform data cleaning transformation and ETL processes to ensure highquality datasets for analysis.
Create and maintain macros for automated reporting and data manipulation in Excel.
Troubleshoot existing VBA subroutines and macros identifying functional and nonfunctional 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 TSQL including stored procedures to enhance data processing efficiency.
Design and implement Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD) for database design and documentation.
Collaborate with crossfunctional teams to understand data requirements and deliver analytical solutions.
Work with datacentric 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 69 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.
Indepth knowledge of PL/SQL and TSQL; ability to write optimized stored procedures.
Experience in creating Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD).
Familiarity with datacentric applications and data warehouse concepts.
Excellent problemsolving skills with strong analytical and critical reasoning abilities.
Demonstrated ability to optimize database performance through effective indexing and query design.


data processing,indexing,diagrams,database performance optimization,data flow diagrams (dfd),data manipulation,data,macros,t-sql,vba,entity-relationship diagrams (erd),pl/sql,etl processes,data warehousing,sql,database programming,excel programming,query refinement,data analysis,database

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.