SSIS, ETL, Dynamics CRM, Kingswaysoft, ADF/Senior Consultant Specialist

HSBC Holdings plc; Pune District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

HSBC Software Development India is seeking a Senior Consultant Specialist to design, develop and maintain SSIS ETL processes and Azure Data Factory pipelines for cross-system data integration.

The role requires 8–10 years of hands-on experience with SSIS, ETL, SQL Server and Dynamics CRM, and involves Agile project work in a hybrid Pune-based environment.

Qualifications

• 8–10 years of experience in SSIS, ETL development and data integration.
• Proficiency in SSIS, Dynamics CRM data model, KingswaySoft and Azure Data Factory.
• Experience with Azure Data Factory pipelines, linked services, datasets and triggers.

Responsibilities

• Design, develop and maintain SSIS packages and ETL processes.
• Build and maintain Azure Data Factory pipelines for data extraction and loading.
• Integrate data from multiple sources including SQL Server and Dynamics CRM.
• Monitor, troubleshoot and optimize ETL workflows.
• Support testing and deployment in prod and non-prod environments.

Skills

SSIS/ETL

Azure Data Factory

SQL Server

Dynamics CRM Online

KingswaySoft

Agile

Data Integration

Analytical Skills

Job description

Location:

Pune, MH, IN, 411006

Brand: HSBC

Area of Interest: Technology

Role Workstyle: Hybrid Worker

Date: 25 Sept 2026

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:

• Design, develop and maintain SQL Server stored procedures, functions, views and triggers to support ETL processes.
• Design and develop SSIS and SQL-based ETL solutions to acquire, transform and prepare data from multiple source systems.
• Build data integration and transformation workflows using SSIS, including file imports and data movement between different database platforms.
• Debug, optimise and tune SSIS packages and other ETL processes to ensure accurate, reliable and efficient data movement.
• Design, implement and maintain database objects, including tables, views and indexes, as well as database security controls.
• Analyse data integration requirements and develop effective strategies for transferring data between source, staging and target environments.
• Design, develop and maintain Azure Data Factory pipelines to orchestrate data extraction, transformation and loading across cloud and on-premises source systems.
• Monitor, troubleshoot and optimise Azure Data Factory pipelines, including incremental loads, error handling and deployments across development, test and production environments.
• Test and prepare ETL processes for deployment across production and non-production environments. Troubleshoot and enhance existing SSIS packages and ETL processes.
• Support system and user acceptance testing, including the development of required test solutions.

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

• A minimum of 8–10 years of relevant experience in SSIS, ETL development and data integration.
• Strong proficiency in SSIS ETL tools, the Microsoft Dynamics CRM data model, KingswaySoft and Azure Data Factory.
• Hands-on experience with Azure Data Factory, including pipelines, linked services, datasets, integration runtimes, triggers and activities such as Copy Data, Lookup, ForEach and Execute SSIS Package.
• Experience integrating Azure Data Factory with SSIS, SQL Server, Microsoft Dynamics CRM Online, KingswaySoft and other cloud or on-premises data sources.
• Hands-on experience with SSIS transformation and control-flow components, including Conditional Split, Derived Column, Data Conversion, Slowly Changing Dimension, Merge Join, Multicast and File System Task.
• Experience working on Dynamics CRM Online projects.
• Experience working in Agile project environments.
• Strong analytical, troubleshooting and problem-solving skills.

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