Senior Consultant Specialist

HSBC
Pune
Full timeFunction: Consulting & AdvisoryExperience: 8-10 yearsSkills: []

Design and develop ETL solutions using SSIS and SQL Server to acquire, transform, and load data across systems. Build and maintain database objects and security, create data transformations, and tune/debug ETL packages for accurate, efficient data movement. Develop ETL strategies for importing and transferring data between source, staging, and destinations; test and prepare deployments. Support system and acceptance testing, including troubleshooting existing packages.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
HSBC
HSBC
1 month ago

Senior Consultant Specialist

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 2 hours agoStatus: Live
Reposted: similar role first listed 7 months ago

Job Summary

Design and develop ETL solutions using SSIS and SQL Server to acquire, transform, and load data across systems. Build and maintain database objects and security, create data transformations, and tune/debug ETL packages for accurate, efficient data movement. Develop ETL strategies for importing and transferring data between source, staging, and destinations; test and prepare deployments. Support system and acceptance testing, including troubleshooting existing packages.
Location: Pune
Employment Type: Full time
Job Function: Consulting & Advisory
Seniority: Mid level

Key Responsibilities

  • •Design and develop SQL Server database objects (stored procedures, functions, views, triggers) for ETL.
  • •Develop SSIS/SQL ETL solutions to acquire and prepare data from multiple systems.
  • •Create SSIS data transformations, including importing from files and moving data between database platforms.
  • •Debug, tune, and ensure accurate and efficient execution of SSIS/ETL processes.
  • •Analyze and develop strategies for importing and transferring data between source, staging, and multiple destinations, including testing and deployment support.

Key Requirements

  • •Proficiency with SSIS ETL tools and MS CRM Data model (Kingswaysoft) and Azure Data Factory, with 8–10 years of experience.
  • •Design and develop SQL Server stored procedures, functions, views, triggers for ETL processes.
  • •Hands-on ETL development using SSIS transforms (e.g., conditional split, derived column, data conversion, merge join, multicast, file system task).
  • •Experience with Dynamics CRM Online projects and C# programming.
  • •Experience working on Agile projects and supporting testing/troubleshooting of ETL packages.
Experience:8-10 yearsETLCRMDynamics CRMAgile
Tech Stack:SQL ServerSSISSQLStored ProceduresFunctionsViewsTriggersETLKingswaysoftMS CRMMicrosoft Dynamics CRMDynamics CRM OnlineAzure Data FactoryC#Agile

Company Brief

HSBC
Global banking and financial services organisation offering retail, commercial, corporate and investment banking, wealth management, and global markets services across Europe, Asia, the Americas and the Middle East.
Industry: Banking
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: London, United Kingdom
Founded: 1865
Glassdoor
Glassdoor: 3.6
WebsiteLinkedIn