Ab Initio Developers

Northamptonshire  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

We are IT Recruitment Specialists partnered with a Global Consultancy who require Ab Initio Developers for their client based in Northampton

Key Accountabilities

  • Ab Initio ETL Designer, you will be able to develop complicated Ab Initio ETL processes to turn business requirements into Technology data solutions.
  • You will provide technically sound solutions for the ingestion, storage and presentation of enterprise data including ETL design, data storage strategies, data access and security in line with Business requirements/processes and create Analytical Ready Data.
  • You will drive the design of scalable solutions while considering recoverable and resiliency requirements.
  • You will employ agile techniques such as task estimation, test automation, deployment automation and continuous integration to enhance overall execution speed and product quality.
  • You will convert source to target mappings into ETL code.
  • You will collaborate with the data modellers and contribute to the physical data model design.
  • You will ensure to work in line with Global Data Management Standards and follow all Governance Controls as required for your work.
  • SOX/DQ - Performing gap analysis between existing SOX/DQ controls and the data governance/data reconciliation.
  • Lineage- Work with SOX Tech delivery team and ensure the lineage captured and Reconciliation between hops are documented.
  • Design and implement physical data and metadata repositories in Hive/Impala/HBase (as appropriate) corresponding to logical data models
  • Design and implement data service layer in Hadoop
  • Replicate data from current RDBMS based systems to the RFT Hadoop Data Lakes
  • Utilise Dev-Ops framework during the development activities

Essential Skills/Basic Qualifications:

  • Passion for programming and software development
  • Extensive knowledge of Ab Initio ETL development in Big Data world specially in Hadoop eco system
  • Knowledge of Hadoop Ecosystem- Cloudera distribution is preferred. Knowledge of key Hadoop components mainly HDFS, Zookeeper, YARN, HBASE, Hive, Impala, Spark SQL
  • Knowledge of software development using Python, Scala, Spark and Java is critical to this role.
  • Usage of DevOps tools and knowledge of it is key to success in this role.
  • Working knowledge on Teradata and Oracle databases.
  • Experience in creating Narrative documents for Governance to prove existing Controls work.
  • Experience in Datamodelling with good SQL skills in at least 1 enterprise grade RDBMS
  • Experience in Test/Behaviour Driven Development (including test automation and mocking tools)
  • Strong project and stakeholder management skill set.
  • Has an eye for data quality issues and providing solution to resolve and remediate

Desirable skills/Preferred Qualifications:

  • Banking/Financial domain and product knowledge is very important for this role.
  • Familiarity, certificates or experience with Amazon AWS Cloud is an advantage
  • Excellent Communication skills articulate and detail oriented.
  • Strong Stakeholder management ability experienced in managing high severity incidents and working under pressure.
  • Excellent interpersonal skills - exemplary team player and able to mentor junior members of the team.
  • Awareness of different cultural background of users and team members
  • Ability to work under pressure to deliver to committed timescales
  • Experience in building large structured and semi structured data stores.
  • Ability to build productive working relationships with other IT groups, business users and support teams.
  • Excellent problem solver.
  • Detailed accountancy/Finance knowledge to facilitate the right transformation strategies.
  • Previous experience within Finance, Treasury and Risk functions
  • Credit Risk banking experience/exposure
  • Regulatory experience (Impairment, Capital, BCBS239, etc.)
  • DevOps experience
  • Experience working with Consumer, Risk or Finance departments
Start date
ASAP
Duration
4 months
From
J & C Associates Ltd
Published at
05.08.2020
Project ID:
1953470
Contract type
Freelance
To apply to this project you must log in.
Register