Oracle PL/SQL Developer

Should be hands on and able to successfully deliver on time without defects. Ability to analyze, design and support implementation of Oracle PL/SQL, Views, create/modify database tables based on business requirements and specifications Responsibilities Responsible to develop/modify PL/SQL, SQL Views in Oracle Responsible to create a new tables/modify existing table structure. Performance tuning and good understanding of explain plan Normalization, renormalization and star schema Develops stored procedures, database triggers and SQL queries Must be able to work independently with minimum supervision. Responsible to develop test cases and perform unit testing. Must be able to interact and co-ordinate with distributed team. Must be good in communication skills. Responsible to provide regular task status update to the management Required Skills Strong in Oracle version 11.x & above Experience in Procedures, Functions, Packages, views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections, objects and writing complex queries Any version control tool (SVN/Bitbucket) Desired Skills Informatica, Autosys Unix Concepts Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins) Agile best practices