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.