Hiring IT System Specialist API Integration & SQL Development
Location Montgomery, Alabama
Onsite
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.
Never miss an opportunity! Create an alert based on the job you applied for.
