PL-SQL and SQL Developer
The PL-SQL Developer will work on the development of custom Data Migrations, Data analysis/profiling,
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