Job Details

Trident Consulting is seeking a “Lead Integration Engineer – Boomi ” for one of our clients in “San Francisco, CA”, a global leader in Mobility and transportation network.

Job Title: Lead Integration Engineer – Boomi

Location: San Francisco, CA - Hybrid

Type: Contract

Rate: $60 to 64/hr on w2

Key Responsibilities:

• Design, develop, and maintain payroll integration solutions using Boomi.
• Design, develop, and maintain complex integration recipes on the Workato platform
• Architect scalable, enterprise-grade integration solutions across multiple systems and applications
• Build and optimize AI-powered automation workflows using Workato Genie
• Develop and deploy MCP (Model Context Protocol) servers to extend AI agent capabilities
• Implement Intelligent Document Processing (IDP) solutions for automated data extraction and processing
• Design and implement robust error handling and monitoring strategies for critical payroll data flows.
• Collaborate with business stakeholders to understand integration requirements and translate them into technical specifications.
• Integrate various business applications, including Salesforce, Workday, and Oracle, using Boomi.
• Develop and optimize SQL & PL SQL queries for database interactions.
• Provide production support for integration solutions, ensuring high availability and performance.
• Implement and manage SFTP and HTTP integrations for data transfer and communication.
• Troubleshoot and resolve integration issues in a timely manner.
• Document integration processes, configurations, and best practices.

Required Qualifications:

• Boomi Integration Experience: 8 years of hands-on experience with Boomi integration.
• Payroll/HR Integration Expertise: Strong, demonstrated experience in integrating payroll, Time & Attendance, or Human Resources applications (e.g., Workday HCM, ADP, Navia, Fidelity, Dayforce, Oracle Fusion HCM).
• Business Application Integration: At least 6 years of experience in integrating business applications using Boomi.
• Workato Experience: 4+ years of hands-on experience with the Workato integration platform.
• Recipe Development: Strong expertise in recipe development, including complex branching logic, error handling, and optimization.
• Additional Integration Experience: Experience with Salesforce, Workday, API, and Oracle integrations is a plus.
• SQL & PL SQL: At least 3-5 years of experience in SQL & PL SQL for any database.
• Production Support: At least 4 years of experience in providing production support for integration solutions.
• SFTP and HTTP Integrations: At least 1 to 2 years of experience using SFTP and HTTP integrations.
• Java/Groovy/JavaScript: At least 4 years experience in writing custom scripting using any of the Java/Groovy/JavaScript programming languages.
• Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven track record of delivering enterprise-scale integration projects

Preferred Skills:

• Familiarity with AI automation technologies like Workato Genie and MCP servers.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and as part of a team.
• Familiarity with other integration tools and technologies.
• Knowledge of best practices in integration and data management.

Work Environment:

• This position may require occasional on-call support for production issues.
• The role may involve working with cross-functional teams and stakeholders.

About Trident Consulting

Trident Consulting is an award-winning staffing and consulting firm headquartered in San Ramon, CA. Since 2005, we've partnered with Fortune 500 and high-growth companies to deliver high-quality talent across technology, engineering, business operations, and professional services.

We specialize in contract, contract-to-hire, and direct hire placements, supporting roles across IT, data & analytics, cloud, cybersecurity, finance & accounting, HR, operations, and more. With a strong focus on hard-to-fill and niche positions, our global recruiting engine enables us to deliver speed, quality, and scale.