ETL Developer (Hybrid)

• Overview of Citi:

  Citi is a world-leading global bank. We have approximately 200 million customer accounts and a presence in more than 160 countries and jurisdictions worldwide. We provide consumers, corporations, governments, and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. We enable clients to achieve their strategic financial objectives by providing them with cutting-edge ideas, best-in-class products and solutions, and unparalleled access to capital and liquidity.

  Citi Belfast is one of the largest employers in Northern Ireland with a diverse and talented team of over 3000 people from over 40 different nationalities across our four Belfast offices.

  We are the only global investment bank operating in Northern Ireland. Every day, our local experts interact with global teams in over 100 countries developing and supporting next-generation technology solutions for the enterprise and delivering critical services to the bank and its customers, to make sure we are a stronger and safer organization for our clients.

  You will have a truly global reach, which will provide you with new experiences and development opportunities right here in Belfast’s iconic Titanic Quarter.

   

  Who are we looking For:

  Extract, Transform, and Load (ETL) processes Developer with strong analytical and technical ability with experience in ETL technologies like Abinitio, Talend, Spark, DB2 and Oracle. Able to work independently, good communication skills.

   

  Key Responsibilities:

  • Experience with data mapping / transformation projects using the tools Ab-Initio, Talend ,Spark

  • Excellent time management, verbal and written communications skills, as the job entails simultaneously managing multiple projects with and stakeholders.

  • Solid knowledge of SQL in the context of a major RDBMS such as Oracle, DB2, UDB.

  • Experienced in dealing with XMLs, JSONs (including schemas)

  • Comfortable with Linux environment and has ability to create automation shell scripts as needed.

  • Proactive attitude, ability to run projects with minimal direction given the geographically distributed nature of the team

   

  Knowledge/Experience:

  • Experience in Abinitio Talend,Spark,

  • RDBMS – Oracle/ Db2 /SQL Server

  • Quick learner of new tools and technologies

  • Knowledge in Big data/ Hadoop is a plus.

   

  Required Skills:

  • Demonstrable experience in Abinitio, Talend.

  • Working knowledge on Web based application architecture

  • Good working knowledge of script based programming languages e.g. Python

  • Experience in API and KAFKA messaging.

  • Working experience in a Batch Processing Environment and continuous flow

  • Technical experience with activities involving heavy reliance on data analysis skills, including data conversions, systems integration, reporting, business intelligence, or data warehousing very helpful

  • Scheduling tools like Autosys,  korn,

  • Well versed with automated testing

  • Agile Experience

   

  What we Offer:

  We work hard to have a positive financial and social impact on the communities we serve. In turn, we put our employees first and provide the best-in-class benefits they need to be well, live well and save well.

   

  We’ll provide you with the resources to meet your unique needs, empower you to make healthy decisions, and allow you to choose which benefits suit you and your personal life best.

   

  Visit our Global Benefits page to learn more.

   

  Highlights to our core benefits include:

  • Award winning pension

  • On-site health services

  • Private medical insurance packages to suit your personal circumstances

  • Paid parental leave

  • Generous holiday allowance starting at 27 Days plus bank holidays; increasing with tenure.

  Citi Belfast also champions diversity within our workforce, which helps us be well and live well together. We have over 40 different nationalities in our Northern Ireland offices, are a vocal supporter of LGBTQ+ rights, and are proud to have 47% of our leadership team made up of individuals who identify as women.

  We encourage and lead inclusivity through our Pride, Disability, Multicultural, Families Matter, and Women affinity networks that are run by and for, Citi Belfast colleagues; providing them with the support they need in their personal and professional journeys and supplying them with the tools to help educate colleagues on all things related to each network to help us work better together.