Senior SSIS Developer

Role Description:We are seeking a highly skilled Senior SSIS Developer who is a hands-on expert. The ideal candidate will have deep experience designing, developing, optimizing, and troubleshooting complex SSIS packages and data integration solutions.This role requires expertise in working with advanced ETL patterns, third-party SSIS components (ZappySys), APIs (REST/SOAP), XML processing, and data integrity techniques such as checksums.Key ResponsibilitiesTechnical Development:Design, develop, and maintain complex SSIS packages for enterprise-scale data integration.Build robust ETL pipelines handling high-volume and diverse data sources.Implement and manage:Data transformations:Incremental loads (CDC, SCDs, delta logic)Error handling and logging frameworksIntegrate external systems via:REST/SOAP APIsZappySys connectorsXML / JSON data ingestion and parsingAdvanced Data IntegrationDevelop solutions using:XML parsing (XPath, XQuery)JSON transformationsChecksum/hash-based data validation and deduplicationWork with heterogeneous data sources including:SQL Server, Oracle, flat files, APIs, cloud data sourcesOptimize package performance for large datasets and complex transformationsDebugging & OptimizationTroubleshoot and resolve:Package failuresPerformance bottlenecksData quality issuesConduct deep debugging of SSIS workflows, scripts, and data flowsImplement performance tuning techniques (parallelism, buffering, indexing, query optimization)