VBA SQL Developer (Job Code : J39607)  

 Job Summary
Share this job on Facebook  Share this job on Twitter  Share this job on Linked In
 
Experience:
3.00 - 6.00  Years 
 
Location:
Pune
 
Designation:
VBA SQL Developer
 
Degree:
BCA, BE-Comp/IT, BTech-Comp/IT, BTech-Other, MCA
 
Educational Level:
Graduate/Bachelors
 
Stream of Study:
 
Industrial Type:
IT-Software/Software Services
 
Functional Area:
IT Software - Application Programming / Maintenance
 
Key Skills:
VBA, SQL
 
Job Post Date:
2018-06-18 17:33:11  
 
 

 Company Description
 
- Technology captive of one of the biggest retailers/whole sellers in the world.
- Other offices in Poland and Germany.
- Technical people strength of around 1400 employees.
- Serve the mother company that has retail/wholesale outlets in Europe, parts of Asia (including India) and North Africa.
 

 Job Description
 
Key responsibilities/accountability:
• 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
• Checking and correcting SQL Queries with Complex Joins