ETL Integration Specialist plus iPaaS Developer

Project Technical Requirements Project Goal:

This project aims to establish a one-way application-to-application (A2A) integration to automate the synchronization of vendor contract data and their associated PDF documents from the organization’s Netsuite ERP solution into a separate Quickbase application. This ETL process will ensure QuickBase users may readily access contracts and the associated data without providing direct Netsuite user access.

Project Technical Requirements:

ETL Integration Specialist plus iPaaS Developer (NetSuite & Quickbase)

• Integration Design & Planning:

• Collaborate with NetSuite and Quickbase administrators, and business stakeholders, to deeply understand existing vendor contract data structures in NetSuite and define the target schema in Quickbase.
• Design the end-to-end integration architecture using an iPaaS platform (TBD: Dell Boomi, Workato, Celigo, etc.), including data extraction, transformation, loading (ETL) logic, and error handling strategies.
• Assist with evaluating and selecting an appropriate iPaaS platform for this project with considerations for future growth into other application-to application (A2A) integrations and projects.
• Develop data mapping specifications from NetSuite fields to Quickbase fields, including handling of PDF document attachments.

• iPaaS Development & Implementation:

• Build, configure, and test the integration workflows within the chosen iPaaS platform.
• Collaborate with Netsuite admins to configure NetSuite connectors to efficiently extract vendor contract data, including querying for specific contract records and retrieving associated PDF files from the NetSuite File Cabinet via SuiteTalk API.
• Implement data transformation logic within the iPaaS to ensure data compatibility and integrity between NetSuite and Quickbase.
• Collaborate with Quickbase admins to configure Quickbase connectors to create new contract records and attach PDF documents to the appropriate fields. o
• Implement delta detection mechanisms to ensure only new or updated contracts are synchronized.
• Develop error handling, logging, and notification mechanisms within the iPaaS. o Set up and manage integration schedules and triggers.

• Information Security:

• Implement and adhere to security best practices throughout the integration lifecycle, including secure handling of API credentials, encryption of data in transit (TLS/SSL), and appropriate data masking where necessary.
• Work with NetSuite and Quickbase administrators to ensure the principle of least privilege is applied to all integration user accounts and API access.

• Collaboration & Communication:

• Work closely with NetSuite Administrators to set up integration user roles, obtain API credentials, and ensure optimal data extraction from NetSuite.
• Collaborate with Quickbase Administrators to define the target application/table structure, configure API access, and validate data integrity.
• Communicate technical details, progress, and potential challenges clearly to both technical and non-technical stakeholders.

• Testing & Quality Assurance:

• Perform thorough unit, integration, and end-to-end testing.
• Support User Acceptance Testing (UAT) with stakeholders to ensure the integration meets functional and data accuracy requirements.

• Documentation:

• Create and maintain comprehensive technical documentation for the integration, including design documents, data maps, process flows, and troubleshooting guides.