Naufiya V S

Seeking a challenging position in Information Technology to achieve a high degree of professional experience and capability by drawing the best out of my experience and channelize it towards excellence in order to successfully contribute to the organization I associate with.

Having 8+ years of experience as an oracle PLSQL Developer. Expertise in Database development using Oracle .Expertise in Performance Tuning and DB Health Check. Extensive experience in writing stored Procedures, Functions, Packages, Cursor, Trigger and Macro using PL/SQL. Experience in using different types of Exception handling to handle PL/SQL errors. Writing SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database. Creating Database Objects like Tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements. Applying Constraints, Indexes to maintain Data Integrity while defining objects. Experience in automation process in SQL scheduler. Experience in shell scripting and Cronjob automation using Linux. Have Experience in working with CDC in KAFKA, KSQL for real-time streaming. Experience in Data warehousing concepts, Data analysis and Design. Hands-on experience in Oracle Data Integrator. Working experience with Designer, operator, Topology navigator in ODI. Carried out common tasks in ODI like developing interfaces, variable, procedures, packages, scenarios and Load plans.