Send me more jobs like this

VBA & SQL Developer (Job Code : J41012)

Keywords / Skills : VBA, SQL

3 - 5 years
Posted: 2019-05-11

IT/Computers - Software
Software Engineer/ Programmer
Posted On
11th May 2019
Job Ref code
Job Description
Key responsibilities/ accountabilities :

Develop tools based on the functional requirement.
Should be able to understand Functional requirement and Technical Solutions.
Extensively work towards understand the requirement and propose the best of solution apt to Metro-environment.
Manage multiple customers’ requirement at any given point in time.
Involved in Technical discussion with Support and IT team
Manage the Technical flow of day-to-day technical requirement
Create reports to update the Project`s progress.
Provides information by collecting, analyzing, and summarizing the service issues.
Creates / Updates documentation / Work flows for User Processes for various applications.
Develops / Recommends solutions / suggestions by studying information needs; conferring with users; studying systems flow.
Ability to understand Business needs and to look at the business problems (not just tech point of view)
Ability to estimate time/effort for given task & Task Planning/Scheduling
Time Management
Working with strict Service Level Agreements (SLAs)

Required functional skills :

· Basic Database concepts (must have)

• Database Normalization

• Inner Joins, Left Joins, Right Joins, Outer Joins

• Data "Unions"

· Microsoft Access (must have)

• Creating Tables, Queries, Sub Queries, Linked Tables, SQL Queries, with Complex Joins

• Data Import, Data Export

• Checking and Correcting errors in Queries, SQL, with Complex Joins

· Microsoft Excel (must have)

• All basic reference formulae (VLookup, Index, Match, Sumif, Getpivotdata etc)

• Pivot Tables, Pivot Charts, Data Links

• Creating new VBA Macros

• Checking and correcting existing VBA Macros

• Proper Data / Table Formatting

· Documentation (must have)

• Ability to document full scope of development/changes in Database, Excel

· Teradata database (nice to have)

• Creating SQL Queries with Complex Joins
Key Skill(s)

About Company

"Sampoorna Computer People is a Recruitment Agency established in 1990, providing consultancy exclusively in recruitment of IT, ITES (BPO) & Telecom Professionals. Our Head Office is in Mumbai (Bombay) and we have offices at Bangalore, Chennai (Madras), Delhi, Hyderabad and Pune. We are the first IT & Telecom specialist recruitment consultant certified for ISO 9001:2015 by BVQI India. Sampoorna is a founder member of ERA (Executive Recruiters Association) which is India’s Recruitment Agency’s Industry Organization Home page :"
Similar Jobs
View All Similar Jobs
Walkin for you