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 & supportWorking 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 filesStrong understanding in XML concepts, UTL file and all inbuilt packages in oracleActively participate with technical delivery teams and contribute to code reviews, architecture reviews, and design discussionsImplement, maintain, and support development processes and methodologiesOversee, maintain, and support the production, staging, and testing environmentsPerform 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.