Barclays Looking for PC-IT-TDB-Oracle Developer (OB) at Pune, Maharashtra Full Time

Job Title: PC-IT-TDB-Oracle Developer (OB)

Location: Pune

About Barclays

Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group.

Risk and Control Objective

Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards.

Working Flexibly

We’re committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers’ and clients’ needs. Whether you have family commitments or you’re a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life.

If you would like some flexibility then please discuss this with the hiring manager.

Introduction:
The role is for a Senior Oracle Developer on the TDB (Transaction Database) team. The jobholder is responsible for

Developing and enhancing the TDB application. This includes perform technical assessment of requirements received, effort estimation, solution design, build/test the approved design and implementation into production environment in accordance with SDLC best practices.

Provide analysis and solution when production issues/job failures are escalated to build the bank.

Contribution in the overall stability of application by co-ordinating and pro-actively working along with RTB to enhance stability of TDB application.

Discuss with users, Business Analysts and understand the functional aspects of requirements

Participate in various organizational initiatives like Execution Excellence, Dev Ops etc.

What will you be doing?

Analysis:
Actively engaged external business and IT partners in the requirements analysis for system enhancements and changes.

Writing functional specifications if required.

Design:
Interpret and understand functional specifications

Writing technical design documents adhering to predefined standards

Code:
Hands on development of quality (i.e. readable, performing and supportable) PL/SQL code on an Oracle database, delivering the functionality detailed in the technical specifications

Hands on development of Autosys, Unix, and Perl scripts, delivering the functionality detailed in the technical specifications

Ensuring code written meets the predefined company and department standards

Performance Tuning:
Tuning existing code to ensure acceptable application performance

Review users queries to understand data access patterns and suggest enhancements to data model and/or indexing strategy

Quality Assurance:
Conducting reviews at various quality check points and providing constructive feedback

Mentoring junior members of the team

Testing:
Preparation of detailed unit test cases

Execution of unit test cases and documentation of results

Providing support during QA and UAT test phases

Diagnosis and resolution of defects found during QA and UAT test phases

Support regression testing – investigate output differences.

Implementation:
Packaging up codes for release into production

On implementation of releases, provide training to support team members

Post-Implementation:
Point of contact for support team, investigating and resolving issues found in production

Production Escalation:
The role demands to provide analysis and solution when production issues/job failures are escalated to build the bank (Production Escalation to BTB) in a timely manner. Individuals will be required to provide Production escalations on rotation basis.

Communication Responsibilities

Communicate directly with business analysts and project managers, understanding detailed business requirements at all stages of the development lifecycle

Communicate effectively with business users to gain an in-depth understanding of new requirements and minor system changes

Communicate effectively with the other external IT development teams and the local development manager.

Work closely with global development team members in Singapore, London and New York – participating in and contributing to technical discussions. Participate and contribute in technical discussions

What we’re looking for:
Experience and Qualifications:
A bachelor degree in Computer Science, Software Engineering or related.

Good experience years of hands-on Oracle database development experience.

Experience of working in a fast-paced and agile environment.

IB experience and working experience for data processing systems.

Technical Skills:
Extensive experience Oracle 11G , PL/SQL Development , Database design, SQL performance tuning

Experience with Unix (preferably Linux)

Good understanding of Data Warehouse and Data Mart concepts with proven experience in both

Ability to design and implement logical and physical data models

Hands on experience with GIT or similar version source code control tools.

Ability to perform effort estimation for a given piece of work.

Familiar with scheduling management technologies e.g. Autosys, Control M

Experience working with large Oracle databases (1 TB or more)

Ability to design and Model Database

Ability to quickly understand and provide short and long term solution to production issues.

Understand processes involved in supporting production environments

An ability to propose and implement enhancement in the established production processes

Skills that will help you in the role:
Able to work well with IT developers in multiple locations.

Knowledge of software development ‘best practices’. Good knowledge of the software development life cycle.

Analytical & Problem Solving skills – ability to investigate and resolve issues in a high-pressured environment.

Excellent written and verbal communication skills

Ability to multitask, Ability to train others.

Preferred:
Good understanding of investment banking, and the industry sector

Good understanding of front to back finance and operational process flows

Understanding of Agile SDLC concepts; Understanding of Scrum/Kanban Agile SDLC methodology

Where will you be working?

Pune

Be More at Barclays

At Barclays, each day is about being more – as a professional, and as a person. ‘Be More @ Barclays’ represents our core promise to all current and future employees. It’s the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be More Inspired by working alongside the most talented people in the industry, and delivering imaginative new solutions that are redefining the future of finance. Be More Impactful by having the opportunity to work on cutting-edge projects, and Be More Valued for who you are.

Interested and want to know more about Barclays? Visit home.barclays/who-we-are/ for more details.

Purpose, Values and Mindset

We deploy finance responsibly to support people and businesses, acting with empathy and integrity, championing innovation and sustainability, for the common good and the long term.

Our values underpin everything we do: Respect, Integrity, Service, Excellence and Stewardship.

Respect

We harness the power of diversity and inclusion in our business, trust those we work with, and value everyone’s contribution.

Integrity

We operate with honesty, transparency and fairness in all we do.

Service

We act with empathy and humility, putting the people and businesses we serve at the centre of what we do.

Excellence

We champion innovation, and use our energy, expertise and resources to make a positive difference.

Stewardship

We prize sustainability, and are passionate about leaving things better than we found them.

Our Mindset shapes how we take action, living by our Values, driven by our Purpose, always with our customers and clients at the heart of what we do; our Mindset is to Empower, Challenge and Drive.

Empower

Trust and support each other to deliver. Make decisions with those closest to the topic. Include diverse perspectives. Celebrate success and learn from failure.

Challenge

Question whether things can be done better. Use insights based on data to inform decisions. Be curious about how we can adapt and improve. Speak up and be open to alternative viewpoints.

Drive

Focus on outcomes. Deliver with pace. Be passionate and ambitious about what we do. Take personal responsibility. Actively build collaborative relationships to get things done.