Integration (PL-SQL/Java) Developer

The Preferred Supplier; Arnhem; On-site; EUR 45,000 - 60,000; Full time

Job summary

A global project logistics partner is looking for an Integration Developer with expertise in Talend and PL/SQL. This role involves developing and implementing interfaces, managing data exchanges, and supporting the application landscape within supply chain contexts. Applicants should have a Bachelor’s or Master’s in IT with 3-5 years of relevant experience. The position requires strong analytical skills and proficiency in SQL. Competitive compensation is offered for the successful candidate based in Arnhem.

Qualifications

• 3-5 years direct work experience of Integration activities in Talend and PL/SQL.
• Strong analytical, communication, and coding skills.
• Ability to document functional and technical aspects of software projects.

Responsibilities

• Develop and implement interfaces for the platform.
• Create processes workflow in Talend.
• Write SQL queries and create PL/SQL functions.

Skills

Json

FTP

HTTP

AS2 data exchange

EDIFACT and X12 supply chain messages

SQL

PL/SQL

Agile mindset

Good communication skills in English

Education

Bachelor’s or Master’s Degree in IT

Tools

SQL Developer

Toad

Job description

About the job Integration (PL-SQL/Java) Developer

Position Description

Job Title: Talend Integration Developer (Supply Chain)- IT
Summary:
X provides supply chain management services to customers in the retail, hospitality, cosmetic andtelecommunication industry amongst others. Working with project management teams called “ControlTowers”, X has offices in America, Canada, Hong Kong, Shanghai, India and The Netherlands.

Through a proprietary state of the art system, Control Towers connect project managers and suppliers toan agile network of warehouses around the globe. X coordinates project logistic activities on behalf ofthese customers to increase speed to market, lower overall non-merchandise supply chain costs andprovide end-to-end visibility over project activity.

We are the only global project logistics supply-chain partner for International brands, and we have strongexperience in managing the complexity of non-merchandise logistics e.g. furniture, fixture and equipment(FF&E). Additionally, we are experienced in managing supplier capabilities and opening large volumes ofmultiple projects simultaneously, domestically and internationally.

All our team members have or will develop extensive knowledge in forecasting, managing Furniture,Fixtures and Equipment (FF&E) orders, product movement, and delivery of FF&E materials to Internationalmarkets. We have a strong system and well-defined processes that serve as the basis for our extensivetraining, especially for entry-level team members.

The Software Developer is responsible for the technical aspects of X platform. He/she is responsiblefor developing and implementing interfaces and other components of X platform.

Essential Duties and Responsibilities

include, but not limited to, the following:

• Experience in Json, FTP, HTTP, AS2 data exchange
• Experience with EDIFACT and X12 supply chain messages
• Create processes workflow in Talend to load data from external file sources into databases and vice versa
• Constraints, Job Scheduling, Materialized Views
• Write SQL queries and create PL/SQL functions next to Json messages
• Provisioned in SQL, PL/SQL, Performance Views, Data Dictionary, inserts / updates / delete actions to external databases (example: MySQL / Oracle)
• Used PL/SQL Tables, Cursors to process vast volumes of data, and used bulk collect for a mass update as a performance improvement process
• Provide production support for Talend Application and connected landscape
• Follow best practices to document and track changes, synchronize development-UAT-
• Troubleshoot operational issue - Trace Data, logic, and report back on root cause
• Develop and provide support to system interfaces and coordinate with stakeholders to provide specifications for all core transactions and customer request
• Analyze and ensure an efficient transition of all technical design documents to provide support to the application landscape
• Monitor and recommend changes if required to provide stored procedures and design and develop various solutions for CICD
• Creates and maintains a perfect relationship with the customer
• Good communication skills in English
• Self-motivated, fast learner (Agile mindset)

Qualifications

Education and/or experience:

• Bachelor’s or Master’s Degree or equivalent education in IT field
• 3-5 years direct work experience of Integration activities in Talend and Pl/SQL
• Knowledge of SQL Developer/ Toad

Language Skills

Ability to document procedure manuals. Ability to document functional and technical aspects of software projectClear & consistent communications (both writing & speaking) in English.

Organizational Skills and Focus

Must be well organized, efficient, focused, and able to multi-task effectively.Has a strong affinity with Supply Chain and construction projects.

Reasoning Ability

Define problems, collect data, establish facts, and draw valid conclusions. This position requires strong analytical/logic, communication and coding skills. Must have the ability to develop and understand processes, flowcharts, and IT structures and systems.