Pl/Sql Developer / Data Analyst

:

Candidate should have atleast 12+ Years of Experience as PLSQL / Data

Analyst..

ØAnalyzing, testing, debugging and repairing existing PL/SQL based applications.

ØAnalyzing new business rules and interfaces in order to design and implement new Oracle objects.

ØPreparing and maintaining documentation on new and existing data models.

ØPreparing and maintaining documentation for new and existing programming objects.

ØPackaging and configuring Oracle object components for deployment across Development, Test and Production Database Environments.

ØWorking with Architects and Oracle DBA staff to establish standards for developing and deploying Oracle objects.

ØAssisting Business Intelligence staff with reporting requirements and solutions.

ØCollaborating with stakeholders across different business units to align data initiatives with business strategies.

ØEvaluating and enhancing SQL performance.

ØPreparing regular and ad hoc reports, including:

ØWeekly project report of progress and status,

ØWeekly time report, and Additional reports as requested.

ØBreak down complex programming concepts into organized and concise units.

ØWork in an agile, self-motivated environment with multiple, concurrent priorities.

ØAn understanding of relational data concepts and the ability to apply these concepts to concrete solutions.

ØDevelopment skills with Oracle PL/SQL (Packages, Functions, Procedures, triggers), Materialized Views, DBLinks, and Oracle Jobs.

ØStrong analytical skills for evaluating, documenting, and enhancing existing and new data models.

ØExperience with: (1) Reverse Engineering and Refactoring PL/SQL code, Extraction, Transform and Load programming,Data Warehouse/ Data Mart design,Asynchronous event-driven applications.

ØKnowledge of the following:

(1) BI Publisher,

(2) Java syntax,

(3) SQL Server Reporting Services (SSRS),

(4) XML syntax and parsing,

(5) Domain knowledge of court related concepts and business activities.