Integration Specialist

Description

IT System Specialist – API Integration & SQL Development

Agency: Alabama Department of Finance

Location: Montgomery, Alabama

Job type: On-site Mon-Fri

Position Overview

The Alabama Department of Finance is seeking 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 support

• REST / SOAP API integrations

• SQL Server 2019 / 2022 development (queries, stored procedures, and data

transformation)

• Automated data exchanges

• Develop 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 Areas

This position primarily supports:

• Dell Boomi middleware interfaces

• REST / SOAP API integrations

• SQL Server queries and stored procedure development

• SSIS packages and data transformation processes

• GoAnywhere MFT workflows supporting secure file-based integrations

Important Note

This position requires hands-on technical development experience with Dell Boomi.

Applicants whose experience does not include direct, hands-on Boomi integration

experience will not be a strong match.

Key Responsibilities

• Build, 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:

o automated file exchanges

o secure data transmission workflows

o scheduling and monitoring integration jobs

o troubleshooting failed transfers and data processing issues

• Develop SQL Server solutions including:

o stored procedures

o query development

o data validation and transformation logic

o performance optimization

• Develop 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 Qualifications

• Bachelor’s degree in computer science or related technical field.

• 3-5 years of hands-on experience in:

o Boomi Integration Development

o SOAP / REST API integration development

o SQL Development

o Middleware / Interface Technical Support

• Strong SQL Server experience including:

o Complex queries

o Stored procedures

o Data transformation logic

o Data 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 Qualifications

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

Skills

boomi, rest api, soap rest, sql server, Integration, SSIS

Top Skills Details

boomi,rest api,soap rest,sql server

Additional Skills & Qualifications

Preferred Skills:

Skill

Experience with GoAnywhere MFT or similar enterprise file transfer solutions.

Skill

Experience supporting enterprise systems such as SAP, Oracle, Workday, or similar.

Skill

Experience with integrating UKG products via Dell Boomi (Workforce Management, HR, Payroll)

Skill

Experience building or supporting SSIS packages.

Skill

Familiarity with authentication methods such as OAuth, certificates, or token-based security.

Skill

Experience supporting production integration environments.

Skill

Exposure to automation or scripting using PowerShell, Python, or similar tools.

Experience Level

Intermediate Level

This is a Contract to Hire position based out of Montgomery, AL.

The pay range for this position is $38.00 - $48.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

This is a fully onsite position in Montgomery,AL.

This position is anticipated to close on Apr 20, 2026.

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.