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.
0 Comments
Leave a Reply. |