Summary

We are looking for a hands-on MuleSoft Architect / Developer to design, build, and deliver MuleSoft-based ETL integrations for a US-based client. The core scope is to extract data from Oracle databases and SFTP file feeds, transform it in Mule, and load it into Salesforce — targeting the Account, Order, and Order Line Item (OLI) standard objects.

This is a pure MuleSoft role — Salesforce is the destination system, not a Salesforce development engagement. The candidate will not be writing Apex, building Lightning components, or performing Salesforce administration. The work is owning the integration end-to-end on the MuleSoft side: source-to-target mapping, DataWeave transformations, Salesforce Connector usage, error handling, reconciliation, and performance.

The role is a hybrid Architect Developer position — the right candidate will own both the integration design and the hands-on build. This role offers flexibility to work as a part-time, contract, or full-time team member, depending on availability and preferences.

Engagement Details:

• Initial Duration: 2 months, with strong potential to extend through end of the calendar year based on performance and project needs.
• Work Mode: Remote, with mandatory US EST overlap until 1:00 PM EST daily (≈ until 10:30 PM IST).
• Client: US-based.
• Compensation – Initial 2 Months: INR 3,00,000 (3 Lakhs) total, paid as a single lump sum upon successful completion of the 2-month engagement (no advance / no milestone payments).

Key Responsibilities:

• Architect and hands-on develop MuleSoft (Mule 4) integration flows that load data from Oracle (JDBC) and SFTP file feeds (CSV, fixed-width, XML, JSON) into Salesforce.
• Map and load data into the Salesforce Account, Order, and Order Line Item (OLI) standard objects, maintaining parent-child relationships.
• Use the MuleSoft Salesforce Connector with Bulk API v1 / v2, upsert by External ID, and composite/tree requests for parent-child loads.
• Build performant, idempotent ETL pipelines with watermarking / incremental loads from Oracle and reliable file-handling patterns for SFTP.
• Develop clean DataWeave 2.0 transformations including complex mappings, lookups, aggregations, and type coercion.
• Implement robust error handling, retries, dead-letter routing, logging, monitoring, alerting, and reconciliation outputs.
• Tune performance for high-volume Salesforce loads while staying within Salesforce API and governor limits.
• Deploy Mule applications to CloudHub or Runtime Fabric, and set up CI/CD using Maven, Git, and Jenkins / GitHub Actions / Azure DevOps.
• Write MUnit test cases and ensure code quality.
• Participate in daily standups and design discussions with the US client during EST hours.
• Produce technical documentation, source-to-target mappings, runbooks, and handover artifacts.

Required Skills & Qualifications:

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Minimum 6 years of overall IT experience with strong hands-on MuleSoft Anypoint Platform (Mule 4) experience.
• Proven hands-on experience with the MuleSoft Salesforce Connector, including Bulk API v1 / v2, upsert by External ID, and loading parent-child object hierarchies (Account → Order → OLI).
• Strong knowledge of the Salesforce data model from an integration perspective — Account, Order, OLI, Pricebook references, standard vs. custom fields. (No Apex / Lightning development required.)
• Hands-on with the MuleSoft Database Connector / JDBC against Oracle — performant SQL extracts, incremental / CDC patterns.
• Hands-on with the MuleSoft SFTP Connector — scheduled pickups, archival, file locking, large-file handling.
• Strong DataWeave 2.0 skills — complex mappings, lookups, aggregations, type coercion.
• Experience with CloudHub / Runtime Fabric deployments and CI/CD for Mule (Maven, Git, Jenkins / GitHub Actions / Azure DevOps).
• Experience writing MUnit test cases.
• Solid understanding of error handling, retry / dead-letter patterns, security (OAuth 2.0, JWT, mTLS), and observability (logging, monitoring, alerting).
• Proven track record of working directly with US-based clients in a customer-facing capacity.
• Excellent verbal and written English communication — must be comfortable leading technical discussions with US stakeholders.
• Mandatory availability during US EST hours up to 1:00 PM EST (≈ up to 10:30 PM IST).

Good to Have:

• MuleSoft certifications (e.g., MCD – Developer Level 1 / Level 2, MCD – Integration Architect, MCD – Platform Architect).
• Prior experience integrating Oracle EBS / Oracle Fusion or similar Oracle source systems into Salesforce.
• Exposure to Salesforce Order Management or Salesforce CPQ data structures.
• Experience with cloud platforms (AWS / Azure / GCP).
• Familiarity with adjacent ETL / iPaaS tools (Informatica, Talend, Boomi).
• Experience with Agile methodologies and DevOps practices.

What the Platform Offers:

• Vetted Opportunities: Work with top global companies and exciting projects tailored to your expertise.
• Flexible Engagement: Choose between part-time, contract, or full-time roles based on your availability and career goals.
• Global Exposure: Collaborate with clients across industries, gaining diverse experience in the Salesforce and integration ecosystem.
• Supportive Ecosystem: Access a robust network of support from BlueHippo.io, including professional growth resources and mentorship.
• Time Zone Alignment: Work within US time zones, ensuring seamless collaboration with international teams.