ETL Developer

Job description

Barclays moves, lends, invests and protects money for customers and clients worldwide. Please visit our website here for more information.

Data And Integration Services (DAIS):


Data and Integration Service (DAIS) is a team within Corporate Banking Technology responsible for providing services in the following areas

· BEM Real Time/Broker
· DWH (Data Warehouse and Reporting)
· MI Reporting
· Archival/Decommissioning
· CDI ETL: Customer Data Integration
https://confluence.barcapint.com/pages/viewpage.action?title=Data+And+Integration+Service+(DAIS)+Home&spaceKey=DAIS

Overall purpose of role:

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

Key Accountabilities and Skills required:
This section should include:
· Key specific accountabilities.

Design & Development

· Delivery of low level technical design documents adhering to DAIS middleware principles & standards
· Able to work 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 DAIS Middleware Enterprise design with functional and non-functional assessment for global implementations
· Design and design review of dependent programs
· Strong technical problem solving capabilities
· Issue escalation
· Validation of plans and progress management
· QA of deliverables

· Stakeholder management and leadership.

Project Management Support

· Assisting with the creation, monitoring and reporting of progress against project plans and identifying corrective action where necessary
· Providing inputs into risk analyses and development plans to take account of design decisions

Skills/Capability Growth

· Sharing knowledge with colleagues both proactively and on-demand
· Identifying development needs of junior team members

Taking proactive steps to maintain skills in relevant specialist areas, and continuously broadening knowledge of systems and technologies used within Barclays Group

· Decision making and problem solving.

· Should be able to make judicious decision with respect to ETL design so that the final ETL solution satisfies all the quality and non-functional requirements criteria.
· Should be able to come up with multiple approaches to any ETL problem statement/solution/technical challenge and take well informed decision to pick the best solution

· Risk and Control: All Barclays colleagues have to 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

Your Skills and Qualifications will include

· Strong knowledge of ETL dependent technologies in the below scope:
· Informatica PowerCenter (version 9.x)
· Informatica PowerExchange (optional)
· SQL
· Oracle (10g/11g) & Teradata
· Unix basics and shell scripting
· Functional Skills/Competencies:

- Requirement gathering & Analysis and other SDLC phases

- Coding with middleware principles

- 2 to 6 years of experience in ETL development and implementation

- Basic data modelling knowledge

- Well versed with ETL concepts and performance tuning

- Good written and verbal communication skills

- Team / module leading experience
· Hands on Informatica PowerCenter development with design and build of medium to large enterprise projects
· Maintaining and demonstrating a good knowledge of the Financial Services and IT industries, having an in depth knowledge of either several technologies/ systems/ business operations, or expert knowledge of a particular subject area
· Working on a single complex project, or multiple standard projects
· Understanding the solution design and any associated architectural standards, and supporting the resolution of design/build related issues throughout the project delivery lifecycle
· Supporting project management in planning, estimating, costing, RAID identification and management
· Assisting in the definition and maintenance of middleware implementation level architectures
· Experience in dealing with various file formats like XML, COBOL EBCDIC and flat files
· Foundation level knowledge of Ab>Initio is preferred

The Benefits: Our customers deserve the best. The same goes for our employees. That's why at Barclays you'll receive a range of benefits that include a competitive salary and all the tools, technology and support you need to succeed.

Our Culture: Everything we do is shaped by the five values of Respect, Integrity, Service, Excellence and Stewardship. The values inform the foundations of our relationships with customers and clients, but they also shape how we measure and reward the performance of our employees. Simply put, success is not just about what you achieve, but about how you achieve it.

Dynamic working gives everyone at Barclays the opportunity to integrate professional and personal lives, if you have a need for flexibility then please discuss this with the hiring manager.

Barclays is an equal opportunity employer and are opposed to discrimination on any grounds. For more detailed information, please visit our dedicated Diversity and Inclusion site here .