Industry: Professional, Scientific & Technical Services•
Not Specified years
Posted 47 days ago
Primary Skills: Databases: Oracle, MySQL Programming Languages: SQL, PL/SQL, UNIX Shell Scripting Oracle Tools: Reports Builder 6i/9i/10g, Forms Builder 6i/9i/10g/11g, MARS Tableau Desktop , Tableau Server Job Description: Proficient in database modelling, Data extraction and storage logic building, Convert the business requirement into technical solutions Proficient in writing Stored Procedures, Functions, Packages and Triggers using PL/SQL Proficient in Oracle Database design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships
Expertise in using Oracle PL/SQL Collections, Bulking techniques, Analytical Functions, Hierarchical Queries, Partition utilization to increase performance Automating data loading, extraction, reports generation using UNIX Shell scripting Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server Proficient in creating reports using Reports Builder (10g/9i/6i)
Good knowledge of Oracle performance related features such as Query Optimizer, Execution Plans & Indexes Experience in using Tableau functionalities for creating different Requests, Filters, Charts, inbuilt Functions, Interactive dashboards with Page and dashboard Prompts Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects. Ability to drive/recommend design changes with respect to Tableau dashboard.
Utilized various Oracle Utilities like UTL_FILE, SQL*LOADER, BULK Techniques, EXTERNAL TABLES for efficient data migration Created Shell Scripts for invoking SQL scripts and scheduled using AUTOSYS Excellent communication skills.