SQL Server Integration Service; SSIS) Developer

SQL Server Integration Service (SSIS) Developer About the job SQL Server Integration Service (SSIS) Developer
1. Background and Justification

The client is advancing the implementation of the SS&C ALGO solution to support Asset and Liability Management (ALM), risk analytics, financial calculations, and related reporting capabilities.

The implementation requires reliable interfaces between internal source systems, data repositories, and the SS&C ALGO platform, including data extraction, transformation, validation and reconciliation rules, secure file transfer, exception handling, and operational monitoring.

To support the implementation and stabilization of these interfaces, the client requires a technical consultant with hands-on experience with SQL Server Integration Services (SSIS) and, preferably, cloud development capabilities.

The consultant will help design, build, test, troubleshoot, document, and support data integration components used by the implementation team. The ideal profile should be proactive, collaborative, energetic, and eager to learn, while maintaining solid technical discipline and attention to quality.

Note: SSIS is required for the current implementation. Cloud development experience is desirable, as the client is planning to gradually move away from the current technology toward modern cloud-based solutions.

The objective of this consultancy is to provide technical support for the design, development, testing, deployment, and operational support of SS&C ALGO data interfaces, with emphasis on:

• SQL Server Integration Services (SSIS)
• SQL Server
• Cloud-based integration patterns
• Automation
• Data validation and reconciliation
• Production readiness and operational support

The consultant shall provide specialized services covering interface development, ETL automation, cloud integration support, testing, documentation, and knowledge transfer.

• Design, develop, enhance, and maintain SSIS packages supporting the SS&C ALGO interface implementation.
• Implement data extraction, transformation, mapping, validation, reconciliation, and loading routines using SQL Server and SSIS.
• Support secure batch integration processes, including file generation, naming conventions, archival, logging, and exception handling.
• Assist with deployment preparation, configuration management, and environment-specific parameterization across development, testing, UAT, and production environments.

• Support cloud-oriented integration components, automation scripts, orchestration jobs, and monitoring processes as required by the solution architecture.
• Collaborate with infrastructure, security, database, and application teams to align interface components with the client standards for security, access, and operational resilience.
• Contribute to modernization discussions where existing integration logic may be simplified, reused, or migrated to cloud-compatible services.

• Develop and execute technical unit tests, integration tests, reconciliation checks, and data quality validations for interface outputs.
• Analyze discrepancies by tracing data from source systems through transformation layers and SS&C ALGO input files or staging objects.
• Support UAT preparation, defect triage, root‑cause analysis, issue documentation, and remediation tracking with business and technology stakeholders.

• Prepare technical documentation, data mappings, package inventories, deployment notes, monitoring procedures, and operational support guides.
• Support production readiness activities, including runbooks, restart procedures, auditability, controls, and…