HR Ab Initio ETL Developer
Barclays
Chennai, IN
7d ago

Description

Job Title : HR Ab Initio ETL Developer

Grade : BA4

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.

Your Role

  • 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
  • Essential Skills

  • 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
  • DesirableSkills

  • 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.

    Apply
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form