Job Title : HR Ab Initio ETL Developer
Grade : BA3
TheHR Ab Initio ETLDeveloper role is part ofthe HR Technology & Change team tasked with the end to end design anddelivery of technology solutions to deliver targeted business outcomes acrossthe HR MI&A change portfolio.
Your primary responsibility will be toact as a conduit between business stakeholders and development teams to deliver
oA simplified MI&A technology architecture, supported by easyto use reporting tools
oA common reporting language (consistent definitions,interpretation of HR data and share best practice)
oA set of tools that adhere to all relevant risks and controls suchas data privacy, security and compliance best practice.
The HR Technology Ab Initio ETL Developer works under thedirection of the Lead ETL Developer and designated Project Managers.
This role will focus around the design, development and support ofa new HR Data Warehouse platform.Thesewill be delivered as part of either the Software Development Lifecycle (SDLC)or the Lean Control Process (LPC) depending whether the project is consideredto be waterfall or agile.
Irrespective of the project governance applicable, the typicalactivities cover working closely with Project Managers, Solution Architects,Data Warehouse Designers and Business Analysts to take requirements through totechnical design and coding.
The rolealso ensures the test activity is in line with the functional and businessrequirements, working closely with the different HR Technology teams.
Design and implement an HR Data Warehouse using Ab Initio
Work with business owners, business analysts and solutionarchitects to understand business requirements and solution design
Translate functional and technical requirements into IT solutionsand prepare documentation and specifications for build and for support handover
Estimate level of effort required to develop code that meetsacceptance criteria
Design and develop subject areas within a MS SQL Server datawarehouse and any MS SQL applications required to support the HR MI&A team.
This will include the end to end development of Ab Initio ETL process fromvarious source systems into with SQL databases.
Coordinate with other onshore and off-shore developers, deliverworking code
Conduct peer reviews and provide documented constructive feedback
Ensure development meets all the specifications and has successfullypassed all tests including unit, integration, regression and system tests
Ensure performance, security, and availability of databases
Tier-3 support and production release support- respond promptly torequests from the support team in order to resolve user queries and handletechnical issues that are out of scope for the support staff.
Profile server resource usage, and optimize and tweak as necessary
Handle common database procedures such as upgrade, backup, recovery,migration, etc.
Responsible for the technology implementation of changes
Selectappropriate tool sets and develop systems such that they fit into BarclaysDevOps ecosystems
Strong proficiency with Ab Initio across the product stack
Strong proficiency with MS SQL and its variation among populardatabases
Proven experience of metadata management and data qualitymanagement using Ab Initio
Previous experience within an HR MI & Analytics area
Experience with some of the modern relational databases
Knowledge of best practices when dealing with relational and starschema databases
Capable of configuring popular database engines and orchestratingclusters as necessary
Ability to plan resource requirements from high levelspecifications
Capable of troubleshooting common database issues
Familiar with tools that can aid with profiling server resourceusage and optimizing it
Proficient understanding of code versioning tools such as Git / Mercurial / SVN
Thesuccessful candidate will be educated to first degree level or equivalent in anengineering or computer science discipline.
Experiencewith SSAS will be beneficial
Experienceinterfacing with front end reporting tools like : Business Objects, Qlikview
Experienceof HR enterprise systems like : SAP HR
Experience of productivity tools like : Jira, Bitbucket, Confluence
About UsBarclays is a transatlantic consumer,corporate and investment bank offering products and services across personal,corporate and investment banking, credit cards and wealth management, with astrong presence in our two home markets of the UK and the US.
Our goal is tobecome the bank of choice by providing superior services to customers andclients and supporting our stakeholders via a commercially successful businessthat generates long-
term sustainable returns.
For further information on EVP,please click on the link below
Risk and Control Objective
All Barclay’scolleagues have to ensure that all activities and duties are carried out infull compliance with regulatory requirements, Enterprise Wide Risk ManagementFramework and internal Barclays Policies and Policy Standards.