Experience in all major versions of technology stack including Database, Forms, Reports, PL/SQL.Expert in Developing SSIS (SQL Server Integration Services) Packages Extracting, Transforming and Loading (ETL) data into teh Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.Expertise in Optimizing Database performance, Hints, Indexing, Materialized View, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users.Strong development and support noledge on Oracle, SQL, PL/SQL,T-SQL queries programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views.Experienced in writing SQL queries and SQL tuning, understanding requirements, writing functional specs, writing test specs and plans.Practical understanding of theData modeling(Dimensional & Relational)concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.Worked extensively on Erwin and ER Studio in bothOLAP and OLTPapplications.Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.Perform XML operations for data extracts, data retrieval and data storage.Experienced in writing SQL statements, PL/SQL code for teh database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.9+ years of Experience working wif Oracle 11g/10g/9i, Toad, SQL*plus, SQL * developer, SQL*loader, MS SQL Server and Business Intelligence products.

Toad for oracle xpert edition price