PL-SQL and SQL Developer

The PL-SQL Developer will work on the development of custom Data Migrations, Data analysis/profiling, Integration interface, Data Remediation scripts and Reports.

Responsibilities

  • Learn about the client’s business challenges and technologies to understand their business needs
  • Analyzing the clients’ requirements and building a technical design
  • Develop client custom integrations and migrations
  • Develop required custom calculation Jobs
  • Monitor and perform regular auditing of all datasets to ensure data integrity
  • Develop Data Fixes or Data remediation patches
  • Responsible for the development of custom/product reports
  • Work closely with the business analysis, quality assurance and development to ensure a quality and comprehensive delivery
  • Performance analysis and tuning of already written procedures/queries
  • Support the overall migration, integration and reporting testing/acceptance plan with the client
  • Support the internal development and testing scenarios, volume testing and test automation related to integrations and reporting
  • Maintain an up-to-date knowledge of FADEL systems and products
  • Improve data migration / integration mechanisms into and out of IPM
  • Might be requested to travel to EU or USA for Client Projects. Trips may be 4-5 weeks in duration.

Location

Beirut, Lebanon

Desired Skills and Experience

  • Bachelor’s degree in Computer Science, Information Systems, or another related field
  • Advanced level skills in Oracle SQL and PL/SQL
  • 4-5 years’ experience of Database programing using PL/SQL for complex implementations
  • Experience in SQL Tuning and Optimization
  • Experience in Reports Development
  • Should demonstrate strong design skills, communication, and documentation skills
  • Should demonstrate strong analytical skills and business-oriented thinking
  • Ability to work under stress and tight schedules
  • Fluency in English is a must
  • Fluency in French is a plus
  • Experience using ETL tools such as Informatica, Talend is a plus
  • Experience in Oracle EBS AP, AR and GL and their integration API is a plus
  • Experience in JasperSoft report development is a Plus
  • Experience developing or working with test automation
  • Experience supervising and mentoring junior developers as needed