Skills: Oracle PLSQL & ETL developer - with mandatory Banking domain knowledge & experience
Job Description:
• 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.