IT - Finance - Integration Specialist
Dell Boomi Integration – API Integration & SQL DevelopmentLocation: Montgomery, Alabama (onsite from day1 )Duration: 6+ Months Contract with possible extension and conversionJob type: On-site Mon-FriPosition OverviewSeeking a technically focused IT System Specialist to support the development and ongoing operation of enterprise system integrations.This role focuses on backend integration development and support, including:Dell Boomi interface development and supportREST / SOAP API integrationsSQL Server 2019 / 2022 development (queries, stored procedures, and data transformation)Automated data exchangesDevelop and maintain file-based integrations using the GoAnywhere MFT platform, including automated file generation, SFTP transfers, job scheduling, and monitoring.This role centers on building, supporting, and troubleshooting system integrations and data workflows that support statewide financial, HR, and administrative systems.The ideal candidate enjoys working directly with system interfaces, automation processes, and enterprise data integrations.Core Technical Focus AreasThis position primarily supports:Dell Boomi middleware interfacesREST / SOAP API integrationsSQL Server queries and stored procedure developmentSSIS packages and data transformation processesGoAnywhere MFT workflows supporting secure file-based integrationsImportant NoteThis position requires hands-on technical development experience with Dell Boomi. Applicants whose background does not include direct, hands-on Boomi integration experience will not be a strong match.Key ResponsibilitiesBuild, troubleshoot, and maintain Dell Boomi integration processes, connectors, and data mappings.Design, develop, and support API-based integrations between enterprise systems.Develop and maintain file-based integrations using GoAnywhere MFT, including:automated file exchangessecure data transmission workflowsscheduling and monitoring integration jobstroubleshooting failed transfers and data processing issuesDevelop SQL Server solutions including:stored proceduresquery developmentdata validation and transformation logicperformance optimizationDevelop and support SSIS packages used for batch data movement and transformation.Monitor automated integrations and resolve production support issues across API and file-based interfaces.Diagnose integration failures, data discrepancies, and interface errors across enterprise applications.Document interface specifications, file layouts, data mappings, and operational procedures.Track development and support activities using ServiceNow or similar ticketing systems.Collaborate with functional teams to translate business requirements into implemented technical solutions.Required QualificationsBachelor's degree in computer science or related technical field.3-5 years of hands-on experience in:Boomi Integration DevelopmentSOAP / REST API integration developmentSQL DevelopmentMiddleware / Interface Technical SupportStrong SQL Server experience including:Complex queriesStored proceduresData transformation logicData manipulation (DML/DDL)Experience working with REST / SOAP APIs.Experience developing or supporting file-based integrations or secure file transfer processes.Demonstrated troubleshooting skills involving integrations, data workflows, or automated interfaces.Hands-on experience with Dell Boomi integration platform.Ability to communicate technical concepts clearly to business stakeholders.Preferred QualificationsExperience with GoAnywhere MFT or similar enterprise file transfer solutions.Experience supporting enterprise systems such as SAP, Oracle, Workday, or similar.Experience with integrating UKG products via Dell Boomi (Workforce Management, HR, Payroll)Experience building or supporting SSIS packages.Familiarity with authentication methods such as OAuth, certificates, or token-based security.Experience supporting production integration environments.Exposure to automation or scripting using PowerShell, Python, or similar tools.