SSIS, ETL, Dynamics CRM, Kingswaysoft, ADF/Senior Consultant Specialist (Pune, MH, IN, 411006)

HSBC
Pune
Full timeFunction: Consulting & AdvisoryExperience: 8-10 yearsSkills: ["Analytical thinking","Troubleshooting","Problem-solving","Agile collaboration"]

Design, develop, and maintain SQL Server and SSIS-based ETL solutions to acquire, transform, and load data across multiple systems. Build and orchestrate Azure Data Factory pipelines for cloud and on-premises sources, including incremental loads, error handling, and deployments. Debug, optimize, and tune ETL/ADF workflows, create database objects and security controls, and support UAT/production deployment for reliable, efficient data movement.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
HSBC
HSBC
15 hours ago

SSIS, ETL, Dynamics CRM, Kingswaysoft, ADF/Senior Consultant Specialist (Pune, MH, IN, 411006)

✓ Verified Job

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

Source: Company careers pageValidated by: Fursa AI
Last checked: 1 hour agoStatus: Live

Job Summary

Design, develop, and maintain SQL Server and SSIS-based ETL solutions to acquire, transform, and load data across multiple systems. Build and orchestrate Azure Data Factory pipelines for cloud and on-premises sources, including incremental loads, error handling, and deployments. Debug, optimize, and tune ETL/ADF workflows, create database objects and security controls, and support UAT/production deployment for reliable, efficient data movement.
Location: Pune
Employment Type: Full time
Job Function: Consulting & Advisory
Seniority: Mid level

Key Responsibilities

  • •Design, develop, and maintain SQL Server stored procedures, functions, views, and triggers to support ETL processes.
  • •Build SSIS and SQL-based ETL solutions and data integration workflows for transforming and moving data between source systems and database platforms.
  • •Debug, optimize, and tune SSIS packages and ETL processes to ensure accurate, reliable, and efficient data movement.
  • •Design, implement, and maintain Azure Data Factory pipelines to orchestrate data extraction, transformation, and loading across cloud and on-premises environments.
  • •Support testing and deployment by preparing ETL processes for production and non-production environments and assisting with system and UAT testing.

Key Requirements

  • •Minimum 8–10 years of relevant experience in SSIS, ETL development, and data integration.
  • •Strong proficiency with SSIS ETL tools and Microsoft Dynamics CRM data model, including KingswaySoft and Azure Data Factory.
  • •Hands-on experience with Azure Data Factory pipelines (linked services, datasets, integration runtimes, triggers, and activities such as Copy Data and ForEach).
  • •Experience integrating Azure Data Factory with SSIS, SQL Server, Microsoft Dynamics CRM Online, KingswaySoft, and other cloud or on-premises sources.
  • •Agile experience and strong analytical, troubleshooting, and problem-solving skills; C# programming skills required.
Experience:8-10 yearsETLData integrationAzureMicrosoft Dynamics CRMCloudOn-premises
Skills:Analytical thinkingTroubleshootingProblem-solvingAgile collaboration
Tech Stack:SQL ServerSSISSQLETLStored proceduresFunctionsViewsTriggersAzure Data FactoryPipelinesLinked servicesDatasetsIntegration runtimesCopy DataLookupForEachExecute SSIS PackageIncremental loadsError handlingC#

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