6+ years of experience in Analysis, Design, Modeling, Development, Implementation, Support and Testing of Data Warehousing applications * Deep understanding of Software Development Life Cycle (SDLC) methodology - Waterfall, AGILE and project management principles. * Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using Data Modeling tool Erwin. * Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. * Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. * Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. * Good knowledge on logical and physical Data Modeling using normalizing Techniques. * Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). * Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. * 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 in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. * Loaded Data into Oracle Tables using SQL Loader. * Partitioned large Tables using range partition technique. * Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE. * Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. * Worked extensively on Ref Cursor, External Tables and Collections. * Expertise in Dynamic SQL, Collections and Exception handling. * 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. * Experience in Performance tuning the SQL queries. * Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart. * Hands on experience with Tableau reporting tool. * Experience on Multi Dimensional Modeling. * Extensive Experience of working in UNIX/ Linux environment. * Experience in writing shell and perl scripting. * Knowledge in python.
Description
