Integration Developer (SSIS, SQL) (SC Cleared, Public Sector)
Reference: 1234567_1791191323
your recent hands-on SSIS experience, especially where you have used SSIS for system-to-system integration, rather than mainly reporting or data warehousing.
Be prepared to explain:
- Which systems you integrated using SSIS
- How data moved between the systems
- What transformations/mappings you performed
- How frequently the integration ran
- How you handled errors and validate
- Integration Design:
Collaborate with business stakeholders, IT teams, and external partners to gather integration requirements and define workflows. Design data mappings, transformations, APIs, and message schemas to facilitate the secure and efficient exchange of data between systems. - Integration Platforms and Tools:
Utilize integration platforms such as Azure Logic Apps, Azure Data Factory, SSIS, or other middleware tools to orchestrate data flows and integrate diverse systems. Experience with tools such as Postman, Swagger, and API gateways is highly desirable. - API and Service Integration:
Build and maintain APIs (REST and/or SOAP), working with authentication, authorization, and secure data exchange. Integrate internal and third-party APIs to facilitate service-oriented and event-driven architecture across systems. - Data Transformation and Mapping:
Implement data transformation logic to convert between formats like JSON, XML, and CSV. Design reusable components and mappings to streamline data flow between systems with different schemas or protocols. - Testing and Debugging:
Perform unit, integration, and end-to-end testing of integration workflows and APIs. Debug issues using tools such as Fiddler, Postman, and application logs. Continuously optimize performance and reliability through code refactoring and system tuning. - Documentation and Reporting:
Document API contracts, integration configurations, and solution architecture to support maintainability. Provide progress updates, technical summaries, and risk reports to stakeholders throughout the project lifecycle. - Collaboration and Communication:
Work closely with software developers, data engineers, QA teams, and business analysts to align integration work with broader project goals. Clearly communicate technical designs, project updates, and roadblocks to both technical and non-technical stakeholders.
- Continuous Learning:
Keep up-to-date with integration frameworks, cloud technologies, and development best practices. Actively participate in knowledge-sharing sessions and contribute to the continuous improvement of integration standards and code quality
GCS is acting as an Employment Business in relation to this vacancy.
Integration Developer (SSIS, SQL) (SC Cleared, Public Sector)
Other similar jobs
Popular job searches
Your next job
starts here.
JOB SPECIALISMS
LATEST JOBS
TOP SEARCHES
LOCATIONS
- Engineering
- IT Support & Infrastructure
- Controls & Automation
- Data
- Project Management
- Network security consultant
- BI & Data Analytics
- DevOps
- Hardware & Electronics
- Testing & QA
- Software Development
- Embedded Software
LATEST JOBS
- Data Analyst
- Fully Remote | Contract | Acti...
- Integration Developer (SSIS Pa...
- Integration Developer (SSIS, S...
- OT Cyber Security Consultant -...
- Atlassian Technical Consultant
- Cloud Infrastructure Engineer
- Infrastructure Capacity Planni...
- Cloud Infrastructure Capacity...
- Cloud Capacity Engineer
- SC Cleared OT Cyber Security C...
- Senior Full Stack Engineer
TOP SEARCHES
LOCATIONS
- Engineer
- Data Scientist
- Senior Data Scientist
- Head of Data Science
- Trainee Data Scientist
- Data Science Graduate
- Senior Financial Accountant
- Management Accountant
- Cost Accountant
- Civil Engineer
- Senior Civil Engineer
- Civil Design Engineer