Application Developer

DescriptionPL/SQL Developer - Oracle, SQL TuningOur TeamWe work for one of the largest multi-national banks (Client) with presence across the globe. We work on Supply Chain Finance domain and is one of the industry leading solution for the Client. We are responsible for the enhancements to the existing platform to cater to the growing business needs based on industry trends, either functionally or technically. The solution implemented is a global application spanning across 3 regions and 20+ countries with a single code base, with multi-lingual support. Looking for Oracle PL/SQL developers who would be responsible for:Understanding the requirements from the Functional TeamEstimating the development effortsDeveloping the functionalities based on Agile/ Water-Scrum-Fall modelEnsuring the queries written are optimized to handle performance and volume.Assisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing. Your OpportunityYou will be responsible for applying your extensive hands-on knowledge of Oracle SQL,  PL/SQL features to develop functional requirements. You would be responsible for the entire development life cycle viz., development till production implementation.Your QualificationsAny Computer Science based graduation4+ years in software developmentExcellent hands-on coding and design skills in Oracle SQL, PL/SQL with exposure to analytical functions and data modelling.Expertise in Query fine-tuning to ensure optimized executionExperience in Banking DomainKnowledge of UNIX is an added advantageOur Ideal CandidatePreferably from Banking domain Hands-on development experience in writing Oracle queries, stored procedures, packages that are fine-tuning to be of good performance and handle high volume. Aspire to learn new tools as per the project needExposure to Agile methodologiesYour ResponsibilitiesAs an integral part of the development team you will be responsible for the following –Understand the business requirements from the functional teamEstimate the development efforts for the assigned functions.Develop the functionalities based on Agile/ Water-Scrum-Fall modelWrite optimized Queries or Packages that can handle high volume and performancePerform peer-review of code written by other developersAssisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing.Additionally, contribute to the upliftment of existing design/ code for alternates that can help in flexibility and scalability.Filtration criteria:4+ years of experience in Oracle SQL, PL/SQL developmentPure development experience to be considered (to avoid support expertise where the requirement is more monotonous)Experience in Query fine-tuning (not database tuning) for writing optimized code.Screening Criteria Questionnaire How do you rate yourself in Oracle programming?6 & above/10 is good YesExplain PlanCheck for the execution where the cost is higherYes, I have used it. I have good exposure in using and contributing to it.Stored Procedures, Packages, Triggers, Functions, Complex Queries using joins from multiple tablesFunction can be called within a query whereas Procedure cannot be called within a query.Know the fundamentals of data modelling (tables, views, data types, index, etc.,)YesDo you have expertise in SQL tuning in your projects?What tool you use for SQL tuning?What do you check for in Explain Plan?Do you have hands-on development experience?What all objects you have created in Oracle?What is the difference between Procedure and Function?Experience in data modelling?Experience in Banking domainCareer Level - IC2ResponsibilitiesCovered under Job DescriptionQualificationsCareer Level - IC2