SSIS Developer

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