COO & Functions
Location
Pune | India
Job description
Job Title : 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
Take ownership for managing risk and strengthening controls in relation to the work you do
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, and your request will be reviewed subject to business needs.
Hybrid Working
Structured hybrid role:
At Barclays, we offer a hybrid working experience that blends the positives of working alongside colleagues at our onsite locations, together with working from home. We have a structured approach where colleagues work at an onsite location on fixed, ‘anchor’, days of the week, for a minimum of two days a week or more, as set by the business area (or nearest equivalent if working part-time hours). Please discuss the working pattern requirements for the role you are applying for with the hiring manager. Please note that as we continue to embed our hybrid working environment, we remain in a test and learn phase, which means that working arrangements may be subject to change on reasonable notice to ensure we meet the needs of our business.
Introduction:
• The role is for a strong all-round Sr. Database developer working as a ODS Technical Lead within the CTO - Ways of Working team,
• The purpose of this role is to provide a specialist service in the field of Business Intelligence to provide a service to the global change portfolio community. Business intelligence ranges from the identification and extraction/collation of data sets through to the analysis and representation of the data. The role sits within Barclays Functions Management office and will work on HP PPM Data amongst other internal data sources. This role will involve interpreting and translating business analysis and data models to a technical solution within a data warehouse. The individual will need to build tables, data links to other systems, developing ETL scripts and packages and data transformations.
What will you be doing?
o Supporting the product vision to continue to allow the ODS database to be a one stop shop for all change data
o Provide technical guidance and leadership to ODS team members.
o Work in collaboration with other CTO teams to achieve business objectives.
o Developing new table structures and data links to bring in new data sources
o Ensuring all data warehouse tasks run as expected, troubleshooting where necessary
o Maintain documentation to the strategic requirements
o Support the development and release cycles of the warehouse capabilities
o Respond to warehouse relating incidents within agreed SLA
o Peer reviews of other BI Developers code
o Input into the technical design and planning to migrate existing Dataware house to the new ODS data platform.
o Create new ETL packages using SSIS Complex Transformations and Error Handling
o Developing Python Scripts for Data Ingestion and Job Scheduling
o Create SQL Agent Jobs and Troubleshoot errors.
o Create new reports using SSRS
o Performance tune and enhance existing environment
o Responding to warehouse related incidents
o Provide technical guidance to other team member where required
o Participate in a culture of knowledge sharing, including maintaining documentation in Confluence.
What we’re looking for:
o Advanced Transact-SQL – triggers, functions etc. and Minimum Microsoft SQL Server DB skills
o Microsoft BI Stack (SSIS, SSRS)
o Visualization tools Tableau
o Ability to understand the business context and translate business requirements to technical solutions.
o Data and warehouse modelling and ETL design and development
o Hands-on development in Python
o Basic Python Knowledge on Database connectivity and job scheduling
o PostgresSQL SQL Performance Tuning
o Domain knowledge of finance / Banking
o Oracle / p-SQL experience
o Strong spoken & written communication skills
Skills that will help you in the role:
Good to have Skills:
o Knowledge of Webservers.
o AWS/Cloud.
o Knowledge of GitHub, Jenkins, CICD pipeline.
Programming Languages:
o Java or python, J2EE, SQL & PLSQL, XML, HTML, Web services.
o Understanding of how to interoperate with web services.
o Understanding of REST and SOAP services.
o UNIX and Linux commands.
Databases:
o Oracle
o MS SQL
o PostgresSQL
Skills / Aptitude Required:
o Strong spoken & written communication skills.
o Ability to communicate with different teams to get the problems resolved on Priority.
o Ability to understand the business context and translate business requirements to technical solutions.
o Strong technical skills with demonstrated ability to learn.
o Good problem solving skills
o Good team player.
o Personal & Interpersonal skills
Where will you be working?
Pune
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.
Job tags
Salary
