Snr ETL Developer

Job Description

Snr ETL DeveloperEnsure 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 WorkingWe 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, 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 Adherence to AGILE Methodologies Develop Surveillance components in Informatica Power Centre, SQL, Shell scripts. 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 optimizeWhat we re looking for: Bachelors/Masters or equivalent degree from a recognized university. Minimum 3-7 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 is a plus. 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,

Keyskills :
informatica power centerrisk management frameworkab initioimpact analysis