PL/SQL Developer

Skills:

• Around 10 Years of database development experience and should have min 5+ years of relevant experience

• Strong SQL & PLSQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.

• Expertise in using Oracle Performance tuning concepts with Oracle hints and EXPLAIN PLAN tool

• Strong experience using SQL and PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables, Native dynamic SQL, bulk binding techniques and

Packages/Procedures/Functions wherever applicable to process data in an efficient manner

• Fulltime client onsite role & support

• Working days – Aligned to Bank working days & Holiday calendar (1st Saturday, 3rd Saturday, 5th Saturday are working days)

• Strong understanding of Data Warehousing and Extraction Transformation Loading (ETL)

• Sound understanding of RDBMS (Oracle)

• Should have used Oracle SQL Loader/External File Utilities to load files

• Strong understanding in XML concepts, UTL file and all inbuilt packages in oracle

• Actively participate with technical delivery teams and contribute to code reviews, architecture reviews, and design discussions

• Implement, maintain, and support development processes and methodologies

• Oversee, maintain, and support the production, staging, and testing environments

• Perform root cause analysis for recurring issues and contribute to continuous improvement.

• Act as a liaison between application teams, IT teams and Business Teams for smooth day-to-day operations.