Job Description

Job descriptionSome careers shine brighter than others.If you\xe2\x80\x99re 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 organizations 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 realize their ambitions.We are currently seeking an experienced professional to join our team in the role of Senior Software EngineerIn this role, you will:

• Responsible for performing system development work around ETL, which can include both the development of new function and facilities and the on-going systems support of live systems. There are a number of job functions within the role and the job holder may specialize in a single function or alternatively a combination of functions.
• Responsible for the documentation, coding and maintenance of new and existing Extract, Transform, and Load (ETL) processes within the Enterprise Data Warehouse.
• Investigate live systems faults, diagnose problems and propose and provide solutions.
• Report progress as required and advise of problems in good time.
• Convert requirements into sustainable technical solution through coding best practices.
• Write, analyze, review, and rewrite programs to departmental and Group standards.
• Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program.
• Update programs to increase operating efficiency or adapt to new requirements.
• Review code and documentation to ensure code meets the design criteria and work is of an acceptable quality.
• Review code from team members Analyst/Developers as part of the quality assurance process
• Produce unit test plans with detailed expected results to fully exercise the code.
• Correct errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced.
• Conduct unit testing of programs and software applications to be sure they will produce the desired information and that the instructions are correct.

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

• Must have 4+ yrs of experience with Datastage development
• Have experience on Datastage, Linux/Unix and SQL(Teradata is preferable), Scheduling tools (Control-M is preferable)
• Have exposure or worked on GCP\xe2\x80\x99s Data Storage and Processing services such as BigQuery, Dataflow, Bigtable, Cloud spanner, Cloud SQL.
• Extensive hands-on experience in Data Transformation Solution Implementation including configuration / maintenance / monitoring / backup & recovery.
• Strong understanding of data warehousing concepts, dimensional modelling, and data integration techniques.
• The role involves taking instructions, usually in written or diagrammatic form, and translating them into a code.
• Determine the optimal approach for obtaining data from diverse systems and moving it to the BI.
• Prepare all ETL processes according to business requirements. Responsible for creating functional and/or technical design solutions and ensuring those requirements are documented.
• Diagnose ETL and database related issues, perform root cause analysis and recommend corrective actions to management. Responsible to perform tests and validate the data flow.
• Manage current and future needs of the data design and content.
• Consults with users to resolve issues with programs. Contributes to the development of project plans and timelines, provide estimates for planned work.
• Work with a project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.
• Having exposure to data transferring mechanisms through Juniper framework.
• Stay updated with latest trends and best practices in ETL development, data engineering, cloud technologies, and Juniper networking.
• Good to have Google Cloud Certification (e.g., GCP Professional Data Engineer)

You\xe2\x80\x99ll achieve more when you join HSBC.www.hsbc.com/careersHSBC 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 \xe2\x80\x93 HSDI

HSBC