PLSQL Developer - Assistant Manager

PLSQL Developer- Assistant Manager

Who we are looking for We are looking for a Software Development Engineer with hands-on experience to develop IT solutions and provide L4/SME support in State Street for Investment Performance and Analytics and in-house ETL Applications. The job entails resolving developer problems and maintaining application in State Street. Person will perform release management and day-to-day deliverables and handle major incidents and coordinate various other departments to resolve the production issues. Why this role is important to us The Team you will be joining is part of our technology function, Global Technology Services (GTS), which is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We’re driving the company’s digital transformation and expanding business capabilities using industry’s best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation. We offer a collaborative environment where technology skills and innovation are valued in a global organization. We’re looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company. Join us if you want to grow your technical skills, solve real problems and make your mark on our industry. What you will be responsible for As an Software Developement Engineer you will Analyze and develop high quality software solutions aligned to the business goals Should be able to work independently and collaboratively Should have excellent understanding programming, solid analytical and problem-solving skills Experience dealing with users or clients from either a technical or business area. Desire to work in Client facing environment. Install, configure and test product; problem investigation; database configuration, tracing and performance analysis. Provide advanced technical expertise in debugging and maintaining software applications and work with development teams to resolve issues. This role requires predominantly hands-on development as well as L3/L4 support work and ownership of deliverables as an individual contributor What we value These skills will help you succeed in this role Strong written and verbal communication skills. Strong partnership and relationship building skills. Exceptional organizational skills and attention to detail. Strong problem-solving ability Education & Preferred Qualifications Bachelor's degree in computer science or a related field. Expert Sybase/Oracle Programming and DDL & DML knowledge Proficiency in Unix shell scripting; experience with data center migrations or Linux version upgrades is highly desirable Expert in PL/SQL Programming, UNIX scripting Excellent knowledge on Oracle database objects (especially indexes, Partitioning and Views), database architecture and various components Excellent knowledge of Data warehouse, Type of Schemas and Dimensional Modeling. Understanding of Core and Advanced Java, including Hibernate, Persistence API, JSP, and JPA concepts Good working knowledge of Autosys or any job scheduling tool Familiarity with Perl scripting CGI (debugging and development) is a plus Additional requirements Knowledge of GIT, Harness and Artifactory is a plus Knowledge in Financial domain Work Requirement Need to work in a hybrid work environment