Helpdesk Click here to connect with our resourcing helpdesk team ?
Skip to main content

Date live: Nov. 24, 2022

Business Area: COO & Functions

Area of Expertise: Technology

Reference Code: 90325606

Contract: Permanent

Job Title: ETL Designer

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 career, 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.

This role spans across leading / working on multiple projects or modules and coordinating with teams to understand requirements, develop and implement Ab>Initio based ETL solutions and maintaining them.

What will you be doing?

To provide end to end ETL Design solutions and support Architecture in defining strategies

  • Leading team of designers and developers
  • To understand the overall purpose of the projects and contribute to requirements & data analysis, and provide solutions from an ETL perspective
  • Delivery of low level design documents with ETL & DWH strategy, standards and adhering to BCI ETL & BIW principles & policies
  • Provide approval and oversight to requirement documents as entry criteria to design and development
  • Hands-on support to build and development team for issue resolution and completion
  • Accountable for closure of any design and build related queries/issues
  • Participate in various ETL, BIW and MI POCs and present findings to the Senior Architects
  • Leading a team of designers/developers working on one or multiple projects of varying complexity, undertaking the following activities, maintaining overall accountability for the work of the team in terms of quality and timeliness of delivery
  • Strong understanding of ETL, DWH and Report designs with functional and non-functional assessment for global implementations

What we’re looking for:

Strong design & development knowledge of ETL and dependent technologies listed below:

  • Ab>Initio (Batch and Real Time Development)
  • Unix basics and shell scripting
  • SQL
  • Oracle & Teradata Basic concepts
  • Data Modelling basics
  • Data Architecture basics
  • Strong skills on ETL design patterns and data warehouse architecture
  • Hands on BIW design & development skills with design and build of large enterprise projects

Skills that will help you in the role:

  • Ab>Initio Data Quality
  • Ab>Initio Meta Data Hub
  • KAFKA
  • AWS
  • MongoDB
  • HIVE
  • Basic data modelling knowledge

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.

Our Values

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.

Our Diversity

We aim to foster a culture where individuals of all backgrounds feel confident in bringing their whole selves to work, feel included and their talents are nurtured, empowering them to contribute fully to our vision and goals.

Our Benefits

Our customers are unique. The same goes for our colleagues. That's why at Barclays we offer a range of benefits, allowing every colleague to choose the best options for their personal circumstances. These include a competitive salary and pension, health care and all the tools, technology and support to help you become the very best you can be. We are proud of our flexible working options for colleagues. If you have a need for flexibility, then please discuss this with us.

More about working at Barclays

The Barclays Way

This is the spirit of Barclays. It’s why we exist, what we believe and how we behave. But most importantly, it’s how we make decisions, take action and get things done.

Learn more

Purpose

We exist to provide responsible finance to people and business – 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.