Job description

Some careers shine brighter than others.

If you’re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.

HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.

We are currently seeking an experienced professional to join our team in the role of Software Engineer.

In this role, you will:

  • Develop, design, tune and maintain the ETL process. 
  • Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.
  • Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.
  • Integrates ETL development with existing projects to maximize object reuse
  • Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.
  • Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production
  • Troubleshoot data issues and defects to determine root cause.
  • Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques

Requirements

To be successful in this role, you should meet the following requirements:

  • Bachelor Degree or International Equivalent
  • Excellent written and verbal communication skills; presentation skills preferred
  • Experience in Financial domain (Banking).
  • Good knowledge and experience on Python, spark, ETL, Data Stage, DB2, Teradata , Oracle, Unix
  • Self-motivated, focused, detailed oriented and able to work efficiently to deadlines are essential
  • Ability to work with a degree of autonomy while also being able to work in a collaborative team environment
  • Experienced in Development of UNIX shell scripts for enhancing the ETL job performance.
  • Hands-on experience applying modelling techniques to actual business solutions
  • Experience in designing, developing and implementing Business Intelligence tools
  • Understanding and Experience on Unix/Linux system, file systems, shell scripting
  • Good knowledge of scheduling tools such as Control- M

You’ll achieve more when you join HSBC.

www.hsbc.com/careers

HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Issued by – HSDI