SSIS Developer

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).