HSBC Group

Business: CIB - Global Banking Tech

Open Positions: 1

Recruiter Name: Amber ZHU

Location: GZ

Why join us?

Some careers have more impact than others.

If you’re looking for a career where you can make a real impression, join HSBC and discover how valued you’ll be.

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, FEM’s mission is to provide HSBC customers with market differentiating services, and frontline teams with both: enhanced simplified tooling and sophisticated data intelligence. We are at the forefront of designing and implementing the ‘Future of the Front Line’.

The Opportunity:

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

Candidate User Guide: Global Banking & Commercial Banking have chosen Microsoft Dynamics 365 for Sales as the core customer relationship management (CRM) platform, which is currently live in ~55 countries.

What you’ll do:

As a SSIS Developer you will be working closely and effectively with our customers and responsible for reviewing clients’ business process, providing solid analysis, assessing solutions and advising our customers on how to best meet their goals.

• Working knowledge of process development and industry specific best practices
• High degree of insight and analytical skill
• Ability to work independently, prioritize and solve problems proactively
• Creative problem solving and conflict resolution
• Excellent facilitation, discovery, analysis, and prototyping skills
• Team-oriented; willing to align work with team’s priorities and goals
• Creates high-quality deliverables
• Excellent communication, presentation, training, client relationship and analytical skills
• Places emphasis on project value and client satisfaction
• Successful completion of applicable product certification exams

Must have skills

• Proficient with SSIS ETL tools. Min 4- 5 Years of experience.
• Should have hands on experience on different transform components like conditional split, derived column, data conversion, BDD, merge join, multicast, File system task,
• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from various systems.
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.
• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
• Design, implement and maintain database objects (tables, views, indexes ) and database security.
• Analyze and develop strategies and approaches to import and transfer data between source, staging and various destinations. Good to have CRM knowledge.
• Test and prepare ETL processes for deployment to production and non-production environments.
• Support system and acceptance testing including the development.
• Should be able to troubleshoot existing packages

What additional skills will be good to have?

Preferred Skills

• Experience on working on a Dyanmics CRM Online Project
• C# programming skills
• Experience working on Agile projects
• Experience working with CI/CD pipeline

Link to Candidate User Guide:

https://hsbchrdirect.service-now.com/esc?id=kb_article&table=kb_knowledge&sysparm_article=KB0184596&sys_kb_id=712b5f041b1f82908d3a0fe7ec4bcbd6&searchTerm=IJP

You’ll achieve more at HSBC

HSBC is an equal opportunity employer 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. We encourage applications from all suitably qualified persons irrespective of, but not limited to, their gender or genetic information, sexual orientation, ethnicity, religion, social status, medical care leave requirements, political affiliation, people with disabilities, color, national origin, veteran status, etc., We consider all applications based on merit and suitability to the role.

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 HSBC Software Development (GuangDong) Limited***