Integration Developer (SSIS, SQL) (SC Cleared, Public Sector)

GCS Recruitment Specialists; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

GCS Recruitment Specialists seeks an experienced SSIS integration specialist to drive system-to-system data exchange. You will design workflows, mappings, and transformations, and orchestrate data flows using Azure Logic Apps, Azure Data Factory, and SSIS.

You will build and maintain APIs (REST/SOAP), validate data exchanges, and collaborate with developers, data engineers, and QA to ensure reliable integrations across multiple platforms.

Qualifications

• Experience using SSIS for system-to-system integration rather than reporting/data warehousing.
• Proficient in designing data mappings and transformations across diverse systems.
• Knowledge of REST/SOAP APIs and authentication mechanisms.

Responsibilities

• Integration Design: gather requirements and design workflows, data mappings, transformations, and message schemas.
• Integration Platforms and Tools: orchestrate data flows using Azure Logic Apps, Azure Data Factory, SSIS; familiarity with Postman, Swagger, API gateways.

Skills

SSIS

Azure Data Factory

Azure Logic Apps

APIs

REST

SOAP

JSON

XML

CSV

Postman

Swagger

API gateways

Fiddler

Tools

Postman

Swagger

Fiddler

Job description

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

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.