Note: The job is a remote job and is open to candidates in USA. Avansis Solutions specializes in end-to-end Oracle and NetSuite implementations, custom development, and integrations. The Integration Consultant – SnapLogic will design, build, and maintain integration workflows between ERP systems, EDI trading partners, and enterprise applications, while troubleshooting data flows, analyzing production issues, and documenting integration solutions.
Responsibilities
- Gathering and analyzing integration requirements
- Developing and tuning PL/SQL packages and procedures
- Designing integrations between ERP and external or cloud applications
- Troubleshooting inbound and outbound data flows
- Performing root-cause analysis on production issues
- Document integration designs and data mappings
- Collaborate with business analysts, developers, and trading partners
- Contribute to integration best practices and standards
Skills
- Minimum 5+ years of EDI support and implementation experience, with a proven track record troubleshooting inbound and outbound data integration flows
- 5+ years of experience in application and data integration projects
- Hands-on expertise in PL/SQL, including development of packages, procedures, and functions, along with performance tuning
- Experience designing and developing integrations between Oracle EBS/ERP and external or cloud applications
- Strong working knowledge of Oracle PL/SQL databases
- Experience with REST APIs, web services, and file-based integrations
- Solid knowledge of data mapping, transformation, error handling, and integration monitoring
- Ability to troubleshoot production integration issues and perform root-cause analysis
- Strong working knowledge of integration middleware platforms, preferably SnapLogic, with hands-on experience building, testing, deploying, and supporting SnapLogic pipelines
- Experience creating and modifying correlation documents in OpenText Trading Grid/OpenText Business Network
- Strong analytical and problem-solving skills to debug complex integration errors
- Strong communication skills, with the ability to collaborate with business analysts, developers, and external trading partners
- Experience with Oracle E-Business Suite (EBS) preferred
Benefits
- Remote work arrangement in North America / India
- Contract employment
Company Overview