Description

Design, develop, and maintain Oracle database objects, APEX applications, and data warehouse solutions.

This role is hybrid.

Responsibilities

• Develop and maintain Oracle database objects, including packages, stored procedures, functions, triggers, views, and tables.
• Design and build Oracle APEX forms and applications to support business reporting and operational workflows.
• Architect and implement data warehouse solutions using dimensional modelling, star/snowflake schemas, and SCD strategies.
• Design, build, and optimize ETL pipelines for large-scale data integration and push data into the Enterprise Data Platform.
• Schedule and monitor batch jobs using Control-M, and automate workflows using shell scripts.

Required Skills

• 6+ years of hands-on Oracle PL/SQL development in an enterprise environment.
• Deep proficiency in Oracle APEX for designing and maintaining applications.
• Strong knowledge of Data Warehouse concepts, including dimensional modelling and data mart design.
• Proven experience in ETL development and pipeline optimization.
• Mandatory shell scripting skills for automation and operational workflows.
• Hands-on experience with Control-M or equivalent job scheduling tools.
• Experience with Git for branching, merging, tagging, and release management.
• Ability to perform unit, integration, and regression testing, including pre-production dry runs.

Preferred Skills

• Familiarity with Enterprise Data Platforms or equivalent data lake/warehouse environments.
• Experience monitoring PnL data flows and performing root cause analysis on breaks and anomalies.
• Strong analytical skills with the ability to translate business requirements into technical solutions.

Key Skills

Education

Bachelor’s degree