ETL big query/Senior Consultant Specialist

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.

In this role, you will:

·  Work closely with Business Users to capture new requirements and pain points
·  Performing Impact Analysis on requested changes
·  Translate requirements into solution.
·  Should be able to manage a team of 8 to 10
·  Be part of a team to ensure integrity, performance and reliability of DB
·  Be part of a team migrating from On-prem Oracle DB to the Google Cloud Platform
·  Should be able to handle multiple requirements from different areas with the help of team.
·  New implementations on Google Cloud Platform (especially Big Query solution)
·  Develop APIs to expose datawarehouse data (on GCP) to internal and external applications via Kong Gateway.
·  Estimation, Documentation for developments planned for the year
·  Support the Live Environment, providing Level 3 support and resolving issues

Requirements

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

·  GCP Big query and its various features like Authorized views, clustering, partition pruning etc.
·  Experience in Building ETL pipelines including SCD types natively in SQL.
·  Understanding of Dimensional Data modelling, Kimball DW methodology, facts, dimension, SCD Types, Star schema Design
·  Proficiency in writing performant/modular SQL, using CTEs, window functions, procedures, packages, materialized views, partitioning on MPP Data warehouses like Oracle / BigQuery / Snowflake etc.
·  Experience in integrating data from diverse sources such as DB2, MS SQL, Oracle and files like Avro/parquet/csv
·  Using python to ingest data from various data sources, stand up APIs using frameworks like Flask.
·  Using Git, GitHub, Jenkins or similar CICD tools
·  Agile engineering practices is essential
·  Agile technologies, ie Jira, GITHUB etc is essential

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