PL SQL - Manager

State Street Corporation; Bengaluru; Hybrid; INR 1,800,000 - 3,200,000; Full time

Job summary

State Street Corporation is seeking a PLSQL Developer - Manager to lead development and provide L4/SME support for Investment Performance and Analytics systems. The role involves release management, troubleshooting, and coordinating with multiple departments to resolve production issues.

You will contribute hands-on development while supervising delivery and working in a hybrid environment to support global clients and internal teams.

Qualifications

• Bachelor's degree in computer science or a related field.
• Expert in PL/SQL Programming and DDL & DML knowledge.
• Proficiency in Unix shell scripting; Linux upgrades desirable.
• Expert in PL/SQL Programming, UNIX scripting.
• Excellent knowledge of Oracle database objects and DW concepts.
• Understanding of Core and Advanced Java, Hibernate and JPA.
• Familiarity with Git, Harness and Artifactory.

Responsibilities

• Analyze and develop high quality software solutions aligned to the business goals.
• Should be able to work independently and collaboratively.
• Excellent understanding of programming, analytical and problem-solving skills.
• Experience dealing with users or clients from technical or business areas.
• Desire to work in a client-facing environment.
• Install, configure and test products; investigate problems; configure databases and performance analysis.
• Provide advanced technical expertise in debugging and maintaining software and coordinate with dev teams.

Skills

PL/SQL

Unix scripting

Java/JPA

Oracle objects

Data warehousing

Hibernate

Git

Perl scripting

Autosys

Artifactory

Financial domain

Education

Bachelor's degree in computer science or related field

Tools

Harness

Artifactory

Job description

PLSQL Developer - 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

• 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

• 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

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers Read our CEO Statement

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers Read our CEO Statement