Job Description

Responsibilities About this role:

Provides technical support and development for computer applications and programs for Enhancements and New Projects. Uses diagnostic tools and/or analyzes and uses vendor specifications to troubleshoot complex computer application problems to maintain or restore service or data to programs, leads the resolution of complex issues or escalates as needed to meet established service level agreements. Proactively communicate status and issues related to all projects to managers when appropriate. Develop new applications (MS Access VBA) / processes outside of the standard systems / processes based on interaction with the customer. Prepares programming specifications and completes programming tasks to develop basic, and/or assist in the development of moderately complex, computer solutions. Should have VBA skills to complete the follow development: Forms, Report, and Security, create Loops, If Then Statements and Class Development, etc. Participate / Lead testing activities in accordance with project plan and task delivery deadlines. Performs modeling, simulations and analysis, prepares program test data, tests and debugs programs. Updates and completes documentation, procedures and user guides. Understands BCP, quality, security and compliance requirements for supported areas and analyzes changes for risk to the environment. Participate in testing and updating the business continuation plan; provides assistance and guidance to less experienced staff. Application development and implementation experience. Microsoft Office, VBA Programing, SQL Statement Writing/Coding (PL, TL and JET engine).
Performs maintenance and/or simple modification application programming tasks, and assists with testing and debugging applications/programs. May write queries or code to extract data and/or validate data loads using query wizard and design view to create joins, Expression builder and working with Pivot tables, DateDiff and IIF functions. Should have the ability to build SQL Statements with attributes such as: Parameters, Joins (Inner, Outer and Equal), Query types (Pass Through, Union, Cross Tab, Update, Append, Delete), Nested Queries and Query Optimization Theory, etc. Update related documentation and procedures. May assist with project sizing efforts, understands BCP, quality, security and compliance requirements for supported areas. Experience with design, development, testing and deployment of technology applications and macros. Microsoft Office, Windows Form Building (i.e. VB, VBA, Macros) SQL Statement Writing/Coding (PL, TL and JET engine)

Skills:-
Should be expert in VBA (Both Excel and Access), Specifically in Access.
Should be an expert in PL/SQL, SQL Server
Experience in Web Scrapping
Expert knowledge in MS Office
very good experience in design, development, testing and deployment of technology applications and Macros
Education: ME/ M.Tech./ MS (Engg/ Sciences)r r r r r r r Any Graduate
Industry: Financial Services/Stockbroking, Banking

Skills Required