Reports Developer(IL)-------IDQ ( Informatica Data Quality ) Developers(CA)
manisha mandhva
· 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
IT Recruiter,