Consultant Specialist, HSBC

HSBC

Location:
India, Hyderabad

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

HSBC is seeking a Consultant Specialist with 8-12 years of experience to join the Technology team in Hyderabad, India. Responsibilities include advanced SQL development, optimizing queries, working with GCP services such as BigQuery, designing data workflows with Apache Airflow, Python programming, and staying current in data engineering. The role requires excellent problem-solving skills, communication abilities, and experience with CI/CD pipelines.

Job Responsibility:

Write complex SQL queries for data extraction, transformation, and analysis
Optimize SQL queries for performance and scalability
Analyze and improve query performance
Work with Google BigQuery for data warehousing and analytics
Manage and integrate data using Google Cloud Storage (GCS)
Design, develop, and maintain workflows using Apache Airflow
Write custom DAGs to automate data pipelines and processes
Develop and maintain Python scripts for data processing and automation
Debug and optimize Python code for performance and reliability
Write and debug basic shell scripts for automation and system tasks
Stay updated with the latest tools and technologies in data engineering
Collaborate effectively with cross-functional teams
Clearly communicate technical concepts to both technical and non-technical stakeholders.

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).

Nice to have:

Familiarity with other GCP services like Dataflow or Pub/Sub
Knowledge of CI/CD pipelines and version control (e.g., Git).

What we offer:

Continuous professional development
Flexible working opportunities
Inclusive and diverse environment
Opportunities to grow within an organization.

Additional Information:

Job Posted:
July 31, 2025

Expiration:
August 18, 2025

Employment Type:

Fulltime

Work Type:

On-site work

View All Jobs In This Company

Job Link Share:

Consultant Specialist