Reports Developer

Open 62d

Description:

This position develops, tests, executes and documents database SQL programs for use in supporting disease management applications utilizing both Oracle and MS SQL technologies.
Development of custom reports and working with App Support team on a data cleanup project.
MS Access and Crystal Report experience is a must.
Delivery of documentation is required at end of the contract period.

Responsibilities:

Develop Packages, Stored Procedures, Triggers, and other PL/SQL and T-SQL programs.
Develop custom reports using Crystal Reports, Cognos, or Business Objects
Develop UNIX scripts to support batch processes or data conversion.
Optimize Queries, Stored Procedures, ETL process, and databases performance.
Gather and analyze business requirements for Data warehouse and Business Intelligence Projects.
Provide quality oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
Write user documentation for database systems created and/or maintained by the department.

Requirements:

Minimum of seven (7) years' Oracle, MS SQL, Data warehouse design and development experience required
Experience in designing and developing high volume transaction based systems required
Experience in SQL, SQL*Plus, SQL*Loader, Exp/Imp, Oracle scheduler, Advanced Queues, Object management, Informatica Power Center, PL/SQL development, stored procedures, and triggers required
Proficient in Toad, MS Access, Erwin, Visio, and Version Control tools required
Experience using bulk processing, DBMS packages required
Experience in analyzing query plans and query tuning, partitioning, and optimizer hints required
Experience in Data warehouse and Business Intelligence implementation required
Intermediate computer skills and proficiency in MS Word, Excel, PowerPoint and Outlook required

GOOD COMMUNICATION SKILLS

DURATION: 4-6 Months

INTERVIEW: PHONE & SKYPE

Show

See also