Cloud Engineer

REGTECH INSIGHT PTE. LTD.; Singapore; On-site; SGD 75,000 - 95,000; Full time

Job summary

A technology consulting firm in Singapore is seeking an experienced SQL Developer to design, develop, and optimize SQLScript procedures in SAP HANA Cloud. The ideal candidate will have strong hands-on experience with SQL development and multi-container architectures, along with expertise in dynamic SQL and performance tuning. This role requires collaboration with various teams to support reporting and data ingestion needs. Opportunities for professional growth and project exposure are available.

Qualifications

• Strong hands-on experience with SAP HANA Cloud SQLScript.
• Experience with multi-container HANA Cloud architecture.
• Familiarity with JDBC-based data ingestion and SDA concepts.

Responsibilities

• Design, develop, and optimize SQLScript procedures in SAP HANA Cloud.
• Implement and maintain multi-container architecture.
• Develop complex dynamic SQL and parameterized procedures.
• Enable parallel execution of procedures for performance optimization.
• Manage cross-container access using grants, synonyms, and roles.
• Perform table partitioning and SQL performance tuning.

Skills

SQLScript procedures

Dynamic SQL

Procedural programming

Performance tuning

Data ingestion

Window functions

Multi-container architecture

SAP HANA Cloud

Tools

Business Application Studio

Hadoop

Job description

•Design, develop, and optimize SQLScript procedures in SAP HANA Cloud.

•Implement and maintain multi-container architecture (staging, target, procedures).

•Develop complex dynamic SQL and parameterized procedures.

•Enable parallel execution of procedures for performance optimization.

•Manage cross-container access using grants, synonyms, and roles.

•Perform table partitioning and SQL performance tuning.

•Support manual MTAR-based transport and environment synchronization.

•Collaborate with Datasphere and SAC teams to support reporting needs.

•Strong hands-on experience with SAP HANA Cloud SQLScript.

•Deep expertise in:

o Dynamic SQL

o Window functions

o Procedural programming

•Experience with multi-container HANA Cloud architecture.

•Familiarity with:

o JDBC-based data ingestion (e.g., Hadoop / non-SAP sources)

o SDA concepts (DP Agent, virtual tables – conceptual)

•Experience working in Business Application Studio (BAS).