Job Description

Job Title: ETL developer

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

WeaAEURA(TM)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 customersaAEURA(TM) and clientsaAEURA(TM) needs. Whether you have family commitments or youaAEURA(TM)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.a,

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

Introduction:

The role will be a ETL Senior developer role. The candidate needs to own the ETL technical delivery includes requirement analysis, Tech design and ETL technical delivery for the modules/projects assigned to the team.

Majority of the work requires Oracle PL/SQL skill set.

What will you be doing?

• Guide and mentor the junior team members on all technical aspects related to Oracle PL/SQL based ETL processes.
• Should be able to deliver the module assigned to the candidate independently with minimal help and should be able to track the tasks for his colleagues and vendor partners and resolve blockers for the candidateaAEURA(TM)s team.
• Should be willing to explore and learn Oracle PL/SQL features that candidate might have not used in the past.
• Should be able own and deliver his modules from development to implementation.

What weaAEURA(TM)re looking for: * Proficient in Oracle PL/SQL batch and/or continuous flow processes. Must have hands-on knowledge. Will have to build & deliver his module along with guiding junior members for the technical deliverables adhering to the technical design that candidate will build. Candidate will essentially own delivery of module assigned to him by his lead.

• Should have work with heterogeneous platform based ETL projects dealing with complex EBCIDIC files, Oracle database, Hadoop files etc.
• Should have hands on experience on Oracle DB objects like Package, Procedures, Function, View, Index, Partition creation etc.
• Should communicate effectively with US team and other stakeholders in India and US and should be able to estimate effort required for this tasks at least. Basic experience in planning for delivery will be required. Should be able to create WBS and assign tasks to team members (both permanent and SI partners), track them to completion & ensure quality delivery on time.
• Should have worked with TWS (preferred) or some other scheduling tool.
• Should be able to adjust to flexible working hours so that the candidate gets enough time to interact with the US time to effectively capture knowledge, requirements and then produce deliverables.
• Should be able to write complex SQL and should have worked with databases in past.
• Should understand the following concepts in PL/SQL and preferable to have hands on experience on most.
• Analytical Functions, Correlated SQLs, Usage of ROWNUM and behavior on ORDER BY clauses, Aggregate functions and difference with Analytical Functions, Dynamic SQLs, SQL Loader
• Cursors, Procedures, functions, triggers, packages, Collections (Varray, Nested Tables, Associate Arrays), Usage of Bulk Collect with save exceptions, Exception Handling
• Basics of following : Partitioning, Understanding of Explain Plan and Access Paths , Indexes, Optimizer Hints, Stats Gathering
• Should be able to work in Unix based environments and write shell scripts etc.

Skills that will help you in the role: * Oracle PL/SQL development proficiency (Primary Skill)

• Abinitio development proficiency (Secondary Skill) aAEURA" good to have
• Hands on Knowledge of PL/SQL implementations
• Oracle database skills., Aware of other no-SQL databases, mongo db etc.
• Unix scripting skills

Where will you be working?

• Pune

Be More at Barclays

At Barclays, each day is about being more aAEURA" as a professional, and as a person. aAEURA~Be More @ BarclaysaAEURA(TM) represents our core promise to all current and future employees. ItaAEURA(TM)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.

More about working at Barclays

Be More at Barclays

At Barclays, each day is about being more aAEURA" as a professional, and as a person. aAEURA~Be More @ BarclaysaAEURA(TM) represents our core promise to all current and future employees. 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.

Purpose and Values

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.

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.

Diversity and Inclusion

Barclays offers a diverse, inclusive and engaged culture. A place where people can bring their whole selves to work and be respected for who they are, valued for what they do and celebrated for their contribution to our business and our community.

We are an equal opportunity employer and opposed to discrimination on any grounds. It is the policy of Barclays to ensure equal employment opportunity without discrimination or harassment on the basis of race, colour, creed, religion, national origin, alienage or citizenship status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law.

Working Flexibly

WeaAEURA(TM)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 customersaAEURA(TM) and clientsaAEURA(TM) needs. Whether you have family commitments or youaAEURA(TM)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. Share job

More content

Previous Next

The Barclays Way

This is the spirit of Barclays. ItaAEURA(TM)s why we exist, what we believe and how we behave. But most importantly, itaAEURA(TM)s how we make decisions, take action and get things done.

Purpose

We exist to provide responsible finance to people and business aAEURA" but also a whole lot more.

Values

We believe great talent RISES. It acts with Respect, Integrity, Service, Excellence and Stewardship.

Mindset

We discover our full potential through our desire to Empower, Challenge and Drive each other.