Adecco Group | Vba Developer(VBA, Excel,MS SQL Server exp.)-Required Females only | Hybrid – Bengaluru | Bharat | BigDataKB.com | 2023-03-05

Job Location: Hybrid – Bengaluru

Job Detail:

Mandatory skills required:-Candidate should have in depth experience in VBA/Excel advance concepts and MS SQL server (SSMS), VBA, Excel, MS SQL Server 2016

Job Role and Responsibilities:-

• As Developer, you will be supporting the Business Analyst who will frame the business requirements and design the system to the requirements of the business. The Business Analyst, will be working closely with you, providing standards and specifications for development of the system.
• Responsible for developing, maintaining and supporting Delivery operations processes in various departments and parts of the business.
• Develop forms for data capture and process workflows
• Write logic for automation of business rules in SQL Stored procedures and views
• Integrate data with data from other systems to create seamless integration using SQL SSIS scripts
• Ensure appropriate checks and error messages for users of the system to maintain accuracy and coherence of the data

Technical Skills required:

• Experience of creating applications with Microsoft Excel with SQL backend
• Using advanced Microsoft Excel functionality:
• Standard code libraries
• Writing complicated algorithms and calculations
• Working with VBA: Classes, Userforms, Functions, APIs, Calling SQL stored procedures
• Experience of using multiple development environments (DEV, UAT, PROD)
• Proven experience of working with Microsoft SQL Server 2016 & SSMS
• Creating and Maintaining Tables: Cascading Relational Tables ,Schemes,Foreign Keys, Indexing, Standardised naming conventions / datatypes
• Creating and maintaining Stored Procedures:- Specifically using the below SQL functionality / syntax: , XML , Merge, Update, Insert, Delete, Select statements, Joins , Input / Output parameters
• Creating and maintaining Views
• Analytical mindset
• Able to prioritise their workload and act under own initiative to meet business deadlines
• Able to express complex problems in a simple to understand way
• Agile methodology (would be an advantage)

Candidate’s with notice period of 15-30 days will be considered only

Apply Here

Submit CV To All Data Science Job Consultants Across Bharat For Free