Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Bhubaneswar |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | IT - Software |
Functional Area | General / Other Software |
EmploymentType | Full-time |
We are looking for Oracle PL/SQL Developer for one of our Top Most MNC clients. Exp: 5+ yrs. Work Location: Bhubaneswar SEZ Position : C2H Opportunity. Skills needed: Detailed job description - Skill Set: 5+ Years of experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) & Oracle Spatial. Expertise in Client-Server application development using Oracle 12c/11g, PL/SQL, Oracle SQL Developer and SQL*LOADER. Experience developing complex Database objects to be invoked from .Net / Java based applications or Web services. Experience in Oracle supplied packages, Dynamic SQL, Collections, Exception handling, Records and PL/SQL Tables. Must have experience of Data loading into Oracle Tables using SQL Loader. Experience in SQL performance tuning using Cost-Based Optimization (CBO). Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques. Strong knowledge of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. Strong experience in Data warehouse concepts and at least one ETL tool. Experience in FME ETL tool is an advantage. Good knowledge on logical and physical Data Modelling using normalizing Techniques, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) Developed materialized views for data replication in distributed environments. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team. Mandatory Skills PL/SQL, Oracle 12c, 11g, Performance Tuning Good to Have Skills Experience in Utilities Industry, especially Electrical Transmission and Distribution is preferred. Experience of partitioning large Tables using range partition technique. Pl Note : Candidates with Immediate/ short NP preferred as it is a critical demand. Interested candidates please share your CV to soubhagyalaxmi.b@uftech.com ,
Keyskills :
sqlsqlserverssisssrsdatabaseadministrationdatamodelingclientserverclesqldeveloperclientserverapplicationdevelopmentetltooldataflowaclesqlaclerdbmsexplainplandataloadingflow