Etl Designer

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

BUK & BX - All locations

Please discuss the detail of the working pattern options for the role with the hiring manager.

Introduction:
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
- Understanding of agile development methodology and practice it in day to day work
- Contribute to cost and effort estimation
- Design and implement ETL solutions with massively parallel processing architecture.
- Lead story based development & unit test and adherence to all coding standards
- Delivery of low level design documents with ETL strategy, standards and adhering to ETL 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
- 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, Ab Initio, Real Time processing and Mongo design with functional and non-functional assessment for global implementations
- Ensure delivery of high quality code that achieves consistently high code quality and test coverage ratings
- Report progress in JIRA against assigned activities in a timely manner.
- Be supportive within the team, both technically and culturally.

What we’re looking for:

- Ab>Initio (batch and real-time), Mongo DB, BigData - Hadoop, SQL, Oracle & Teradata, Unix basics and shell scripting
- 7+ years of experience in ETL development, design, and implementation of medium to large enterprise projects having moderate to high complexity, with Team/ module leading experience
- Data Modelling basics, Data Architecture basics
- Databases - Both Traditional Relational DBMS & NoSQL.
- Strong skills on ETL design patterns and data warehouse architecture
- Hands on Job Scheduling
- Requirement gathering & Analysis and other SDLC phases. Supporting project management in planning, estimating, costing, RAID identification and management
- Excellent written and verbal communication skill
- Stakeholder management

Skills that will help you in the role:

- AbInitio Data Quality, Metadata Hub
- AWS
- Deployment on Cloud
- Containerisation
- Continuous Integration/Continuous Deployment Pipelines

Where will you be working?
Pune

Be More at Barclays
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