SSIS Developer

Allegis Group; Hyderabad; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Allegis Group in Hyderabad is seeking an experienced ETL developer to design, build, test, and deploy SSIS-based data integration solutions, connecting source systems with Dynamics 365 CRM.

You will implement robust ETL processes, perform data quality checks, optimize T-SQL, and work with stakeholders to translate requirements into scalable designs. This is a full-time role emphasizing BAU support and ongoing improvement in a fast-paced environment.

Qualifications

• 5+ years of hands-on SSIS development and ETL delivery.
• Proficient in KingswaySoft SSIS Toolkit for Dynamics 365 CRM integrations.
• Strong SQL Server skills: advanced T-SQL, indexing, and performance tuning.
• Solid understanding of ETL best practices.

Responsibilities

• Design, develop, test, and deploy SSIS packages for end-to-end ETL/data integration solutions.
• Build and maintain integrations between source systems and Dynamics 365 CRM using KingswaySoft adapters/connectors.
• Develop robust data extraction, transformation, and load processes including incremental loads, upserts, and data synchronisation.
• Write and optimise complex T-SQL (stored procedures, functions, views, performance tuning).
• Perform data mapping, data quality checks, reconciliation, and root-cause analysis for data issues.
• Work with stakeholders to understand requirements and translate them into technical designs.
• Support production deployments and BAU activities (incident fixes, enhancements, monitoring).
• Produce technical documentation (ETL design, mappings, runbooks, support notes).

Skills

ETL development

SSIS

Data integration

SQL Server

T-SQL

Data mapping

Data quality

Tools

KingswaySoft SSIS Integration Toolkit

SQL Server Management Studio

Job description

Role & responsibilities

• Design, develop, test, and deploy SSIS packages for end-to-end ETL/data integration solutions.
• Build and maintain integrations between source systems and Dynamics 365 CRM using KingswaySoft adapters/connectors.
• Develop robust data extraction, transformation, and load processes including:
  • Incremental loads, upserts, and data synchronisation patterns
  • Error handling, logging, auditing, and restartability
• Write and optimise complex T-SQL (stored procedures, functions, views, performance tuning).
• Perform data mapping, data quality checks, reconciliation, and root-cause analysis for data issues.
• Work with stakeholders to understand requirements and translate them into technical designs.
• Support production deployments and BAU activities (incident fixes, enhancements, monitoring).
• Produce technical documentation (ETL design, mappings, runbooks, support notes).

Preferred candidate profile

5+ years of hands-on experience in SSIS development and ETL delivery.

• Strong experience with KingswaySoft SSIS Integration Toolkit, specifically for Dynamics 365 CRM integrations.
• Strong SQL Server and database skills:
  • Advanced T-SQL, query optimisation, indexing basics, execution plan understanding
  • Data modelling concepts and relational database fundamentals
• Solid understanding of ETL best practices (performance, scalability, maintainability).