PLSQL Developer

Oracle PLSQL & ETL developer - Oracle (Sql and Plsql), ETL (Pentaho) with mandatory Banking domain knowledge & experience
Location:
Job Description
†Looking for 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
• 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