Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE
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
Submit CV To All Data Science Job Consultants Across Bharat For Free