ETL Engineer / Software Engineer

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 ETL Support Engineer

In this role, you will :

• Responsible for troubleshooting of Extract, Transform, and Load (ETL) processes within a production environment, ensuring data integrity and timely delivery by monitoring jobs.
• Exposure to Grid technology for deployment of DataStage and knowledge of DataStage Parallel jobs is needed.
• Given the current team is highly technical in nature, expectations are that the candidate has hands on knowledge in technologies like Teradata, DataStage, Linux.
• Previous experience of working on Data related initiatives is desirable.
• Determine the optimal approach for obtaining data from diverse systems and moving it to the BI.
• Manage current and future needs of the data design and content.
• Previous experience of business and solutions analysis, hands on experience of project initiation are essential.
• Knowledge of APIs will be an added advantage
• Identifying issues, performing root cause analysis, and coordinating with development teams to resolve critical data pipeline problems.
• Able to understand \troubleshoot shell scripts and sql (Teradata) for regular maintenance jobs to improve performance.
• Able to address the vulnerabilities and ensure the service is compliant with all the controls.

Requirements

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

o Data Warehouse technologies

o ETL Technologies

o Banking specific Data models like IBM Banking Data Warehouse Model

o Cloud technologies and architecture

o Infrastructure Design and concepts