We have a opening for our client company VBA +SQL Developer position Pune.
Experience :5+ Yrs
Notices : Immediate to 15 Days
Location : Pune
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
Working with strict Service Level Agreements (SLAs)
Required functional skills / Needed Experiences
Managerial Requirements Experience: 3-5+ years proven Technical exp.
Adaptability Managing cross functional projects.
Good communication skills (Written and Oral) and Interpersonal Skills enabling
Required functional skills Basic Database concepts (must have)
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 Join
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