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.
Robust experience with KingswaySoft SSIS Integration Toolkit, specifically for Dynamics 365 CRM integrations.
Solid 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).

📌 Ssis Developer Hyderabad
🏢 Allegis Group
📍 Hyderabad