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 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 Consultant Specialist
12 - 16 years of experience with below requirements and skills:
Advanced SQL Development:
Write complex SQL queries for data extraction, transformation, and analysis.
Optimize SQL queries for performance and scalability.
SQL Tuning and Joins:
Analyze and improve query performance.
Deep understanding of joins, indexing, and query execution plans.
GCP BigQuery and GCS:
Work with Google BigQuery for data warehousing and analytics.
Manage and integrate data using Google Cloud Storage (GCS).
Airflow DAG Development:
Design, develop, and maintain workflows using Apache Airflow.
Write custom DAGs to automate data pipelines and processes.
Python Programming:
Develop and maintain Python scripts for data processing and automation.
Debug and optimize Python code for performance and reliability.
Shell Scripting:
Write and debug basic shell scripts for automation and system tasks.
Continuous Learning:
Stay updated with the latest tools and technologies in data engineering.
Demonstrate a strong ability and attitude to learn and adapt quickly.
Communication:
Collaborate effectively with cross-functional teams.
Clearly communicate technical concepts to both technical and non-technical stakeholders.
Requisitos
To be successful in this role, you should meet the following requirements:
Advanced SQL writing and query optimization.
Strong understanding of SQL tuning, joins, and indexing.
Hands-on experience with GCP services, especially BigQuery and GCS.
Proficiency in Python programming and debugging.
Experience with Apache Airflow and DAG development.
Basic knowledge of shell scripting.
Excellent problem-solving skills and a growth mindset.
Strong verbal and written communication skills.
Experience with data pipeline orchestration and ETL processes.
Familiarity with other GCP services like Dataflow or Pub/Sub.
Knowledge of CI/CD pipelines and version control (e.g., Git).
You’ll achieve more when you join HSBC
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