PL/SQL Tech Lead-L1(T82808)JobsCafe.com Experience:4 - 6 Years
Location:Chennai
Industry Type:IT-Software/ Software Services
Role:Team Lead/Tech Lead
Functional Area:Application Programming, Maintenance
Post your Resume in Shine for more Matching Jobs - Click here to Register Today!Desired Candidate ProfileQualification: BE / BTech
Experience : 4-6 YEARS
Skills: Technical Lead - Responsible for development, support, maintenance and implementation of a complex project module. Works on problems of complex scope, through extensive usage of standard concepts & principles. Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities. Requires extensive knowledge of at least one development technology/ programming language. Expected to continue to build upon domain knowledge and technical/ proprietary skills to reach levels of expertise, while adapting standard principles to new or changed conditions in day to day work. Has the ability to respond to detailed queries. Applies own judgment to independently determine a course of action, which is then executed independently post review. Responsible for coaching, guiding and mentoring junior members in the team to help them scale up faster.
Area of expertise: Data Warehousing
Job DescriptionRoles and Responsibilities: Oracle - L3, Unix/Windows - L2
Skill & Job Requirements: Oracle - L3 - ? 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 ? 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 ? Woking knowledge of DB Design/Modeling techniques(Logical and Physical DB modeling) ?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 & Mana
Keywords : PL / SQL Tech Lead - L1T82808
If you meet the above mentioned criteria, apply online
How To Apply- If you have not registered in Naukri.Com
Click here to Post Your FREE Resume
OR
If you have registered in naukri.com, click here
Wipro Tech Recruits IT Graduates