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
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.
Hybrid Working
We are currently in the early stages of implementing a hybrid working environment, which means that many colleagues spend part of their working hours at home and part in the office, depending on the nature of the role they are in. We re flexible on how this works and it may continue to change and evolve. Depending on your team, typically this means that colleagues spend a minimum of between 20% to 60% of their time in the office, which could be over a week, a month or a quarter. However, some colleagues may choose to spend more time in the office over a typical period than their role type requires. We also have a flexible working process where, subject to business needs, all colleagues globally are able to request work patterns to reflect their personal circumstances These requests will be reviewed and agreed for a period of time i.e., will have a start and end date.
Please discuss the detail of the working pattern options for the role with the hiring manager.
Introduction
Compliance ETL developer with a strong knowledge in Informatica Power Center, Python, SQL, Unix Shell Scripts, Scheduling tools like Autosys/Control-M, Agile methodologies and Continuous Integration for BARCLAYS Glasgow office.
This position will operate across the Global Compliance Technology arm of the bank, with the aim of ensuring that all regulatory, risk and control functions within the bank comply with new or amended regulatory requirements.
We are looking to add an experienced ETL Developer to our qualified and diverse development team. The candidate chosen will analyse, develop or enhance ETL applications with all standard controls in agile environment. The developer will be responsible for code development and modifications in surveillance projects and will work very closely with key stakeholders, leads.
What will you be doing
Understand and analyse requirements, provide estimations
Design solutions based on the business requirement
Out of box thinking - Come up with ways and means to reduce overall cost
Adherence to AGILE Methodologies
Mentoring new members joining the team
Develop Surveillance components in Informatica Power Centre, SQL, Shell scripts, Perl, Python
Follow TDD/BDD approach to ensure good scenario coverage
Discuss with leads, BA team to resolve any ambiguities or doubts
Deploy and test developed components on lower environments and prepare PROD releases
Adhere to DevOps processes
Timely revisit, review and improvise processes to optimize
What we re looking for:
Bachelors/Masters or equivalent degree from a recognized university.
Minimum 2-4 years of experience in designing and developing ETL layer using Informatica PowerCenter and SQL Hands on experience in writing complex Stored Procedures, Functions and indexes.
Very good understanding of writing and debugging of code.
Very good understanding of SQL and other DB objects.
Knowledge of Perl and Python is a plus.
Experience working with Netezza is a plus.
Experience working with Ab Initio is a plus.
Experience in INFRA activities like acquiring and migration to new servers, remediation etc.
Strong understanding of Systems Development Lifecycle
Ability to work closely with technical teams to find both technical and procedural solutions
Ability to manage daily tasks independently.
Good understanding of SCM tools like GIT, Perforce etc.
Quick learner; strong analytical and problem-solving skills and should possess excellent written and verbal communication skills.
Skills that will help you in the role:
Strong understanding of SQL, Stored Procedures, SQL Functions, Indexing.
Strong Solution Designing skills and analysis of Data.
Strong understanding of Data warehousing concepts, ETL Design, Informatica PowerCenter (Mandatory).
Knowledge of Perl is a plus.
Experience working with Netezza is a plus.
Strong understanding of scheduling tools like Autosys/Control-M.
Strong skills to analyse and improve performance of Database / ETL components.
Understanding and experience working with Python is a plus.
Understanding and experience working with Perl is a plus.
Experience in TDD approach, Continuous Integration (TeamCity/Jenkins).
Experience on Unix Shell scripting.
Exposure to Data Retention.
Good understanding of various asset classes Equities, Fixed Income, Derivatives, etc.
Ability to create and maintain technical documentation such as impact analysis, Data Flow Diagrams, Presentations and Spreadsheets is needed.
Excellent ability to communicate effectively with Business & IT development teams.
Exposure working across Compliance/ Risk programs is preferred.
Exposure to Regulatory projects involving Compliance (or otherwise) is preferred.
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.
# Software Engineering
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.
Hybrid Working
We are currently in the early stages of implementing a hybrid working environment, which means that many colleagues spend part of their working hours at home and part in the office, depending on the nature of the role they are in. We re flexible on how this works and it may continue to change and evolve. Depending on your team, typically this means that colleagues spend a minimum of between 20% to 60% of their time in the office, which could be over a week, a month or a quarter. However, some colleagues may choose to spend more time in the office over a typical period than their role type requires. We also have a flexible working process where, subject to business needs, all colleagues globally are able to request work patterns to reflect their personal circumstances These requests will be reviewed and agreed for a period of time i.e., will have a start and end date.
Please discuss the detail of the working pattern options for the role with the hiring manager.
Introduction
Compliance ETL developer with a strong knowledge in Informatica Power Center, Python, SQL, Unix Shell Scripts, Scheduling tools like Autosys/Control-M, Agile methodologies and Continuous Integration for BARCLAYS Glasgow office.
This position will operate across the Global Compliance Technology arm of the bank, with the aim of ensuring that all regulatory, risk and control functions within the bank comply with new or amended regulatory requirements.
We are looking to add an experienced ETL Developer to our qualified and diverse development team. The candidate chosen will analyse, develop or enhance ETL applications with all standard controls in agile environment. The developer will be responsible for code development and modifications in surveillance projects and will work very closely with key stakeholders, leads.
What will you be doing
Understand and analyse requirements, provide estimations
Design solutions based on the business requirement
Out of box thinking - Come up with ways and means to reduce overall cost
Adherence to AGILE Methodologies
Mentoring new members joining the team
Develop Surveillance components in Informatica Power Centre, SQL, Shell scripts, Perl, Python
Follow TDD/BDD approach to ensure good scenario coverage
Discuss with leads, BA team to resolve any ambiguities or doubts
Deploy and test developed components on lower environments and prepare PROD releases
Adhere to DevOps processes
Timely revisit, review and improvise processes to optimize
What we re looking for:
Bachelors/Masters or equivalent degree from a recognized university.
Minimum 2-4 years of experience in designing and developing ETL layer using Informatica PowerCenter and SQL Hands on experience in writing complex Stored Procedures, Functions and indexes.
Very good understanding of writing and debugging of code.
Very good understanding of SQL and other DB objects.
Knowledge of Perl and Python is a plus.
Experience working with Netezza is a plus.
Experience working with Ab Initio is a plus.
Experience in INFRA activities like acquiring and migration to new servers, remediation etc.
Strong understanding of Systems Development Lifecycle
Ability to work closely with technical teams to find both technical and procedural solutions
Ability to manage daily tasks independently.
Good understanding of SCM tools like GIT, Perforce etc.
Quick learner; strong analytical and problem-solving skills and should possess excellent written and verbal communication skills.
Skills that will help you in the role:
Strong understanding of SQL, Stored Procedures, SQL Functions, Indexing.
Strong Solution Designing skills and analysis of Data.
Strong understanding of Data warehousing concepts, ETL Design, Informatica PowerCenter (Mandatory).
Knowledge of Perl is a plus.
Experience working with Netezza is a plus.
Strong understanding of scheduling tools like Autosys/Control-M.
Strong skills to analyse and improve performance of Database / ETL components.
Understanding and experience working with Python is a plus.
Understanding and experience working with Perl is a plus.
Experience in TDD approach, Continuous Integration (TeamCity/Jenkins).
Experience on Unix Shell scripting.
Exposure to Data Retention.
Good understanding of various asset classes Equities, Fixed Income, Derivatives, etc.
Ability to create and maintain technical documentation such as impact analysis, Data Flow Diagrams, Presentations and Spreadsheets is needed.
Excellent ability to communicate effectively with Business & IT development teams.
Exposure working across Compliance/ Risk programs is preferred.
Exposure to Regulatory projects involving Compliance (or otherwise) is preferred.
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.
# Software Engineering
💡 Quick Summary
Seeking a career-building opportunity? The ETL Developer position is now open for candidates interested in the Software Developer Jobs sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Software Developer Jobs is a plus.
