Kamayi is hiring a Senior Oracle PL/SQL & Data Integration Engineer in Dubai.
Responsibilities
- Design and build enterprise-grade database solutions and comprehensive reporting solutions
- Create and manage stored procedures, functions, triggers, and packages using Oracle PL/SQL
- Build and optimise data models and schema designs
- Design, develop, and maintain data integration and data warehouse solutions
- Perform data transformation, cleansing, and enrichment activities
- Support the development and maintenance of ETL workflows and data flows
- Conduct performance tuning of SQL queries, stored procedures, and data flows
- Perform in-depth data analysis across large datasets and build reports and dashboards
- Validate data integrity and accuracy throughout the data lifecycle
- Collaborate with technology and business teams and contribute to documentation and data dictionaries
Requirements
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a closely related discipline
- 5 to 7 years of hands-on professional experience in Oracle PL/SQL development and data integration engineering
- Strong skills in writing, optimising, and debugging complex SQL queries and stored procedures in production environments
- Demonstrated experience in bulk data processing using advanced SQL and PL/SQL techniques including BULK COLLECT, FORALL, and exception handling
- Proficiency in data modelling and schema design
- Expertise in gathering and analysing data integration requirements
- Excellent communication and collaboration skills
- Experience in the airlines or aviation domain is preferred; hands-on experience with Amazon Redshift, Hadoop, Hive, Spark, and AWS cloud services is preferred
Salary
Salary: 10000 – 13000 AED per month.