Job Description

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 Senior Consultant Specialist.
We are looking for a Data Engineer with experience in Big Data processing technologies and techniques to develop, test, deploy, and optimize our Data Warehouse Solution and Data models/products. You will also need to work with our devops tooling to deliver continuous integration/deployment capabilities, automated testing, security and IT compliance.
In this role, you will:

• Design, build, test and deploy Google Cloud data models and transformations in BigQuery, environment (e.g. SQL, stored procedures, indexes, clusters, partitions, triggers, etc.)
• Deliver a data warehouse and pipelines which follow abstraction and 'database refactoring' best practice in order to support evolutionary development and continual change
• Protect the solution with appropriate Authorization and Authentication models, data encryption and other security components - this will include consumer registration and storage of identification and change management considerations
• Review and refine, interpret and implement business and technical requirements
• Ensure you are part of the on-going productivity and priorities by refining User Stories, Epics and Backlogs in Jira
• Manage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc.
• Estimate, commit and deliver requirements to scope, quality, and time expectations
• Deliver non-functional requirements, IT standards and developer and support tools to ensure our applications are a secure, compliant, scalable, reliable and cost effective
• Write well-commented, maintainable and self-documenting code
• Fix defects and provide enhancements during the development period and hand-over knowledge, expertise, code and support responsibilities to support team

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

• Hands-On experience of minimum 2 projects based on GCP Big Query
• Expert in database design, development and administration - understanding of relational and dimensional data models (and preferably Data Vault)
• Expertise in On-prem or Cloud Databases, Warehouses and Lakes
• Excellent understanding of GCP Architecting and solution design
• Proven experience / solid knowledge in developing and optimization of SQL/T-SQL procedures in Traditional or Cloud Databases
• Coding and development of DDL and DML database components
• Excellent knowledge of devops tools like Ansible , Jenkins, Github ,Puppet, Chef etc.
• IT methodology/procedural knowledge; Agile/Scrum, DevOps and ITIL principles.
• BS/MS degree in Computer Science, Engineering or a related subject
• Excellent communication and interpersonal skills in English. Proficiency in verbal, listening and written English is crucial.
• Enthusiastic willingness to rapidly and independently learn and develop technical and soft skills as needs require.
• Strong organisational and multi-tasking skills.
• Good team player who embraces team work and mutual support.
• Interested in working in a fast paced environment

What additional skills will be good to have?

• Experience with application monitoring & Production Support
• Broad experience with IT development and collaboration tools.
• An understanding of IT Security and Application Development best practice.
• Understanding of and interest in various investment products and life cycle and the nature of the investment banking business.
• Working in a global team with different cultures

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 - HSBC Software Development India

Skills Required