ETL Specialist

2 weeks ago

India Moksh Tech Full time
Job Description

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 organizations 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. o
- 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. o
- 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. o
- Develop data mapping specifications from NetSuite fields to Quickbase fields, including handling of PDF document attachments.
- iPaaS Development & Implementation: o
- Build, configure, and test the integration workflows within the chosen iPaaS platform. O
- 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. o
- Implement data transformation logic within the iPaaS to ensure data compatibility and integrity between NetSuite and Quickbase. o
- 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. o
- Develop error handling, logging, and notification mechanisms within the iPaaS. o Set up and manage integration schedules and triggers.
- Information Security: o
- 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. o
- 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: o
- Work closely with NetSuite Administrators to set up integration user roles, obtain API credentials, and ensure optimal data extraction from NetSuite. o
- Collaborate with Quickbase Administrators to define the target application/table structure, configure API access, and validate data integrity. o
- Communicate technical details, progress, and potential challenges clearly to both technical and non-technical stakeholders.
- Testing & Quality Assurance: o
- Perform thorough unit, integration, and end-to-end testing. o
- Support User Acceptance Testing (UAT) with stakeholders to ensure the integration meets functional and data accuracy requirements.
- Documentation: o
- Create and maintain comprehensive technical documentation for the integration, including design documents, data maps, process flows, and troubleshooting guides.

  • Transform Business Data with Precision

    21 hours ago

    India beBeeDataIntegration Full time ₹ 12,00,000 - ₹ 16,00,000

    ETL Data Integration SpecialistWe are seeking a highly skilled ETL data integration specialist to join our team. The ideal candidate will have expertise in designing and optimizing complex ETL pipelines using Talend Open Studio, BigQuery, PostgreSQL, Python, and GCP.Talend Data Integration: Develop and implement efficient ETL processes, ensuring data...

  • ETL Data Integrity Specialist

    1 day ago

    India beBeeData Full time ₹ 18,00,000 - ₹ 24,00,000

    As a key player in our organization's data infrastructure, you will be responsible for ensuring the seamless transfer of data between various systems.Key Responsibilities:You will design and execute comprehensive test plans for ETL processesIdentify and report defects in ETL code, working closely with cross-functional teams to resolve issuesDevelop and...

  • Expert ETL Database Specialist

    1 day ago

    India beBeeDatabase Full time ₹ 20,00,000 - ₹ 25,00,000

    Database Engineer JobThis role is a great opportunity to showcase your technical skills as an ETL Database Engineer.Experience with RDBMS such as MySQL, Oracle SQL and proficiency in SSIS (SQL Server Integration Services) is required.Key responsibilities include:Designing, developing and maintaining database systemsCollaborating with cross-functional teams...

  • Senior Data Integration Specialist

    13 hours ago

    India beBeeDataIntegration Full time US$ 90,000 - US$ 1,20,000

    Are you looking for a challenging opportunity to utilize your ETL development skills? Our organization seeks a highly skilled Data Integration Specialist to join our team in Chennai. This role requires proficiency in T-SQL, Azure Data Factory (ADF), and SSIS, along with excellent problem-solving and communication skills.Key ResponsibilitiesDesign and develop...

  • Informatica Data Integration Specialist

    1 day ago

    India beBeeInformatica Full time US$ 90,000 - US$ 1,20,000

    Job Title: Informatica Data Integration SpecialistWe are seeking an experienced data integration professional to join our team. The successful candidate will be responsible for designing, developing, and maintaining large-scale data integration solutions using Informatica PowerCenter / IICS.Key Responsibilities:Develop and enhance Informatica mappings,...

  • Migrating Legacy Data Specialist

    1 day ago

    India beBeeDataMigration Full time ₹ 9,00,000 - ₹ 12,00,000

    Streamlining Data MigrationA career as a data migration specialist offers an exciting opportunity to leverage technical skills in conjunction with AI coding assistants to create high-quality methods of moving clients from legacy platforms to a modern platform.This role involves migrating older generation data models to a Snowflake-style architecture at...

  • Senior Data Validation Specialist

    1 day ago

    India beBeeQuality Full time ₹ 18,00,000 - ₹ 22,00,000

    Job Description:We are seeking an experienced and skilled Quality Assurance Lead to join our team. The ideal candidate will have a strong background in data validation and analysis, with hands-on experience in ETL workflows and Data Warehousing concepts.Key Responsibilities:Lead and support testing efforts for ETL processes, Data Warehousing, and Data...

  • Data Integrity Specialist

    4 days ago

    India beBeeEtlTester Full time ₹ 72,00,000 - ₹ 84,00,000

    At the forefront of data accuracy and integrity, we seek a skilled Etl Tester to spearhead our mission. In this pivotal role, you will be responsible for guaranteeing the precision and reliability of our payment domain.Key Responsibilities:Design and implement comprehensive testing strategies for ETL processes to ensure seamless data flow.Collaborate with...

  • Data Transformation Specialist

    1 day ago

    India beBeeSyniti Full time ₹ 1,50,00,000 - ₹ 2,00,00,000

    Business Intelligence Expert OpportunityWe are seeking an experienced business intelligence expert to join our team. The ideal candidate will have a strong background in data harmonization, cleansing, and ETL activities.Key Responsibilities:Expertise in data extraction using SynitiFamiliarity with data harmonization, cleansing, and ETL processesKnowledge of...

  • Senior Data Integration Specialist

    40 minutes ago

    India beBeeInformatician Full time ₹ 1,50,00,000 - ₹ 2,00,00,000

    Job DescriptionRole Summary: Experienced professionals in data integration and operations are sought to develop ETL solutions, support critical activities, and optimize business applications.The candidate will be responsible for developing and maintaining ETL processes, ensuring timely data loads and reconciliations, monitoring system performance, and...