At least 4 to 8 years of Extensive hands on experience in PL/SQL programming, developing complex packages, Stored procedures, functions and implementing the best practices in PL/SQL programming
Ability to create and maintain complex queries & fine tune the existing complex queries to improve the performance
Ability to develop tech design from the functional specifications
Analysis and troubleshooting of the production issues
Strong analytical and technical ability with good communication and inter personal skillsStrong understanding of SQL (Structured Query Language) for writing complex queriesKnowledge of ER diagrams, table design, and relationships (primary/foreign keys)Ability to optimize PL/SQL code and SQL queries for better performance.Knowledge of cursors, loops, and exception handling in PL/SQL