HSBC

1 day ago

SSIS, ETL, Dynamics CRM, Kingswaysoft /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: 2 hours agoStatus: Live

Job Summary

Design, develop, debug, and tune SSIS-based ETL solutions to move and transform data across multiple systems. Build SQL Server database objects and ensure secure, reliable data pipelines using tools such as Kingswaysoft and Azure Data Factory. Work with Dynamics CRM Online data, support testing and deployment to production and non-production environments, and collaborate on Agile projects with CI/CD practices.

Location: Pune

Workplace: Onsite

Employment Type: Full time

Job Function: Consulting & Advisory

Seniority: Mid level

Key Responsibilities

•Develop SSIS/SQL ETL solutions to import, transform, and transfer data between source, staging, and destination systems.
•Implement SSIS data transformations, including file-based imports and cross-platform data movement.
•Create and maintain SQL Server objects (stored procedures, functions, views, triggers, tables, views, indexes) and database security.
•Debug and optimize ETL packages and processes to ensure accurate and efficient data movement.
•Support system and acceptance testing and troubleshoot existing packages for deployment to production and non-production environments.

Key Requirements

•Proficient with SSIS ETL tools and MS CRM Data model (Kingswaysoft, Azure Data Factory), with 8–10 years of experience.
•Hands-on experience building SSIS transform components such as conditional split, derived column, data conversion, BDD, merge join, multicast, and file system task.
•Design and develop SQL Server stored procedures, functions, views, and triggers; design and develop SSIS/SQL ETL solutions to acquire and prepare data.
•Build data transformations with SSIS including importing data from files and moving data between database platforms.
•Debug and tune SSIS/ETL processes; design, implement, and maintain database objects and database security; support testing and troubleshooting.

Experience:8-10 years

Skills:Independent workProblem-solvingAnalytical thinkingCreative problem solvingCommunication

Tech Stack:SSISETLMS CRMKingswaysoftAzure Data FactorySQL ServerSQLDynamics CRM OnlineC#AgileCI/CD

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: 3.6

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

HSBC

1 day ago

SSIS, ETL, Dynamics CRM, Kingswaysoft /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: 2 hours agoStatus: Live

Job Summary

Location: Pune

Workplace: Onsite

Employment Type: Full time

Job Function: Consulting & Advisory

Seniority: Mid level

Key Responsibilities

•Develop SSIS/SQL ETL solutions to import, transform, and transfer data between source, staging, and destination systems.
•Implement SSIS data transformations, including file-based imports and cross-platform data movement.
•Create and maintain SQL Server objects (stored procedures, functions, views, triggers, tables, views, indexes) and database security.
•Debug and optimize ETL packages and processes to ensure accurate and efficient data movement.
•Support system and acceptance testing and troubleshoot existing packages for deployment to production and non-production environments.

Key Requirements

•Proficient with SSIS ETL tools and MS CRM Data model (Kingswaysoft, Azure Data Factory), with 8–10 years of experience.
•Hands-on experience building SSIS transform components such as conditional split, derived column, data conversion, BDD, merge join, multicast, and file system task.
•Design and develop SQL Server stored procedures, functions, views, and triggers; design and develop SSIS/SQL ETL solutions to acquire and prepare data.
•Build data transformations with SSIS including importing data from files and moving data between database platforms.
•Debug and tune SSIS/ETL processes; design, implement, and maintain database objects and database security; support testing and troubleshooting.

Experience:8-10 years

Skills:Independent workProblem-solvingAnalytical thinkingCreative problem solvingCommunication

Tech Stack:SSISETLMS CRMKingswaysoftAzure Data FactorySQL ServerSQLDynamics CRM OnlineC#AgileCI/CD

Company Brief

HSBC

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: 3.6

Website LinkedIn