Reports Developer

Job Description
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

Additional Information
GOOD COMMUNICATION SKILLS

DURATION: 4-6 Months

INTERVIEW: PHONE & SKYPE