System Integrator

Roketin - PT Roketin Kreatif Teknologi; Sumur Bandung; On-site; IDR 200,880,000 - 379,440,000; Full time

Job summary

Roketin - PT Roketin Kreatif Teknologi is seeking a System Integrator to design, build, and maintain robust data integrations, ETL pipelines, and API connections across enterprise systems.

You will ensure data quality and security, support batch and real-time processing, and enable reliable data flow and system interoperability across environments.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Minimum 3 years of experience in Data Engineering, ETL Development, or Backend Development.
• Proficiency in Advanced SQL and data modeling (star/snowflake).
• Hands-on experience with ETL tools (Pentaho, Sling) and API development (.Net/C#, PHP/Laravel, or Java).
• Familiarity with RDBMS (PostgreSQL, MySQL, SQL Server); exposure to NoSQL, Data Warehouse, or Data Lake is a plus.
• Strong understanding of data security (encryption, access control) and governance principles.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• ETL & Data Pipeline Management: Design, develop, and maintain robust ETL/ELT processes using tools like Pentaho or Sling, ensuring efficient batch and real-time data processing across heterogeneous systems.
• API Development & Integration: Build and manage secure APIs (using .Net, PHP, or Java) with proper authentication (JWT/OAuth2) and documentation (Swagger/OpenAPI) to enable seamless system connectivity and data exchange.
• Data Governance & Security: Enforce data quality standards through validation, cleansing, and harmonization while implementing security measures such as encryption, access control, and compliance with data governance policies.
• Monitoring & Documentation: Monitor integration performance and pipeline health, troubleshoot issues promptly, and maintain comprehensive technical documentation and work reports for knowledge continuity.

Skills

Advanced SQL

Data Modeling

ETL/ELT Pipeline

Data Integration

API Development

Data Governance

Data Security

Troubleshooting

Technical Documentation

RDBMS

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Pentaho

Sling

.NET/C#

PHP/Laravel

Java

Swagger/OpenAPI

Job description

Job Requirements

System Integrator responsible for designing, building, and maintaining seamless data integrations, ETL pipelines, and API connections across enterprise systems. Ensures data quality, security, and governance while supporting both batch and real-time processing needs to enable reliable data flow and system interoperability.

Key Responsibilities

• ETL & Data Pipeline Management: Design, develop, and maintain robust ETL/ELT processes using tools like Pentaho or Sling, ensuring efficient batch and real-time data processing across heterogeneous systems.
• API Development & Integration: Build and manage secure APIs (using .Net, PHP, or Java) with proper authentication (JWT/OAuth2) and documentation (Swagger/OpenAPI) to enable seamless system connectivity and data exchange.
• Data Governance & Security: Enforce data quality standards through validation, cleansing, and harmonization while implementing security measures such as encryption, access control, and compliance with data governance policies.
• Monitoring & Documentation: Monitor integration performance and pipeline health, troubleshoot issues promptly, and maintain comprehensive technical documentation and work reports for knowledge continuity.

Qualifications

• Bachelor's degree (S1) in Computer Science, Information Systems, or related field.
• Minimum 3 years of experience in Data Engineering, ETL Development, or Backend Development.
• Mandatory proficiency in Advanced SQL and data modeling (star/snowflake schema).
• Hands‑on experience with ETL tools (Pentaho, Sling) and API development (.Net/C#, PHP/Laravel, or Java).
• Familiarity with RDBMS (PostgreSQL, MySQL, SQL Server); exposure to NoSQL, Data Warehouse, or Data Lake is a plus.
• Strong understanding of data security (encryption, access control) and governance principles.
• Excellent analytical, problem‑solving, and communication skills with the ability to work independently or collaboratively in a team.

Requirements

• Advanced SQL
• ETL/ELT Pipeline
• Data Integration
• API Development (.Net/PHP/Java)
• Data Modeling
• RDBMS (PostgreSQL/MySQL/SQL Server)
• Data Governance
• Data Security (JWT/OAuth2)
• Troubleshooting
• Technical Documentation
• Pentaho/Sling (Plus)
• Data Warehouse/Lake (Plus)