What are the responsibilities and job description for the Integration Specialist position at Seneca Resources Company, LLC?
Position Title: Integration Specialist
Location: Montgomery, Alabama
Clearance Requirements: None
Position Status: Contract
Pay Rate or Salary: W2 $40/hr Max
Top Requirements:
- Bachelor’s degree in computer science or related technical field
- 3-5 years of hands-on experience in:
- Boomi Integration Development
- SOAP / REST API integration development
- SQL Development
- Middleware / Interface Technical Support
- Strong SQL Server experience including:
- Complex queries
- Stored procedures
- Data transformation logic
- 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 Skills:
- 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
Job Description:
IT System Specialist – API Integration & SQL Development Agency: Department of Finance Location: Montgomery, Alabama Job type: On-site Mon-Fri Must be able to convert to Merit: GC or USCMSP: Knowledge Services (Documents in the files) Position Overview 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 background 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: automated file exchanges secure data transmission workflows scheduling and monitoring integration jobs troubleshooting failed transfers and data processing issues Develop SQL Server solutions including: stored procedures, query development, data validation and transformation logic, 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:
- Boomi Integration Development
- SOAP / REST API integration development
- SQL Development
- Middleware / Interface Technical Support
- Strong SQL Server experience including:
- Complex queries
- Stored procedures
- Data transformation logic
- 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
At Seneca Resources, we are more than just a staffing and consulting firm, we are a trusted career partner. With offices across the U.S. and clients ranging from Fortune 500 companies to government organizations, we provide opportunities that help professionals grow their careers while making an impact.
When you work with Seneca, you’re choosing a company that invests in your success, celebrates your achievements, and connects you to meaningful work with leading organizations nationwide. We take the time to understand your goals and match you with roles that align with your skills and career path. Our consultants and contractors enjoy competitive pay, comprehensive health, dental, and vision coverage, 401(k) retirement plans, and the support of a dedicated team who will advocate for you every step of the way.
Seneca Resources is proud to be an Equal Opportunity Employer, committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.
Salary : $40