Skill & Job Requirements: Oracle - L1 - ? Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc ? Ability to understand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques ? SQL Constructs Ablility to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views ? SQL Query Tuning Basics: Understanding of SQL Tuning concepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, Gathering Statistics Basics ? Adv SQL Basics: Able to understand and implement Datetime Functions, Advanced Subqueries, Hierarchical Queries,DDL & DML Extensions, Transaction Management ? Tools Level 1 usage ? Database Programming Basics: Ability to understand and implement Declaring Variables, Executable Statements, Control Structures, Composite Data Types, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggers ? Adv Database Programming: Ability to understand and implement Collections, Multilevel collections, Ref Cursors, Bulk Processing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects in PL./SQL

Skills: Development - Responsible for development, support, maintenance and implementation of small to medium non-complex components of a project module. Works on problems of limited scope, through usage of standard programming concepts and principles. Works under high supervision/ guidance with frequent review of accomplished objectives. Requires theoretical knowledge of programming languages. Expected to learn on the job towards developing domain knowledge along with technical/ proprietary skills.

We are the first PCMM Level 5 and SEI CMM Level 5 certified IT Services Company globally. We provide comprehensive IT solutions and services, including systems integration, information systems outsourcing, package implementation, software application development and maintenance, and research and development services to corporations globally.

In the Indian market, we are a leader in providing IT solutions and services for the corporate segment in India offering system integration, network integration, software solutions and IT services. presentjobs.com In the Asia Pacific and Middle East markets, we provide IT solutions and services for global corporations. We also have a profitable presence in the niche market segments of consumer products and lighting.