Specialist - Package Implementation - Oracle PLSQL Database Developer

As a Mantas Scenario Developer with experience in Mantas OFSAA FCCM, your role will involve using scenario manager to develop or customize out-of-the-box scenarios, designing and developing load processes for SQL and queries for large databases with high transaction volume. Additionally, you will be responsible for problem-solving, debugging, effective communication, and teamwork. You are expected to design high-quality deliverables adhering to business requirements with defined standards, develop and maintain highly scalable, high-performance ETL applications, integrate the code adhering to CI/CD using Maven and Udeploy, review code modules developed by other juniors, analyze existing codes to resolve production issues, and possess good hands-on knowledge in ETL development tools, data warehousing, SQL, query tuning, performance tuning, Agile development model, and scrum teams. Key Responsibilities: - Experience with Mantas OFSAA FCCM - Use scenario manager to develop or customize out-of-the-box scenarios - Strong knowledge of Oracle DB and PLSQL - Design and develop load processes for SQL and queries for large DBs with high transaction volume - Strong problem-solving and debugging skills - Good communication and ability to work in a team - Design high-quality deliverables adhering to business requirements with defined standards and design principles patterns - Develop and maintain highly scalable, high-performance ETL applications - Develop and integrate the code adhering to CI/CD using Maven and Udeploy - Work with a team that might be geographically distributed and review code modules developed by other juniors - Analyze existing codes to resolve production issues - Good hands-on knowledge in ETL Development tool - Good knowledge of data warehousing - Good SQL knowledge and query tuning - Performance tuning - Work experience in Agile development model and prior experience of working in scrum team - Banking domain knowledge is preferable - Design experience in ETL technology Qualifications Required: - Mandatory Certification Oracle Database PLSQL Developer Certified Professional - Experience in Agile Methodology - Good to have: PL SQL, Data warehousing fundamentals, and concepts,