SSIS/SQL Integration Engineer — APIs & Data Flows

GCS Recruitment Specialists; United States; Remoto; USD 90.000 - 120.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

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

Mansioni

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

Conoscenze

SSIS

Azure Data Factory

Azure Logic Apps

APIs

REST

SOAP

JSON

XML

CSV

Postman

Swagger

API gateways

Fiddler

Strumenti

Postman

Swagger

Fiddler

Descrizione del lavoro

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.