Dell Boomi Integration Developer
Remote
6 Months Contract
Job Description:
We are seeking an experienced Dell Boomi Integration Developer to design, develop, and implement integration solutions connecting an Oracle Database containing GIS (Geographic Information System) data with IFS Cloud. The primary responsibility is to build integration workflows using Dell Boomi to extract, transform, validate, and process data from the source system and publish integration messages to Microsoft Azure Service Bus for downstream consumption by IFS Cloud.
The ideal candidate will have strong hands-on experience with Dell Boomi integration development, Oracle SQL, REST APIs, message-based integration, Azure Service Bus, and enterprise application integration patterns. The candidate will collaborate with business analysts, solution architects, database teams, and IFS Cloud developers to ensure secure, reliable, and scalable data exchange.
Key Roles and Responsibilities
Design, develop, and maintain integration processes using the Dell Boomi AtomSphere platform.
Integrate the source system, Oracle Database containing GIS data, with the target application, IFS Cloud, through Azure Service Bus.
Configure Boomi database connectors to connect to Oracle Database and retrieve GIS-related data using SQL queries, stored procedures, or other approved extraction methods.
Analyze source data structures, schemas, relationships, and business rules to ensure accurate data mapping and transformation.
Develop Boomi processes to extract, validate, transform, and prepare source data into the required message payload format.
Publish integration messages from Dell Boomi to Azure Service Bus queues or topics using supported connectors, APIs, or custom integration components.
Implement message serialization and payload mapping using JSON, XML, or other agreed-upon formats.
Work with IFS Cloud integration requirements to ensure messages contain the correct business data, identifiers, and attributes required for downstream processing.
Implement appropriate message headers, correlation IDs, metadata, and tracking information to support end-to-end message traceability.
Configure secure connectivity, authentication, authorization, and credential management for Oracle Database and Azure services.
Implement error handling, exception management, logging, retry mechanisms, and dead-letter handling in alignment with the integration architecture.
Ensure data integrity, duplicate prevention, and appropriate processing of failed or partially processed messages.
Optimize Boomi process execution, database queries, batch sizes, and message throughput to meet performance and scalability requirements.
Perform unit testing, system integration testing, end-to-end testing, and production validation.
Troubleshoot integration failures related to database connectivity, data transformation, message publishing, authentication, and downstream processing.
Collaborate with IFS Cloud functional and technical teams to validate message contracts and resolve integration issues.
Maintain technical documentation, including interface specifications, data mappings, process flows, configuration details, and operational support procedures.
Support deployment, monitoring, release management, and production incident resolution across development, test, and production environments.
Technical Skills and Qualifications
Dell Boomi
Hands-on experience with Dell Boomi AtomSphere integration development.
Proficiency in Boomi processes, connectors, maps, profiles, business rules, document handling, and process reporting.
Experience with database, REST, HTTP, and other relevant connectors.
Knowledge of reusable integration components, environment extensions, deployment, and process execution monitoring.
Experience implementing robust exception handling, logging, and retry strategies.
Oracle Database and GIS Data
Strong knowledge of Oracle Database, SQL queries, joins, views, stored procedures, and data extraction techniques.
Experience integrating structured data from enterprise source systems.
Understanding of GIS-related data structures, identifiers, attributes, and spatial data concepts.
Ability to validate source records and transform GIS data into downstream-compatible payloads.
Experience handling spatial data types or spatial formats is an advantage where applicable.
Microsoft Azure Service Bus
Experience integrating enterprise applications with Azure Service Bus.
Understanding of queues, topics, subscriptions, message properties, and message delivery patterns.
Knowledge of message serialization, authentication, authorization, and secure connectivity.
Understanding of message settlement, retries, duplicate detection, dead-letter queues, and delivery guarantees.
Experience with Azure monitoring and troubleshooting tools is preferred.
IFS Cloud Integration
Understanding of IFS Cloud integration architecture and its supported inbound integration mechanisms.
Experience with REST APIs, API contracts, JSON/XML payloads, and enterprise application integration.
Ability to coordinate with IFS Cloud teams to confirm message schemas and downstream processing requirements.
Experience with IFS Cloud APIs or integration frameworks is highly desirable.
Required Qualifications
Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.
5+ years of experience in application integration, middleware development, or enterprise systems integration.
Strong hands-on experience with Dell Boomi.
Experience working with Oracle Database and SQL-based data extraction.
Practical knowledge of Azure Service Bus or comparable enterprise messaging platforms.
Experience with data mapping, transformation, validation, and message-based integration patterns.
Strong debugging, analytical, documentation, and problem-solving skills.
Ability to work independently and collaborate effectively with cross-functional technical teams.
Preferred Qualifications
Previous experience integrating Oracle-based source systems with IFS Cloud.
Experience with GIS data integration and spatial data processing.
Knowledge of Azure integration services and cloud-based enterprise architectures.
Experience implementing secure, reliable, and scalable integration solutions.
Familiarity with CI/CD, version control, automated testing, and integration deployment practices.
Understanding of enterprise data governance, auditability, and operational support requirements.
Integration Workflow
1. Source System: Connect to Oracle Database and retrieve GIS data.
2. Data Processing: Use Dell Boomi to extract, validate, map, and transform the data.
3. Message Creation: Generate the required JSON/XML message payload and associated metadata.
4. Message Publishing: Push messages from Dell Boomi to the designated Azure Service Bus queue or topic.
5. Target System: Enable the downstream IFS Cloud integration to consume and process the messages.
6. Monitoring and Support: Track message status, manage failures, and support reconciliation and troubleshooting.
Important: The integration design should clarify whether IFS Cloud consumes messages directly from Azure Service Bus or whether an intermediate consumer or integration service retrieves the messages and invokes IFS Cloud APIs.
Expected Deliverables
Dell Boomi integration processes and deployment configurations.
Oracle Database connectivity and GIS data extraction logic.
Source-to-target data mapping and transformation specifications.
Azure Service Bus message publishing configuration.
Error handling, retry, monitoring, and logging mechanisms.
Unit and integration test cases with documented results.
Technical documentation and production support handover.
Success Criteria
Accurate and reliable transfer of GIS data from Oracle Database into the agreed Azure Service Bus messaging architecture.
Correct message structure and compatibility with IFS Cloud integration requirements.
Secure connectivity and adherence to enterprise integration standards.
Effective monitoring, error recovery, and message traceability.
Successful completion of integration testing and production deployment.
Thanks,
Vinod.
