Virtusa

Oracle Pl sql

Posted On

March 21, 2024

Location

Hyderabad, Telangana

Experience Level

Full Time

Job Type

Experienced

Apply By

Sept. 30, 2024

Job Description

Experience in Analysis, Design and Implementation.
Oracle SQL, PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle 9i, 10g, 11g and 12c Relational Database Management System (RDBMS)
Good knowledge of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
Good knowledge of logical and physical Data Modeling using normalizing Techniques.
Good knowledge of Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Good knowledge of Complex database objects like Stored Procedures, Functions, Packages, Cursors and Triggers using SQL and PL/SQL (Conversion, Aggregate, Numeric, Character, General)
Performance tuning.
Good understanding of Joins (Outer, Left / Right Outer Join, Self, Inner, Cross Join).
Handling errors with Exceptions.
Hands on nested Subqueries, Dual Table.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Good command on UNIX commands (grep,scp, sort, crontab, mail)
User Administration commands (useradd, usermod, userdel, passwd, groupadd, groupmod, chown, chgrp )
Good understanding of shell scripts for invoking SQL scripts.
Map , TypeTree, MDQ, Resource registry, Connectivity with multiple source / target systems (Text File, CSV, XML, Database etc.), Debuging in case of any issue.
Knowledge of Jira, Confluence and Agile methodologies, Sprint , Story Points, Task Estimations during sprint planning.
Should have good communication skills,
Should be vigilant to identify the issues/risks well in advance.

Jobs at Hyderabad

Oracle

Senior Principal Consultant

Professional

Hyderabad, Telangana

Oracle Pl sql Apply Now

Job Description

Jobs at Hyderabad

More Jobs at Virtusa

Actively Recruiting Companies at Hyderabad, Telangana

Oracle Pl sql