Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

For Employers

Add office photos

Employer? Claim Account for FREE

HSBC Group

Compare

3.9

based on 4.8k Reviews

Video summary

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

Top Rated Banking Company - 2024

166 HSBC Group Jobs

Senior Consultant Specialist

HSBC electronic data processing india pvt ltd

3.9

based on 4.8k Reviews

8-9 years

Hyderabad / Secunderabad

1 vacancy

Senior Consultant Specialist

HSBC Group

posted 4d ago

Job Role Insights

Flexible timing

Key skills for the job

SQL Oracle Automation Testing Operations Analytical Chemistry Financial Services

+ 4 more

Job Description

At least 8 years of experience in Big Data, Pyspark, GCP , Hadoop Data Platform (HDP) and ETL and capable of configuring data pipelines.
Possess the following technical skills SQL, Python, Pyspark, Hive, Unix, ETL, Control-M (or similar)
Skills and experience to support the upgrade from Hadoop to Cloudera.
Good knowledge of Industry Best Practice for ETL Design, Principles, Concepts.
Data Extraction from Teradata, HIVE, Oracle, and Flat files
Ability to work independently on specialized assignments within the context of project deliverables
Take ownership of providing solutions and tools that iteratively increase engineering efficiencies.
Design should help embed standard processes, systems and operational models into the BAU approach for end-to-end execution of Data Pipelines
Proven problem solving and analytical abilities including the ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details and apply sound business and technical domain knowledge
Communicate openly and honestly. Advanced oral, written and visual communication and presentation skills - the ability to communicate efficiently at a global level is paramount.
Ability to deliver materials of the highest quality to management against tight deadlines.
Ability to work effectively under pressure with competing and rapidly changing priorities.
Responsible for automating the continuous integration/continuous delivery pipeline within a DevOps Product/Service team driving a culture of continuous improvement
Keep up-to-date and have expertise on current tools, technologies and areas like cyber security and regulations pertaining to aspects like data privacy, consent, data residency etc. that are applicable.

Requirements

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

8+ Years of IT Experience. Working knowledge on leading Regulatory projects. Possess in-depth knowledge and understanding of technical concepts, systems, and processes relevant to the organization. Strong working knowledge on Pyspark, GCP, Dataproc, Airflow.
Hands-on experience in Python, Spark, Hive, SQL, GCP and Hadoop technologies
Good to have exposure in Cloudera Data Platform (CDP), Big Data, Hadoop Data Platform (HDP) and ETL and capable of configuring data pipelines.
Skills and experience to support the upgrade from Hadoop to Cloudera. Good knowledge of Industry Best Practice for ETL Design, Principles, Concepts. Data Extraction from Teradata, HIVE, Oracle, and Flat files. Experience in handling/Conducting scrum ceremonies and practice Agile best practices.
Working knowledge on DevOps best practices and building CI/CD pipelines with end-to-end automation. Ability to work independently on specialized assignments within the context of project deliverables .

Employment Type: Full Time, Permanent

Read full job description

Prepare for Senior Consultant Specialist roles with real interview advice

Top HSBC Group Senior Consultant Specialist Interview Questions

Q1. Contains Duplicate Problem Statement Given an array of integers ARR and an integer K , determine if there exist two distinct indices i and ... read more

asked in Software Developer interview

View answer (1)

Q2. Palindromic Linked List Problem Statement Given a singly linked list of integers, determine if it is a palindrome. Return true if it is a p ... read more

asked in Software Engineer Trainee interview

View answer (1)

Q3. Search in a 2D Matrix Given a 2D matrix MAT of size M x N, where M and N represent the number of rows and columns respectively. Each row is ... read more

asked in Software Engineer Trainee interview

View answer (1)

View all 245 questions