PLSQL Development - Technical Lead

Oracle PLSQL & ETL developer - Oracle (SQL and PLSQL),ETL (Pentaho).

Preferred: Banking domain knowledge & experience

10+ Years of database development experience and should have min 6+ 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

• 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

• Good to have experience in cloud AWS

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

• Develop and maintain high-performance, scalable, and robust applications

• 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

• Develop and maintain consistent documentation practices and standards