Integration Engineer — SQL & API Automation

Red Ember Recruitment (PTY) Ltd; Irene; On-site; ZAR 420,000 - 650,000; Full time

Job summary

Red Ember Recruitment (PTY) Ltd in Irene, SA, seeks an Integration Developer to design, develop, and support custom integrations between Sage 300 People and external systems. The role focuses on automation, data accuracy, and seamless data exchange using SQL Server, REST APIs, and ETL processes.

The developer will handle project-based work and ongoing production support, growing into a specialist in integrations with strong SQL skills and exposure to HR systems.

Qualifications

• Design and develop custom integrations between Sage300 People and external systems.
• Proficient in SQL Server, REST APIs, and ETL concepts with data modelling.
• Experience with Postman or similar API testing tools is preferred.
• Strong problem solving and data integrity focus for production integrations.
• Ability to document mappings, interfaces, and deployment steps.
• Exposure to C#, .NET or scripting languages is advantageous.

Responsibilities

• Design and develop custom integrations between Sage 300 People and external systems using SQL Server and REST APIs.
• Define data models, mappings, transformation logic, and process interfaces between systems.
• Develop, test, and deploy integration solutions across development, testing, and production environments.
• Implement ETL processes to extract, transform, and load data between systems.
• Ensure integration processes are reliable, efficient, and scalable.
• Provide Level 1 and Level 2 support for deployed integrations.
• Monitor integration processes and resolve data discrepancies.
• Maintain and enhance existing integrations as business requirements evolve.
• Communicate progress, risks, and issues to stakeholders.
• Create and maintain technical documentation and deployment procedures.

Skills

Microsoft SQL Server

REST APIs

ETL processes

Postman

Hoppscotch

C#

.NET

Scripting languages

Data integration

Data modelling

Education

Diploma or Bachelor’s degree in Computer Science, Informatics, Engineering, or related field

Tools

SQL Server Management Studio

JSON/XML data formats

Job description

Red Ember Recruitment (PTY) Ltd in Irene, SA, seeks an Integration Developer to design, develop, and support custom integrations between Sage 300 People and external systems. The role focuses on automation, data accuracy, and seamless data exchange using SQL Server, REST APIs, and ETL processes.

The developer will handle project-based work and ongoing production support, growing into a specialist in integrations with strong SQL skills and exposure to HR systems.