Strong development experience in Oracle PL-SQL and advanced PL/SQL including Procedures,
Packages, Functions, Indexes, Collections, Materialized views,
Triggers, Bulk Binding, Exception handling etc
Excellent in writing complex SQL Queries and improving the performance of existing queries.
Involved in development with all stages of System Development Life Cycle (SDLC)
Design, analysis, coding, testing & support.
Good experience in Creating Tables, Constraints, Indexes, Triggers, Cursors, Ref Cursors, anonymous blocks, sequences, extract data from flat files.
Experience in Database architecture and design
Experience in Performance tuning, Data Modelling and Data Analysis and should able to perform query optimization & database tuning using different tools.
Good working experience on Use Collections, Bulk Binding, Materialized Views, Packages and Dynamic SQL, and participated in creating Design documents
Applied Tuning and Optimization, Normalization in the database design
Wrote Audit programs for data consistency check and validation
Knowledge of DW data population techniques (ETL/ELT) for target structures such as Star Schemas, Snowflake Schemas and 1-3NF data models. This includes error/suspension handling, control processing, data cleansing, and performance design.Good to have:Experience in implementing real time data integration solutions